ARRRRGH! I always forget about STUFF().

I was also taught it was not polite to tell someone to "Stuff it" 😀

Depends on what you are doing with the data conversion. But anywhere between the source and the destination.

Awesome. I was wondering why you weren't using a table, but figured there had to be some reason.

It's not a valid datetime format for SQL Server. You'll need to massage the string before converting to a datetime. Something like this (assumes you always have 16...

Hey Tim,

I'm attaching a simple list report using AdventureWorks that I think does what you want and it seems pretty simple, but I may be missing something in your question....

Could you post some sample data to test with? Use the format in the first link in my signature line.

If you post the code you are using to get...

If you want the Month Name (August) then you would be better off using a ScriptComponent than a derived column as SSIS does not have a MONTHNAME functino like Visual...

I'm not exactly sure what your question is, but locks and blocks are expected in SQL Server, it's what allows data to be consistent.

As far as Deadlock troubleshooting...

I'd recommend starting by checking out Connection Strings.com[/url]. And also looking at any walk throughs that are part of the VB 6 documentation.

Jeffrey's solution will work, but you can do it in SSIS by adding a derived column transform which will add a new column called month with a value parsed out...

If I understand you correctly, I don't think it is possible to do what you want. My understanding is that you want to show a count of the items...

Kumar,

I am assuming you want to pivot the data so that it looks like this:

id name ...

I just noticed that you have posted in a SQL Server 2000 forum, so I won't post what I was going to post because it applies to 2005. If...

At least now you got some backup. I suppose I could replace...

Have you flushed the cache (obviously not in production) and then run the queries? I've never seen table order with all INNER JOIN's affect the results. Even if...