LOL Gila, thank you for the good laugh but I have to agree with your assessment. This whole thing is about cost.

Another spin on it using isnull in the case:

create table #tmpTST

(

MyBit bit NULL

)

insert into #tmpTST

select 1

union all select 0

union all select NULL;

select

case isnull(MyBit,0)

when 1 then 'True'

when 0 then 'False'

end...

I strongly feel the same. In fact, we needed another DBD in the recent past and couldn't find one so our HR paid for a study using Dice. They found...

I do agree faster copy/paste solutions work in a pinch, however spending time working your first SSIS solution will pay off down the road. First, you have new ammo for...

Definitely best to store your packages on a server share and add configurations if necessary. I bet the users machine was logged off or turned off.

BO

I agree if the process will be used going forward you should experiment with SSIS. Here are some steps I used recently to setup a similar process:

-----------------------------------------

Add flat file connection...

Thank you all for replying to my post. We ended up installing SP2 and that seems to have corrected the issue.

It really does come down to the purpose of the machine. Like Steve said we are human and tend to salivate over all the bells and whistles however what we...

Thank you very much for the reply. Sometimes it takes another set of eyes to see something so obvious. Your solution worked great. Basically I wanted a single query that...

You can review all the sites mentioned however the best thing you could do is purchase a good book on t-sql and get a copy of SQL Server DEV or...

I wouldn't waste time on clowns that are obviously not professionals. This site houses professionals helping other professionals. There are professionals with varying levels of experience and then there's the...

As Lynn stated, it is very difficult to provide a good solution without table structures and sample data however here is another take utilizing CTE's. I have no idea if...

Before joining the ranks of the IT industry I was 110% involved in music. I played drums for over 20 years starting in the school bands and venturing to my...

BOL is going to be your best resource. It has all material you will need to pass the exam. You can purchase one of the MS books specific to your...

Awesome. Good to hear you have reached success.