Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,771 through 37,785 (of 59,072 total)

RE: Strange UNION ALL behaviour

Gianluca Sartori (7/2/2010)
I decided to fix the thing using a table variable, but I didn't save the plans.
Just a thought... My recommendation would be to exercise the query that returns...
--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 11:50 am

#1188625
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Mike C (7/3/2010)
There are times when I recommend a T-SQL cursor over the alternatives, but they are few and far between. The issue though seems to be that there's...
--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:55 am

#1188622
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

jyurich (7/3/2010)
Yes, you are correct and I thank you for clarifying that point. However, typically when I'm inserting PK int values only into a Memory based temp table, I do...
--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:50 am

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

azadpeyma.parham 32837 (7/3/2010)
Hi,
I have implemented a database in SQL-server 2008. In all tables, I have set all the primary keys to int. (Still, there is no data in database.)
I want...
--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:40 am

#1188618
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

Viewing 15 posts - 37,771 through 37,785 (of 59,072 total)