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...

pcwc66 (12/13/2007)

---

It definitely helps me to understand about OpenDataSource. I'm working on a project to see how to create sample SQL databases (32bit/64bit SQL Server 2005/2008 including Express Edition)...

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

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...

GG (12/13/2007)

---

Hi,

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...

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...

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...

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...

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...

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...

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...

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...

meichner (12/12/2007)

---

I have been having trouble locating the answer to a question. When I add a Unique Constraint to a field on a table, does that automatically create a Non...

Scott Arendt (12/10/2007)

---

One of the goals that I have is to learn enough about CLR so that I can prevent developers from introducing it unless there is a justifiable reason...

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...