Viewing 15 posts - 376 through 390 (of 411 total)
PCWC66, thanks for pointing out that article. It is one of the best best primers on SqlBulkCopy that I have seen. It is definitely a great technique...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 13, 2007 at 5:33 pm
pcwc66 (12/13/2007)
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 13, 2007 at 3:15 pm
You just need to alias it, for instance:
select achievetitle,achieveLevel, max(periodenddate) as Last_periodenddate
from Volume where ConsultantID = '0000288'
GROUP BY AchieveTitle, AChievelevel
order by Last_periodenddate
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 13, 2007 at 1:41 pm
My first question is, are you sure you want to do this? IF all of your databases are on the same server, you could place the stored procedure in...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 13, 2007 at 9:56 am
GG (12/13/2007)
Have you found a way to do this in SQL 2005 64bit?
Apparently there is a MSDASQL provider being released in Longhorn for 64bit , but I haven't been...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 13, 2007 at 9:31 am
There is no way of doing it without going outside of SQL in some way, but there are several ways of doing.
My recommendation would be use xp_cmdshell...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 12, 2007 at 10:21 pm
I had made the assumption that we were dealing with a procedure directly. I believe that if you are using a script which includes GO's the only way you...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 12, 2007 at 2:58 pm
What happens when your code hits the return statement? It is supposed to stop further execution and has always worked for me.
If for some reason return fails...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 12, 2007 at 2:02 pm
In Sql Server 2005 it would be
select *
from database.information_schema.tables
You can also use something like:
exec sp_msforeachdb 'Select ''?'', * from ?.dbo.sysobjects where name like ''search_criteria'' '
To find any object...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 12, 2007 at 1:57 pm
You could use the txt file with opendatasource/openrowset if you wanted, but it sounds like it would be easier to do it with a table inside of sql and then...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 12, 2007 at 11:34 am
As GAJ pointed out, the easiest answer is to use a cast or convert, but you could also go into the Visual Studio with that packet and explicitly format the...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 12, 2007 at 11:25 am
Here is another way to do it that keeps the case statement instead of a union. There is almost always more than one way to handle the problem:
declare @ReportType...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 12, 2007 at 9:43 am
meichner (12/12/2007)
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 12, 2007 at 8:38 am
Scott Arendt (12/10/2007)
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 10, 2007 at 9:53 pm
You are right that using a look up table only moves the problem one level deeper, but in doing so, it may make it easier to control and limit the...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 10, 2007 at 9:46 pm
Viewing 15 posts - 376 through 390 (of 411 total)