Viewing 15 posts - 58,006 through 58,020 (of 59,048 total)
Nice.....
July 10, 2006 at 6:50 pm
You can really tell that Time has had to deal with this before
I share Ryan's sentiment... nice job!
Gail, thanks for the feedback......
July 10, 2006 at 6:36 pm
I always wait on "Very Urgent" requests like this that have such a simple basis... it usually means that someone is taking an SQL test as part of an interview and,...
July 8, 2006 at 11:05 am
Heh... what if there was nothing from yesterday, either? Peter's solution is good.
But, why is there even a need to check the date? Tomorrow's news will likely not happen today.
July 8, 2006 at 10:55 am
Sorry, I don't know Neetal... I'm pretty much at a loss on this one...
Can anyone else help on this? I'm neither and sp_oa Ninja nor a mail ninja...
July 8, 2006 at 10:52 am
If it was working before, then the devil is in the data...
What creates the IP address on the SMTP Server? If it's DHCP and someone rebooted it, it may...
July 7, 2006 at 10:17 pm
Gail,
I know you said you checked, but try this on the table that produces the error...
SELECT *
FROM Test
WHERE AMOUNT LIKE '%[^0-9]%'
July 7, 2006 at 10:09 pm
Yes, it's possible...
EXEC Master.dbo.xp_CmdShell "DIR d:\path\*.trn,d:\path\*.bkp /s/b"
If you actually want to use the file names, create a table with a nice wide VARCHAR column and do this...
INSERT INTO yourtable (widevarcharcolname)
EXEC...
July 6, 2006 at 6:57 am
I absolutely agree... for man-power scheduling purposes, ok... for simple reporting, doesn't matter.
July 6, 2006 at 6:39 am
Here's another way to find what the day of the week is without regard to @@DateFirst...
SELECT DATENAME(dw,GETDATE())
July 6, 2006 at 6:37 am
Or, you could do this...
SET @variable = ISNULL(@variable,0)
... for inline code, you don't even need to change the value... just use the formula...
SELECT ISNULL(@variable,0)
FROM yada yada
... OR...
SELECT yada yada
FROM wgga...
July 6, 2006 at 6:30 am
Thank you for the feed back on your resolution! It's a keeper... ![]()
July 5, 2006 at 10:29 pm
>Shouldn't need to index the view if the underlying tables are properly indexed Well that... |
July 5, 2006 at 9:58 pm
Shouldn't need to index the view if the underlying tables are properly indexed... indexing a view also requires the view to be schema bound and that all UDF's addressed by...
July 4, 2006 at 10:51 pm
Guess I'm being a bit picky here... where does @a or @b-2 parameters of the function get used in the function? I'm thinking the function posted has some other problems......
July 4, 2006 at 10:34 pm
Viewing 15 posts - 58,006 through 58,020 (of 59,048 total)