My question is not a homework question. 🙂

My background is BI Development on Oracle, Teradata, Unix platforms. I am simply learning MS SQL Server and T-SQL.

And thanks for all your...

Lowell (4/14/2009)

recursion has it's place, of course, but it does not serve string...

Sorry for not posting back...

Yes, suggestion by Michael Earl had worked for me!

Thanks a lot for all help!

It is very usefull portal and forum.

Pit.

Hmmm...

Does it mean that recursion cannot be used in this example? Or it should be implemented differently?

Thanks,

Pit

Thanks a lot, Jack!

It all worked perfect! And performance with Tally table is great!

Thanks a lot for your help!

Pit.

D drive is local.

I tried three ways:

From BIDS - 1. execute standalone task...

I don't expect my data to exceed 20-30 min. I wouldn't need any special handling for such cases.

Thanks,

Pit.

Michael,

It's not I am arguing, but why SQL Server Online Help lists MOD function?

Pit.

Thanks a lot Michael!

It works fine.

Just curious, why MOD doesn't work in SQL 2008. Can I set some parameter to turn it on?

Thanks,

Pit.

Thanks a lot for reply.

Creating a table for global variables was my last resort. 🙂

Did exactly as you said - works perfectly now.

Thanks a lot for help!

Thank you! All works as I expect.

Great, thanks! It all works fine now.

I would've done the same on UNIX in 5 min! UI layers drive me nuts! 🙂

Thanks for your help!

Thank you Sahin. I...

Thank you for suggestion, I should've guessed it myself... 🙂

That's correct - I am loading data from pipe delimited files.

I've never had this issue on UNIX/Oracle/Teradata environment where I extract...