Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,216 through 37,230 (of 59,072 total)

RE: separate results hourly from a query

Info on the Tally table may be found at the following URL. http://www.sqlservercentral.com/articles/T-SQL/62867/
--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)

August 19, 2010 at 3:41 pm

#1209399
RE: separate results hourly from a query

I'd post a coded answer except I can't start a new message with code in it. The filters at work pick it up as a possible SQL injection attack...
--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)

August 19, 2010 at 3:38 pm

#1209395
RE: separate results hourly from a query

jerry-621596 (8/19/2010)
Thanks! Didn't even notice that. Was simply taking what he had and adding the ideas to it.
Sorry Jerry... didn't mean to direct that at you. Op...
--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)

August 19, 2010 at 3:37 pm

#1209393
RE: separate results hourly from a query

select pass_fail_indicator
from unit_status
where station = 'LG01-TIDASSGN-03'
and pass_fail_indicator = 'P'
and modified_date
between to_date('08/18/2010 08:00:00','mm/dd/yyyy hh24:mi:ss')
and to_date('08/18/2010 15:00:00','mm/dd/yyyy hh24:mi:ss');
TO_DATE is an ORACLE function. Use a Tally table for...
--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)

August 19, 2010 at 3:34 pm

#1209390
RE: DATEADD

m.kadlag (8/17/2010)
Hi All, I have a table with following structure:
ID
DATETIME
ID will be generated for different timestamps.
I have a small query to be written which will return the count of ID'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)

August 19, 2010 at 2:39 pm

#1209371
RE: Normalize a table query

bonggoy cruz (8/19/2010)
I have the following table:
ID, Description, Field1, Field2 ... Field9
Field1 to Field9 are all nullable fields.
I want a query to return as follows:
ID, Description, Field1
ID, Description, Field2
ID, Description,...
--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)

August 19, 2010 at 2:29 pm

#1209365
RE: DATEADD

You're welcome, Ron, and thanks for the feedback. I knew I did ok... just had no idea of how ok. Thanks, guys.
--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)

August 19, 2010 at 1:27 pm

#1209347
RE: The Logic, Mathematics, and Utility of NULLs

David Webb-200187 (8/17/2010)
Yep, that pretty well sums it up. I've been reading Hugh Darwen for a couple of days and working through Tutorial D and the Rel implementation. ...
--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)

August 19, 2010 at 6:26 am

#1209047
RE: Query to write for Report

khushbu (8/17/2010)
Not able to get the things working. Might be someone can help
My input table looks like
IDLogical_DrivesFree_SpaceSQL_ServerDate
0C ...
--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)

August 18, 2010 at 9:50 pm

#1208874
RE: Retrieving values of a tree structure into a table

Dan2010 (8/16/2010)
Hi, I have a table that has 2 columns as Child and Parent in the following form.
Child Parent
A NULL
B A
C A
D C
E C
F D
G NULL
The tree structure is as...
--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)

August 18, 2010 at 9:34 pm

#1208866
RE: ssis and ssrs interview questions

I just got done with a long run of interviews for a Sr. Systems DBA and an SQL Server T-SQL Developer. There were about 8 candidates for each job....
--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)

August 18, 2010 at 8:09 pm

#1208859
RE: Run SQL script with SQLCMD

Mohit K. Gupta (8/17/2010)
Jeff actually that does work without double quotes (just did it today :P); no issues :D. But I usually put -SServerName\InstanceName and avoid using "-" 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)

August 18, 2010 at 7:56 pm

#1208857
RE: replacing long running cursor

Chris Morris-439714 (8/17/2010)
Jeff Moden (8/17/2010)
Oh, I see it coming...
Heh Jeff got that porkchop launcher loaded up for the first triangular join post? 😀
Z'actly 😉
--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)

August 18, 2010 at 7:52 pm

#1208856
RE: How to tell difference betwwen empty string and one or more blanks

sgambale (8/17/2010)
A developer asked me about this. He did not elaborate except to say there were user issues involved.
I don't think anyone should need to distinguish between one vs...
--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)

August 18, 2010 at 7:37 pm

#1208850
RE: How to split character from string

Simplify with a real Tally table...
SELECT e.EmployeeID,LOWER(SUBSTRING(e.EmployeeName,t.N,1)) AS SplitChar
FROM #Employee e
CROSS JOIN dbo.Tally t
WHERE t.N <= LEN(e.EmployeeName)
ORDER BY e.EmployeeID
--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)

August 18, 2010 at 6:45 pm

#1208841

Viewing 15 posts - 37,216 through 37,230 (of 59,072 total)