Viewing 15 posts - 18,481 through 18,495 (of 26,484 total)
Before you start looking deep into partitioned tables I have one question for you, are you running SQL Server 2005 Enterprise Edition or SQL Server 2005 Standard Edition? This...
November 4, 2009 at 8:45 am
newbieuser (11/4/2009)
cast(convert(nvarchar(20), getdate(), 101) as datetime)
Instead of the above, I'd use the following in MS SQL Server:
select dateadd(dd, datediff(dd, 0, getdate()), 0)
November 4, 2009 at 8:39 am
Gus, you beat me and you provided additional info that is quite appropriate. Three thumbs up!
November 4, 2009 at 8:22 am
You can easily answer this question yourself. Before running the query in SSMS, set it to also return the Actual Execution Plan and review the plan. You should...
November 4, 2009 at 8:21 am
q123126 (11/3/2009)
select right(convert(varchar(18),getdate(),100),7)Is that right?
Works on my computer at home.
Edit: Except you need to change the varchar(18) to varchar(19) or varchar(20) as I originally posted. You could also...
November 4, 2009 at 6:23 am
Okay, I bit the bullet and I am now on twitter, @LynnPettis. So, who else is out there?
November 3, 2009 at 9:47 pm
JonJon (11/3/2009)
WHen I moved to sql 08, I added more indexes but things were working well for a month.
My issue just started. When...
November 3, 2009 at 9:07 pm
Not with the information provided. lease read Gail's article about asking for help with performance issues (the second article I have referenced below in my signature block).
November 3, 2009 at 8:52 pm
Here is the code I developed.
declare @time decimal(4,2);
set @time = 14.23;
select right(convert(varchar(20), dateadd(mi, (@time - floor(@time)) * 100, dateadd(hh, floor(@time), 0)), 100), 7)
November 3, 2009 at 8:27 pm
anitha.cherukuri (11/3/2009)
it was stored in below format14,23
15,59
12,12
13,45
what i wwant here
14,23 =2:23 PM
15,59=3:59 PM
tahnks
Being in the US, I am assuming the comma (,) is just like the decimal point (.)...
November 3, 2009 at 8:21 pm
Okay, it is a decimal value, how is it stored? Please provide a sample of the data.
November 3, 2009 at 6:37 pm
I'm not sure what you are asking. Can you explain better what you are trying to accomplish.
November 3, 2009 at 3:43 pm
True, which is why I would actually try the other way first.
November 3, 2009 at 3:38 pm
Of course, the right way to do it is to rewrite the process as a set-based query.
November 3, 2009 at 3:38 pm
Viewing 15 posts - 18,481 through 18,495 (of 26,484 total)