Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,261 through 46,275 (of 59,095 total)

RE: Aggregate bit operator in TSQL

Peso (12/31/2008)
SELECTMAX(SIGN(col1)),
MAX(SIGN(col2)),
MAX(SIGN(col3))
Simplicity personified.
--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)

December 31, 2008 at 7:00 am

#919614
RE: Cursors Be Gone!

Tom.Thomson (12/31/2008)
Just add "FAST_FORWARD" and "STATIC" to the cursor definition and the cursor method will run as fast as your non-cursor method (and for large datasets it will...
--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)

December 31, 2008 at 6:58 am

#919611
RE: varchar actual size

Jeff Moden (12/31/2008)
ta.bu.shi.da.yu (12/30/2008)
If you store more than 8KB of varchars (for instance a varchar(6000) and a varchar(5000) on one table) then you won't get that error. Instead, SQL Server...
--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)

December 31, 2008 at 6:04 am

#919574
RE: varchar actual size

ta.bu.shi.da.yu (12/30/2008)
If you store more than 8KB of varchars (for instance a varchar(6000) and a varchar(5000) on one table) then you won't get that error. Instead, SQL Server will store...
--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)

December 31, 2008 at 6:01 am

#919572
RE: Data Import In SQL 2000

Jay,
It's a bit of a misnomer... all single quotes must be turned into 2 single quotes... not actual "double quotes". And, start posting the actual query you used and...
--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)

December 31, 2008 at 5:55 am

#919568
RE: getting all records between 2 fridays of a given date

ta.bu.shi.da.yu (12/30/2008)
And Jeff's post is better formatted also 😛
Heh... 2nd formula turned out way shorter than the original... I get lucky like that.
NULL's format is a whole lot...
--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)

December 31, 2008 at 5:52 am

#919567
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Cool... I'll take a look. Thanks, Anzio.
--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)

December 31, 2008 at 5:48 am

#919564
RE: Update Query Issue

Jay Sapani (12/30/2008)
SSChampion The Update Quries Are
1. Update MyTemp Set DbfFileName = '2005.Dbf' ,TrExchng = 51
2. Update MyTemp Set MyKey = Str(TrExchng,2) + TrValNo + TrPtyCod + TrCurDt + TrPrdCod
These...
--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)

December 30, 2008 at 10:01 pm

#919434
RE: How can i drop database

Heh... thanks, JayDeep. Falls into the ol' "Must look eye" category.
--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)

December 30, 2008 at 9:43 pm

#919430
RE: varchar actual size

Jeffrey meant that if you give room for a mistake to happen, it will happen. You shouldn't make VARCHAR any bigger than necessary or you stand a chance or...
--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)

December 30, 2008 at 9:41 pm

#919428
RE: getting all records between 2 fridays of a given date

NULL has the right idea... just missing one second per week in the code. Using NULL's same idea, this is missing no seconds during the week...
SELECT *
...
--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)

December 30, 2008 at 9:28 pm

#919427
RE: getting all records between 2 fridays of a given date

Um... any business conducted during that one second missing out of each week? 😉
--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)

December 30, 2008 at 9:20 pm

#919423
RE: varchar actual size

What the heck... no table design needed... just store it all in one big ol' nasty EAV and call it a day... just think how easy indexing will be. :P;):hehe:
--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)

December 30, 2008 at 9:03 pm

#919421
RE: sp_OAMethod: Refresh pivot sheet without open

Let's have an instant replay on ol' helmut head spiking THAT ball... yep, there it is! A perfect 6 points, spiking the ball, and the ref didn't even call...
--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)

December 30, 2008 at 8:44 pm

#919418
RE: Partioned View

By the way... all that hooie about the view having to have explicit column names?... it's just that... hooie... a myth... a BOL error... That's IF the base tables...
--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)

December 30, 2008 at 8:34 pm

#919415

Viewing 15 posts - 46,261 through 46,275 (of 59,095 total)