Jeff Moden

Forum Replies Created

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

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
RE: Show data upto 2 decimal places but with exact values

Yes, I absolutely agree... any type of formatting should be done only in the GUI... if there is one...
But the keyword in the title of the thread is "Show"......
--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:21 am

#779179
RE: CrossTab Query-URGENT PLEASE!

C'mon... I know you're in a pinch but stop and think about it... we don't know what your SalesDetails detail table looks like, we know nothing about the data in...
--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 7:59 am

#779175
RE: Using PATINDEX to find all numeric values

Oh... be careful, now... IsNumeric cannot be equated to IsAllDigits. IsNumeric will allow currency symbols, $, comma, decimal point, spaces, tabs, and a host of other individual characters. ...
--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 16, 2008 at 11:10 pm

#779152
RE: CLR Profiling

This was a pretty interesting question with no responses and I have no idea of what the answer might be... anyone got any idea on this, at all?
--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 16, 2008 at 10:34 pm

#779150
RE: Execution Plans

... and when it comes to % of batch, it can still lie!
--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 16, 2008 at 10:06 pm

#779148
RE: Check if table exists

EDIT:
I originally (incorrectly :blush: ) suggested do something like this... but, as Peso pointed out below, it's going to throw an error if table doesn't actually exist. My appologies...
--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 16, 2008 at 10:02 pm

#779147
RE: How to insert date in to particular table using csv format file

OP has "left the building"... 😛
--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 16, 2008 at 9:51 pm

#779146

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