Try taking the course from Pragmatic Works - pragmaticworks.com

I've been happily doing this for about 20 years now with various different tools. Your description is spot-on. Rather than being required reading for all members, it should be required...

Getting rid of xp_CmdShell was your original desire. Where I work I try to take a slightly different POV, which may help.

My private belief is not to do things...

Thanks, Steve - I wasn't aware of the quantity of a lakh. Now I am. One lives and one learns.

Mike

[ “It is not because things are difficult that we...

I don't know how many records you have ("1 lakh" ! 🙂 ) but you can import DB4 into Access easily enough, and then check it and then pull it...

From another forum:

"

Ken is right: you should use set-based commands to reduce your dataset to just those rows you want to see. Then let your display program handle the rest - it'll...

Maybe "I have not used Visio and feel its a great tool." would be more in tune with the marketing department

Seriously, tho',...

<>

Why not use an identity column ? There are plenty of number and letters available ! Leave the identity column as anumber until it is needed, and then convert...

I somewhat disagree with the author's conclusions. IMHO, there are a number of assumptions built in to the question, as stated. The main one is that "the output is not...