Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,801 through 37,815 (of 59,098 total)

RE: How to convert int primary key to uniqueidentifier

Joe Celko (7/3/2010)
You have no idea what you are doing. You want to mimic 1950's pointer chain file systems In SQL and have no idea what an RDBMS really is....
--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)

July 4, 2010 at 10:26 am

#1188617
Reply To: How to convert int primary key to uniqueidentifier

~~My advice would be.... don't do it.~~
UPDATE:
The advice above is incorrect. Please see my post below at
https://www.sqlservercentral.com/forums/topic/how-to-convert-int-primary-key-to-uniqueidentifier#post-3946514

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

July 3, 2010 at 6:44 pm

#1188590
RE: hi i need cursor program

rajendra prasad-377679 (7/2/2010)
hi dude
hey can u send me the sample table with queries by using trigger..
Regards
prasad
So! Dude! What did you end up doing?
--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)

July 3, 2010 at 6:10 pm

#1188589
RE: GETDATE() -vs- fn NOW()

Aren't those just ODBC functions?
--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)

July 3, 2010 at 6:06 pm

#1188588
RE: SQL 2000 Running Total Reset

TKyle (5/26/2010)
Wayne,
Quick question. Is is possible to calculate the running total in Jeff's script without updating a table, i.e. in a select statement? This is a...
--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)

July 3, 2010 at 6:04 pm

#1188587
RE: dividing a value by rowcount in fewest statements as possible?

haggisns (2/8/2010)
An elegant solution would be great to have and I could learn from it! 🙂
Thanks
Chris
So! Did you learn anything from it? 😉
--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)

July 3, 2010 at 5:50 pm

#1188586
RE: Need help to make this sql query

noor3rb (5/15/2010)
Hi everyone , i need help to do this query as i have two tables in database
1- First Table called "Accounts" which have the following fields
AccountIDAccountNameParentIDLevel
1x null0
2x111
3x1122
4x11133
5x11233
6x1222
7x12163
8x12263
9x12363
10x211
11x21102
12x211113
13x2111124
14x2112124
15x2113124
16x22102
17x221163
18x222163
19x223163
20x311
...
--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)

July 3, 2010 at 5:40 pm

#1188585
RE: need help with doing a sum and selecting records

deeomen (6/4/2010)
Posted - 06/04/2010 : 05:34:06
--------------------------------------------------------------------------------
hi all
very new to sql
i have one table, with 7...
--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)

July 3, 2010 at 4:42 pm

#1188581
RE: cast/convert with no trailing zeroes

Ah... I believe I see... the forum code (or something else) added a spurious ^C_R character. If you get rid of it, the previous code works just fine.
DECLARE @test-2...
--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)

July 3, 2010 at 4:35 pm

#1188579
RE: cast/convert with no trailing zeroes

skcadavre (6/30/2010)
I agree with Gianluca. But if you insist on doing it in SQL, it can be done like this
DECLARE @test-2 AS TABLE(
id INT...
--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)

July 3, 2010 at 4:30 pm

#1188578
RE: Splitting One Row Data into Two Rows

Jeff Moden (6/10/2010)
scott.pletcher (6/10/2010)
You might want to look into the use of [0-9] and [^0-9] just to simplify the code a bit.
Except I've had some odd results sometimes from that...
--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)

July 3, 2010 at 4:28 pm

#1188577
RE: Recursive Trigger Question

Navi's (6/30/2010)
Hi,
I am getting the same error..
"Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)."
Can you tell me is it comes due to trigger call.
In my case,...
--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)

July 3, 2010 at 4:11 pm

#1188573
RE: Should DBAs Be the Protectors of Data?

Sean Josiah-454849 (7/3/2010)
Jeff:
thus systems have to have 100% uptime, people can't get sick or go on vacation, and nothing fills the round file. yet the world keeps spinning, and todays...
--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)

July 3, 2010 at 1:46 pm

#1188569
RE: What columns are eligible to be in non clustered index

xzd000 (7/3/2010)
Well, what about the property of the column to be used as such?
The emphasis is that - The table does not have primary key column. Does that fact...
--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)

July 3, 2010 at 12:03 pm

#1188559
RE: Should DBAs Be the Protectors of Data?

Heh... I do find it amazing that certain types of data are considered to be NOT mission critical... that is, until it's lost. 😉
--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)

July 3, 2010 at 11:57 am

#1188558

Viewing 15 posts - 37,801 through 37,815 (of 59,098 total)