Viewing 15 posts - 4,846 through 4,860 (of 5,504 total)
Garadin (10/28/2009)
October 28, 2009 at 2:53 pm
ssismaddy (10/28/2009)
for meselect convert(datetime,convert(char,getdate(),100)) it worked perfect.I just don't want seconds and msecs.
In that case I'd use
SELECT dateadd(mi, datediff(mi, 0, getdate()), 0)
It's supposed to perform better than converting...
October 28, 2009 at 1:40 pm
steyaert (10/28/2009)
October 28, 2009 at 12:54 pm
I just checked this thread again and figured that OP's last login was on 10/14/2009 9:30:22 AM (assuming, he's not using multiple nicknames).
So he missed all the solutions provided...
October 24, 2009 at 8:18 am
Hi torpkev,
would you mind removing the last word before your sig in your prev post?
Kinda crossing the line...
Btw: I'm not sure if this thread is feeding a troll (I'm not...
October 16, 2009 at 1:50 pm
Please read and follow the recommendation given in the first link in my signature.
It will help us help you.
October 16, 2009 at 12:50 pm
Roy Ernest (10/15/2009)
What is going on in THE THREAD? Wasnt there a Code ban on THE THREAD? :hehe:
[childish] It wasn't me who started it regarding the specific issue.[/childish]
Want me...
October 15, 2009 at 1:12 pm
Bob Hovious 24601 (10/14/2009)
That's how I interpreted it, Gail. This was my quick-and-dirty solution.
Sample code removed to limit the amount of actual code on THE THREAD.
if you can't...
October 15, 2009 at 12:56 pm
atharmon (10/13/2009)
I do appreciate result set processing over row level processing, but performance would really depend on number or rows.
Usually, such statement calls for some sample code to prove...
October 14, 2009 at 1:07 pm
Please provide more information on what you're trying to do.
It's hard for us to translate
"......
.....
"
into something that "manipulates all columns in the table"
We don't even know what table you're...
October 14, 2009 at 12:20 pm
steveb. (10/14/2009)
Well i guess it wasn't really urgent after all..
Or the UNPIVOT hint pointed him in the right direction (at least one of the directions leading to the expected...
October 14, 2009 at 12:06 pm
cjohn5552 (10/13/2009)
Thanks for your reply. The query is of the form:
select personID from people
where height = 'X'
and weight =...
October 13, 2009 at 4:47 pm
krypto69 (10/13/2009)
is this wrong?original way:
WHERE
isnull(datediff(dd,ld.delq_dt,getdate()),0) < 30
this:
WHERE
isnull(datediff(dd,ld.delq_dt,'2009-09-30'),0) < 30
Now I'm totally confused...
During the last couple hours I've been trying to explain how to get the data from the previous...
October 13, 2009 at 4:31 pm
I don't get any results either.
But this might be caused by the fact that I don't ave anything to test against. 😉
Please follow the first link in my signature...
October 13, 2009 at 1:25 pm
Viewing 15 posts - 4,846 through 4,860 (of 5,504 total)