Do you use a While Loop or Recursive CTE to make your test data?[quote]
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.
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.
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.
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs