Heh... as always, thank you for your contribution to the pile of email I get. As you can tell, the SQL/_wt^f metric is still pretty much in the design...

Ummm... use the lower resolution? What do you consider to be a low resolution?

http://w3schools.com/sql/default.asp

There's nothing basic about being a DBA... can you be a little more specific as to what you're looking for?

Ok... just remember that you heard it from Ian first... this is the kind of stuff that you really want to do in the application if one is available. ...

Ian Yates (3/10/2008)

---

Oh wait, you're using sql 7 or 2000... The code I was going to suggest did some fancy string concatenation for you but only works in 2005. ...

Nice try, Lester...seriously... but ya just gotta make the shift from thinking in rows to thinking in columns. No more cursors, please... 😀

The following set based...

On top of all that, if you're trying to compare CHAR datatypes to VARCHAR datatypes, you may have to do an RTRIM on the CHAR datatypes to knock off any...

Oh... You really need to double check and make sure, Jack. As you probably know, Country Codes can be 1, 2, or 3 digits long... what you might not...

Ketulp... there's a couple of ways to do this... here's one full example that demo's two of the fastest ways...

--===== Create and populate test table. THIS IS NOT PART...

One of the cool things in the article on Running Totals... take a look at how the test table is built... I use something like it all the time... real...

Michael... lookup BCP OVERVIEW in Books Online and take a look at each parameter that Ross used in the code just above... it's the only way you'll start to learn...

Thanks for stepping in, Frank... I'm just not a DTS Ninja...

Great jobs with the explanations you guys!

Outstanding, Dan. Thanks for the feedback! Wish more folks would to that... 😉