Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,501 through 52,515 (of 59,098 total)

RE: Identity Column in SQL Server - Transaction - MultiUSer

atarafder (2/17/2008)
Jeff, the requirement in my case is not to have contiguous ID's but to be 100% sure that there are no overlap of Id's between the two transactions.
...
--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)

February 17, 2008 at 12:23 pm

#779204
RE: CrossTab Query-URGENT PLEASE!

Thanks for the feedback and glad it suits your needs... now you know why I kept asking for more detail...
Folks, this is a perfect example of why I wrote the...
--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)

February 17, 2008 at 10:59 am

#779202
RE: Blackberry or smartphone for DBA

I don't know the differences between a Blackberry and a SmartPhone because I haven't had to carry either.
I with Johan, though... if you're gonna put a ball and chain on...
--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)

February 17, 2008 at 10:44 am

#779200
RE: How Can I accomplish this without using CURSOR

Never mind... I just had another cup of coffee...
Here's the untested answer...
--===== If the temp table exists, drop it
IF OBJECT_ID('TempDB..#tt_Mum','U') IS NOT NULL
...
--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)

February 17, 2008 at 10:31 am

#779199
RE: How Can I accomplish this without using CURSOR

ebuss_2004 (2/17/2008)
How Can I accomplish this without using CURSOR?? This is running extreemly slow since the t_ATM table has over a million records. Appreciate any help!
DECLARE
...
--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)

February 17, 2008 at 10:25 am

#779198
RE: CrossTab Query-URGENT PLEASE!

Oh yeah... for those in the know... yes, I used a triangular join in a correlated sub-query... performance will be terrible compared to the "UPDATE" method I wrote about, but...
--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)

February 17, 2008 at 10:22 am

#779197
RE: CrossTab Query-URGENT PLEASE!

Ta-da! See how much easier that is for folks to work with. Thanks for taking the time to help us help you...
Here's the solution including the test setup...
--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)

February 17, 2008 at 10:17 am

#779195
RE: CrossTab Query-URGENT PLEASE!

Now, we're cookin'... I'll be right back... 😉
--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)

February 17, 2008 at 9:54 am

#779193
RE: Identity Column in SQL Server - Transaction - MultiUSer

Ok... here's some extraordinary proof that supports what Itzek said...
First, I made a table in a nice safe place... TempDB... couldn't use a actual temp table because I wanted...
--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)

February 17, 2008 at 9:49 am

#779191
RE: Identity Column in SQL Server - Transaction - MultiUSer

Marios Philippopoulos (2/17/2008)
From "INSIDE MICROSOFT SQL SERVER 2005 - T-SQL QUERYING" by Itzik Ben-Gan, Solid Quality Learning, pg 429:
Another aspect of the IDENTITY property that can be considered a limitation...
--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)

February 17, 2008 at 9:13 am

#779189
RE: CrossTab Query-URGENT PLEASE!

Yeaah... I'm going to spend my time reformatting your data...
This is what your text file looks like...
SalesDate StockCode costPrice SalesPrice SalesAmount Total ----------------------- -------------------------------------------------- ----------- ----------- ----------- ----------- 2008-01-01 00:00:00...
--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)

February 17, 2008 at 9:03 am

#779187
RE: Fill Factor clarification

How does one determine if a page split has occured during an update?
--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)

February 17, 2008 at 8:43 am

#779184
RE: CrossTab Query-URGENT PLEASE!

erdem (2/17/2008)
Thank you very much for your replies...At least, you replied this question 🙂
My final data report should include just six columns:
StockCode
SalesPrice1
SalesPrice2
.
.
SalesPrice5
That's all..
But, you didn't read my previous reply... you've...
--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)

February 17, 2008 at 8:40 am

#779183
RE: Sequential numbering issue

Hassie (2/17/2008)
Thanks alot - this did the job
You bet... Thanks for the feedback.
Just remember...if the count of rows for each group starts to grow, the performance will suffer greatly very...
--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)

February 17, 2008 at 8:32 am

#779181
RE: Check if table exists

Peso (2/17/2008)
Msg 208, Level 16, State 1, Line 1
Invalid object name 'New.AddAnnex'.
Doh!... Thanks for the correction, Peter... that's what I get for late night posting. I'll correct that post...
--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)

February 17, 2008 at 8:24 am

#779180

Viewing 15 posts - 52,501 through 52,515 (of 59,098 total)