Viewing 15 posts - 47,551 through 47,565 (of 59,064 total)
Um... this is actually a cross post with a different name. The bad part about cross posting is that it split resources, the unsuing discussions, and the answers. ...
October 25, 2008 at 7:56 pm
Don'cha just love the feedback on some of these posts? 😛
October 25, 2008 at 7:47 pm
rbarryyoung (10/14/2008)
That just means that the default schema (dbo) should be used. In other words:Customers..FirstNameis the same thing asCustomers.dbo.FirstName
Not the same for performance, though... 😉
October 25, 2008 at 7:39 pm
A query is said to be a good query... until someone finds a way for it to run faster. 😀
In truth, if the query contains RBAR of any sort, it's...
October 25, 2008 at 7:34 pm
Heh... you can do it a bit easier than that... not sure it's even worth putting in a function...
[font="Courier New"]DECLARE @Year INT
SET @Year = 2007
SELECT ISDATE(STR(@Year)+'0229')[/font]
October 25, 2008 at 7:14 pm
Chris (10/22/2008)
THKZ SIMMONS IT WORKED ...
Really? Try these and see what happens... 😉
SELECT ISNUMERIC('3D2'), ISNUMERIC('3E2'), ISNUMERIC('1,000'), ISNUMERIC(CHAR(13)), ISNUMERIC(CHAR(9))
One way to beat this is...
SELECT ISNUMERIC('3D2'+'.d0'), ISNUMERIC('3E2'+'.d0'), ISNUMERIC('1,000'+'.d0'), ISNUMERIC(CHAR(13)+'.d0'), ISNUMERIC(CHAR(9)+'.d0')
October 25, 2008 at 6:56 pm
webconcepts (10/25/2008)
Thanks, by the way count again LOL first 5 inserts are for the month of 09.......:D
My fault... didn't copy the first line.
October 25, 2008 at 6:24 pm
yisaaacs (10/24/2008)
auth=2 ms,xslt=110 ms,wallet=531 ms,resp=136 ms,total=0.823 sec,meta-data=3 ms
i need to extract each integer with the corresponding name,...
October 25, 2008 at 5:56 pm
Heh... I don't know why people even bother with any standards at all. As soon as something needs to "go in in a hurry", all notions of standards and...
October 25, 2008 at 5:29 pm
Parul Sharma (10/24/2008)
October 25, 2008 at 5:01 pm
AnzioBake (10/24/2008)
either one of the following does what you are asking. The Second query is marginally faster...
Both methods use a "triangular join" which, because of the way it's used,...
October 25, 2008 at 4:59 pm
I think it would be best that if the function receives a NULL, it should return a NULL. NULL has the special meaning of "unknown" and changing it to...
October 25, 2008 at 4:38 pm
Try this...
SELECT COUNT(*)
FROM dbo.RentalHistory
WHERE FromDate >= DATEADD(mm,DATEDIFF(mm,0,'20080901'),0)
AND ToDate < DATEADD(mm,DATEDIFF(mm,0,'20080901')+1,0)
... and there's only 4 items in...
October 25, 2008 at 4:18 pm
Greg Snidow (10/25/2008)
October 25, 2008 at 4:01 pm
Viewing 15 posts - 47,551 through 47,565 (of 59,064 total)