Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,706 through 36,720 (of 59,072 total)

RE: Generate AccNo in SQl

bitbucket-25253 (9/17/2010)
I would suggest reading the following
http://www.sqlservercentral.com/articles/Datetime+Manipulation/61822/
AND the comments on the article describing some different approaches.
Oh my, no. Sorry Ron.
@Jeev... you're just asking for a computational...
--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)

September 18, 2010 at 6:06 pm

#1223536
RE: SSRS 2008 sp1 Page Break - on multi grouping

Heh... I thought that SSRS was supposed to be simple to do stuff like this with. I'm thinking about learning SSRS (it's a 4 letter word to me :-P)...
--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)

September 18, 2010 at 6:01 pm

#1223535
RE: Syntax for creating a table on the fly

Joe,
Here's a bit more information...
First, open up BOL in the INDEX mode and do a search for "SELECT clause" (without the quotes on any of these lookups), and then make...
--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)

September 18, 2010 at 5:54 pm

#1223534
RE: Syntax for creating a table on the fly

Joe Contreras-290946 (9/18/2010)
I Google first looking for
dynamically building tables in SQL
Create table based on SQL
SELECT Into
I couldn't remember the exact syntax and it was driving me nuts. 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)

September 18, 2010 at 5:42 pm

#1223533
RE: I need some help with a test, please.

Perry Whittle (9/18/2010)
Hi Jeff
results attached. I have a HP laptop with win XP SP2, 3GB RAM and AMD Turion x2 1.9ghz
query took 23 mins 21 secs
Regards
Perry
Heh... I bought a brand...
--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)

September 18, 2010 at 5:36 pm

#1223532
RE: Syntax for creating a table on the fly

I have to admit that unless you know what you're looking for, this one is hard to find in BOL. GOOGLE? That might be a different story...
http://www.google.com/search?btnG=1&pws=0&q=how+to+create+a+table+using+select+%2B%22SQL+SERVER%22
--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)

September 18, 2010 at 4:36 pm

#1223523
RE: Table/View breakdown of occurences

Nicely done, Lowell. 🙂
--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)

September 18, 2010 at 4:32 pm

#1223522
RE: Using a common seed generation for multiple tables.

@Randy,
If you get a solution for this, please share it. And whether you get a solution or not, could you explain a bit more about why you need to...
--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)

September 18, 2010 at 4:30 pm

#1223521
RE: Using a common seed generation for multiple tables.

Eric Russell 13013 (9/17/2010)
Jeff Moden (9/16/2010)
I'm curious... Why do the folks that imposed this requirement think that it's a good idea to do?
There are a narrow range of data modeling...
--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)

September 18, 2010 at 4:28 pm

#1223520
RE: Need to zip and move C2 level audit files

Can't you just write a batch file loop for this?
--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)

September 18, 2010 at 4:22 pm

#1223518
RE: Unable to Get the correct results

LutzM (9/18/2010)
Side note:
You might want to consider reformatting queries with rather long statements to improve readability...
Since it's all upper case with a pot wad of underscores, I wonder if this...
--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)

September 18, 2010 at 4:18 pm

#1223517
RE: Get values in Single record

I agree with gah. Kingston's code does exactly what you asked for.
At this point, I suggest you read and heed the article at the first link in my signature...
--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)

September 18, 2010 at 4:12 pm

#1223515
RE: Convert CSV values in three columns to rows

Oh yeah... I almost forgot. Here's the default collation on my desktop box...
SQL_Latin1_General_CP1_CI_AS
... and on my server box...
SQL_Latin1_General_CP1_CI_AS
What we need to find out now is why XML seems to...
--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)

September 18, 2010 at 10:29 am

#1223478
RE: Convert CSV values in three columns to rows

Ok, Oleg... not sure what the differences are between your machine and the two that I'm running but the Tally table beats the two XML methods pretty badly on both....
--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)

September 18, 2010 at 10:24 am

#1223477
RE: Convert CSV values in three columns to rows

My tests DO reflect the total picture... just not on your machine. 😉 They show the test results on my machine. It's obvious that my machine is different...
--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)

September 18, 2010 at 8:05 am

#1223459

Viewing 15 posts - 36,706 through 36,720 (of 59,072 total)