I agree with Jeff that a date should be stored as a date in the source system (OLTP). I would try to change it. However, I know how...

Hi Jeff,

Good suggestion on using the date add + convert instead of a case statement.

Thanks for the advice.

John

Hi Lowell,

Are you talking about the new [dbo].[DelimitedSplit8K] function Jeff Moden wrote.

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Real cool stuff.

John

Please express any schemas that need to be created.

Please post the two tables you are referring to as CREATE statements.

Please supply the insert statements to populate the before mentioned tables.

A couple more ideas.

1 - When I was doing Oracle work in a past life, the TOAD utility had the ability to turn a record set in a data grid...

Hi There,

I usually do not promote products; However, red gates source control software plug in allows you to save data into SVN. This data then can be restored with...

Hi Kalpit,

The idea was to give you a general idea about the solution.

Modify the code to your hearts content.

The code below looks for the first 'procedure' marker and then the...

Hi There.

Check out Adam Haines reply,

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/29f30130-3a64-4b91-86b3-5fa09dbc4220/

1 - Use open rowset bulk to import data.

2 - Use bcp to export data.

You could use bcp to import, but use a...

Hi Kalpit,

A quick solution is below.

First, your @col variable was defined to small to hold the definition. That is the main problem I see here.

I am assuming the procedure...

So, you do not like my first solution? I totally agree it was the quickest thing that came off the press.

It is like life, if you spend a couple...

Hi geetha jasmine,

I would not use a pivot since that is used to turn row values into column aggregations such as sums.

Use two common table expressions, a full join, and...

Very true. However, life is shades of gray, never black & white.

Many of the applications that run on my boxes are vendor applications.

Some are vendors that do not...

Hi geetha jasmine,

I would not use a pivot since that is used to turn row values into column aggregations such as sums.

Use two common table expressions, a full join, and...

Maybe I'm misunderstanding param sniffing, but isn't the optimizer going to generate a plan and keep it until something changes (index rebuilt\reorg, stats update, table records added\deleted, etc...), and then...

Hi vsts dev,

SQL is a relational database. With that said, you should try to work with sets of data, not strings.

The solution below uses table value parameter to a...