Viewing 15 posts - 58,006 through 58,020 (of 59,054 total)
I guess I don't understand why no-one liked Ryan's first solution with the -275 thingy (although I'm not sure it will withstand a Leap Year). It was very simple and...
July 12, 2006 at 9:32 pm
You could easily turn this into a stored procedure or perhaps a table function...
--===== Define the input parameters
DECLARE @PropertyIDtoFind INT
DECLARE @MileageLimit DECIMAL(7,2)
SET @PropertyIDtoFind = 183297
SET...
July 12, 2006 at 8:55 pm
Must be a nasty copy'n'paste error... The code doesn't work as posted...
GO must be the only thing on a line...
Every /* must be match with an */...
...
However, I agree...
July 11, 2006 at 9:18 pm
Ken,
Your solution was fine, as well... I was responding to Fintan who apparently didn't read either of your posts very well.
July 11, 2006 at 6:26 pm
Look at the SELECT! That's where the meat of Ryan's example is...
Ryan's post was an example to demonstrate the method for using the "mon yyyy" format as a datetime that you...
July 11, 2006 at 6:47 am
Understood... you're not really changing the column type... just making it so it won't take bad data. Most vendor apps can withstand this type of change even if they've made...
July 11, 2006 at 6:29 am
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
Viewing 15 posts - 58,006 through 58,020 (of 59,054 total)