Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,476 through 35,490 (of 59,099 total)

RE: How to split a single record in multiple records based on a datetime period?

Rehman Rafique (1/6/2011)
Hey jeff, thnx for ur critical view on my code. it runs fine, i have tested it but it works for on equipment....just wanted to try another way...
--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)

January 6, 2011 at 8:27 pm

#1270391
RE: How to split a single record in multiple records based on a datetime period?

Jeff Moden (1/6/2011)
Heh... ok... I read further down and see that you really want SQL Server. 😉
Andrew is definitely on the right track with the Tally table but I...
--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)

January 6, 2011 at 7:02 pm

#1270386
RE: How to split a single record in multiple records based on a datetime period?

XMLDbJavaDev (1/5/2011)
Thanks. Oracle was only a way of an example. I am implementing the thing in SQL Server 2008 R2. Do you have something about it?
Cheers,
😎
Heh... why would you say...
--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)

January 6, 2011 at 7:00 pm

#1270385
RE: How to split a single record in multiple records based on a datetime period?

Heh... ok... I read further down and see that you really want SQL Server. 😉
Andrew is definitely on the right track with the Tally table but I believe he'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)

January 6, 2011 at 6:57 pm

#1270384
RE: How to split a single record in multiple records based on a datetime period?

XMLDbJavaDev (1/5/2011)
Thanks for your reply,
Data is stored in a table. I have the data in Oracle 9.2 and the resultant splitted can be a view.
Is that what you are asking...
--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)

January 6, 2011 at 6:49 pm

#1270383
RE: To start sql output frm the middle of the page

gnaneshs (1/6/2011)
Can u provide me the solution
GSquared gave you a correct solution but do you understand it? If not, I strongly recommend that you lookup the CAST function, 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)

January 6, 2011 at 6:12 pm

#1270378
RE: To start sql output frm the middle of the page

toddasd (1/6/2011)
declare @a varchar(100)
set @a = 'Number of files=4'
select substring(@a, 17, len(@a))
:blink:
--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)

January 6, 2011 at 6:08 pm

#1270377
RE: Interview

vinodh247 (1/5/2011)
Hi all,
Below are the q's I faced in the interview I've attended yesterday...if anybody knows all the best answer pls contribute.
1) Log shipping/Replication/Mirroring/Clustering-uses-steps to implement it
2) What will you...
--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)

January 6, 2011 at 1:08 am

#1269904
RE: How do you change the width of a displayed column?

C3PO-594572 (1/5/2011)
SQL Server is so inferior to Oracle its unbelievable!
Funny, I was going to say the same thing about Oracle. 😉 It can't even return a result set directly...
--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)

January 6, 2011 at 12:58 am

#1269902
RE: Do you use Facebook?

First, I think it's a shame that people don't talk on the phone anymore. At some companies, I've even had folks in the next cube IM me with questions...
--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)

January 6, 2011 at 12:51 am

#1269900
RE: Trust People

gserdijn (1/6/2011)
Dutch Anti-RBAR League
Heh... off topic a bit myself, I like your signature line... a LOT! 🙂
--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)

January 6, 2011 at 12:43 am

#1269898
RE: First time semi-complex query - its slow!!!

CELKO (1/4/2011)
>> do disagree with traversals to build the nested set necessarily being procedural and no, it wouldn't be a push-stack... CTE or not. And, yes, I do have...
--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)

January 6, 2011 at 12:20 am

#1269890
RE: change the following query to storedprocedure

koolme_85 (1/5/2011)
i did but now its throwing the arithematic over flow error
Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type datetime.
after i replaced...
--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)

January 6, 2011 at 12:01 am

#1269883
RE: Are the posted questions getting worse?

Oh crud... my apologies. Didn't mean to post (gasp!) code on "the thread". :pinch:
--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)

January 5, 2011 at 11:58 pm

#1269882
RE: Are the posted questions getting worse?

Brandie Tarvin (1/5/2011)
Any programming language that complains when I try to use 0 as a divisor should be taken off the market and all its install disks buried in 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)

January 5, 2011 at 11:53 pm

#1269878

Viewing 15 posts - 35,476 through 35,490 (of 59,099 total)