Can anyone verify this please??

Question

Can anyone verify this please??

Viewing 5 posts - 31 through 34 (of 34 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004405 More actions · Answer 1

After seeing that code, my immediate recommendtion would be to lookup INSERT/SELECT in Books Online (instead of INSERT/VALUES) so that when someone explains how to fix this, you'll actually understand. And no... I'm not being a smarty pants about this... I'm dead serious.

--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)

doran_doran SSC-Addicted Points: 411 More actions · Answer 2

So, would this be a good example?

http://technet.microsoft.com/en-us/library/ms189872.aspx

And how is it related to my post? Little Lost here..

Jeff Moden SSC Guru Points: 1004405 More actions · Answer 3

doran_doran (12/10/2009)
Little Lost here..

BWAA-HAAA!!! Apparently, so I am! :blush: My response was supposed to go on another post that I was looking at at almost the same time.

--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)

SQL-939141 Valued Member Points: 61 More actions · Answer 4

Wow - click on the error and it takes you there - FAB!

We need a 'handy tip of the day'!

This would have saved me hours by now.

I guess the trouble is that if you just pick up SQL Server after using other DBs (or much earlier versions etc) and don't go on training courses or have more knowledgeable peers then you just don't get to know these handy hints.

Mike Tanner

Garadin One Orange Chip Points: 29613 More actions · Answer 5

SQL-939141 (12/11/2009)
Wow - click on the error and it takes you there - FAB!
We need a 'handy tip of the day'!
This would have saved me hours by now.
I guess the trouble is that if you just pick up SQL Server after using other DBs (or much earlier versions etc) and don't go on training courses or have more knowledgeable peers then you just don't get to know these handy hints.
Mike Tanner

It took me years to realize that, and I started on SQL Server. I don't even remember how I finally figured it out.

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. 😉

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]