thomashohner (5/4/2014)
Do you use a While Loop or Recursive CTE to make your test data?
Niether, I spent this time researching how to do this and stumbled on a article by a very articulate fellow on this forum. However I do believe this comment may have been testing how ingnorant I am on the subject which incidentally is very much so.
Thanks look forward to putting your article in action.
http://www.sqlservercentral.com/articles/Data+Generation/87901/
Shucks... first, thanks for the "attention to detail" on one of your previous posts above. And I also say "Thank you" for the very nice complement. :blush: I'm humbled.
Shifting gears, it admittedly was a wee bit of a "test" to find out if you really meant that you already sussed the million row test table thing. If you were stuck on While Loops (mostly because of the poor functionality of RAND()) or rCTEs, I was going to suggest the very article that you posted back. Nicely done and good form on your part.
Just for convenience sake, here are the URLs for both of the "test data" articles.
http://www.sqlservercentral.com/articles/Data+Generation/87901/
http://www.sqlservercentral.com/articles/Test+Data/88964/
Last but not least and as you can see from the resposes that instantly popped up when you mentioned using rCTEs, here are a couple of articles to assist you in your research, if you haven't already come across them.
http://www.sqlservercentral.com/articles/T-SQL/74118/
http://www.sqlservercentral.com/articles/T-SQL/62867/
Getting back to the subject at hand and based on what's happened in this thread so far, I think you have the right attitude and will do very well whether it's something new or not. Never lose the nervousness. It's one of your best assets to drive you to success no matter what you do.
--Jeff Moden
Change is inevitable... Change for the better is not.