Good day Guys,

The solution of converting from DT_NTEXT to DT_WSTR AND from DT_WSTR to DT_STR will work. As long as tet being converted does not exceed DT_STR 8000 characters. Which...

I always learn something new at SQLSeverCentral!!! 🙂

Thanks guys!!!

Hi Guys,

I agree with most comments on this question, asking us how many rows would bereturned should not have been the way to put it. As we know the answer...

Good Day,

I would go with Elliott Whitlow on this one.

I think it's important that we dont leave out the ultimate goal. Which is to eventually dump the data into a...

Also try doing tutorials... What is also a good learnig method is to do the T-SQL questions here on SQLServerCentral. They teach one a lot of things!

Yes, please share your findings drew..

Well done abhisheksrivastava85... I must say i did not see that one. :doze:

Syed Jahanzaib Bin hassan is on point. Simple but effective analogy.:-)

I'm sorry dude but you are going to have to do the digging for yourself. Koen Verbeeck has already pointed you on the right direction. In fact you would do...

Hi Guys,

I'm not a big fan of using sub-queries unless it is absolutely necessary to do so. I've amended the last part of skcadavre's solution (I hope you dont mind!!!...

I fully agree with ChrisM@home. The easiest way to wark on this is to break it down to smaller queries instead of looking at the entire query. Also please provide...

Something is wrong with that answer provided.

Alright,

Firstly, I would like us to move from the same premise. In my solution, I assumed the following:

- The tables (destination tables) have already been created or exist, TableName1,...

Hi Drew,

I've managed to build a small SSIS package that can iterate through the sheets of a spreadsheet, the unfortunate part is that it is not dynamic in terms of...

Good Day Andy,

Must say I think I like your work, simple and methodical!!! Version 0 is a very critical step that many Developers/Managers tend to ignore, they dive staight into...