HanShi hit the nail on the head. SSIS, bcp and BULK INSERT use a mechanism for inserting data that is not like the INSERT statement. The first time...

I agree with Steve's assessment that programming is a core skill. I also feel strongly that a good portion of the population are loosing the ability to think for...

Dwain.c raises a very good point. Granted, I never implement something in production until it's been out for a while, but Win Server 2003 is pretty close to end-of-life,...

Erland is right - you only need one round-trip to the database instead of one for each row.

In .NET, when you bind data to a grid, it's usually done in...

That may just be it. I tried it having the sp_send_dbmail procedure fire the query with several different CONVERT functions using the XML in a variable and a table,...

Yes. We had an employees table that contained a lot fields. There were a lot of...

I thought I saw the solution to your problem as one of the XML data type being casted improperly when the result was returned and therefore being incorrectly populated in...

Is this what you're looking for?

declare @dtmPointInTime datetime = '03/15/2013';

select ms_id, startdate, enddate, NewRole, case when voided = 1 then 'Voided' else '' end Voided

from Audit2

where...

Sean Lange (7/9/2013)

What is failing? Are you getting an error message? Or is it a logic error? I am still confused as...

So what are you after here? Copying and pasting a few lines from the original post isn't of much help, since we've already read it.

If you're trying to control...

A good programming practice is to always drop your temporary stuff in the procedure when you're done. I know they're supposed to be destroyed when the session terminates, but...

Two things come to mind.

The first is that you have embedded returns in your DOS command, which means that you are saying to execute these 3 individual commands at the...

The tally table is definitely the way to go. Performance is through the roof. If you don't like using it inline because you don't understand it yet, you...

Erland Sommarskog - Author of several excellent writings and the host of sp_sqltrace. Very nice you see you here. Welcome!

1. I've never done an upgrade from SQL 2000 to 2008, so I'm going to leave that one alone.

2. I looked up the requirements for SQL 2008 and you're right...