How to run a query to bring all the fields from each table
-
ROTFL!
You definitely have too much time on your hands, Jeff.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
Heh... couldn't resist, Barry.
Hey! Are you going to PASS this year? Sure would like to do some 12 oz. curls with ya someday. Bring your helmet so I can spot ya! 😛
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
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.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Atif Sheikh (8/5/2008)
Hi Jeff..I executed your script and, surprisingly, got an error. One of my databases was in the recovering status and raised error on that database.
So I altered your script a little bit in order to skip the database in the restoring state...
Atif Sheikh
Very cool, Atif. Thanks not only for the feedback, but for the fix as well... 🙂
Ya just gotta love a forum that has people that care. Thanks again.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
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.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Jeff Moden (8/5/2008)
Heh... couldn't resist, Barry.Hey! Are you going to PASS this year? Sure would like to do some 12 oz. curls with ya someday. Bring your helmet so I can spot ya! 😛
Oh, yeah, I'll be there. But I don't take the gear on boondoggles anymore, it;s just too darn hot. You'll just have to look for the guy with the worst case of helmet-hair in the house.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
Jeff Moden (8/5/2008)
Jack Corbett (8/5/2008)
Also mine does take advantage of a undocumented (by MS) procedure that could change or disappear so using sys.databases and the dynamic SQL is probably better.Heck... I wouldn't worry about that, Jack... they even take away things that ARE documented. 😀
Yeah that's true.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply