Viewing 15 posts - 16,636 through 16,650 (of 26,489 total)
sturner (3/9/2010)
Jeff Moden (3/5/2010)
sturner (3/4/2010)
try this:Select* from mytable
WHERE functionDate > CONVERT(char(10),getdate(),101)
that assumes all times are 00:00:00
It also causes a costly implicit conversion. Use the method that Lutz posted instead.
Not...
March 9, 2010 at 11:17 am
lmu92 (3/9/2010)
Lynn Pettis (3/9/2010)
lmu92 (3/9/2010)
So, please follow Lynns advice and change the join fom INNER to LEFT OUTER.
I think you want a RIGHT OUTER JOIN the way the query is...
March 9, 2010 at 11:05 am
Can you tell us the versions of both the server and SQL? Is one 64-bit and the other 32-bit?
March 9, 2010 at 10:46 am
Been quite awhile since I debugged a stored proc in SQL Server 2000. What error message(s) are you getting when you attempt to debug the procedure?
March 9, 2010 at 10:34 am
Please do not cross post. Please post all replies here.
March 9, 2010 at 10:30 am
lmu92 (3/9/2010)
So, please follow Lynns advice and change the join fom INNER to LEFT OUTER.
I think you want a RIGHT OUTER JOIN the way the query is currently written.
March 9, 2010 at 10:26 am
simflex-897410 (3/9/2010)
That ADDITIONAL table we just added maybe the problem because now, it has gone back to getting data that begin from March 16th.
Change the INNER JOIN to a RIGHT...
March 9, 2010 at 10:24 am
The following:
declare @ x varchar(99) -- space added between @ and x to allow code to be posted.
set @x=0x77616974666f722064656c61792027303a303a323027
select @x
returns:
waitfor delay '0:0:20'
Is there actually more in the logs? ...
March 9, 2010 at 10:18 am
For S & G's, change this:
INNER JOIN dbo.EventDescription ED ON DEP.EventID = ED.EventID
to this:
LEFT OUTER JOIN dbo.EventDescription ED ON DEP.EventID = ED.EventID
What do you get then?
March 9, 2010 at 10:09 am
LiteSpeed probably logs errors in its own log file(s) or the application log file, check those for additional information.
March 9, 2010 at 10:06 am
Both have pro's and con's. In the environment I work, cost saving is important, especially since they are looking at trimming 11 to 18 million from next years budget.
March 9, 2010 at 10:05 am
tom parks (3/9/2010)
March 9, 2010 at 10:00 am
You need to upload the image as an avatar, then it will show next to your posts.
March 9, 2010 at 9:45 am
Reporting Services comes with SQL Server 2005, why spend more money on Crystal Reports?
March 9, 2010 at 9:38 am
Viewing 15 posts - 16,636 through 16,650 (of 26,489 total)