Viewing 13 posts - 1 through 13 (of 13 total)
Much better than my rather convoluted calculation!
July 9, 2004 at 5:40 am
Thanks for that response - I fully understand and agree with your statements.
My problem, however, and perhaps I didn't really make it clear, is that the software suppliers update...
July 9, 2004 at 3:00 am
I think we need some more information before we can help!
Are you trying to match a record in your table with the exact date and time as the date and...
July 9, 2004 at 1:49 am
Thanks AJ Ahrens
There doesn't seem to be a simple solution!
I'll have a look at this and see about a function.
July 8, 2004 at 5:35 am
I guess it is just as rockmoose said, there are many ways to achieve this, and the CASE statement is the first one that came to mind! Nothing to...
June 21, 2004 at 5:30 am
The query needs to be complicated slightly if you want to see a two digit figure after the colon when the time difference has less than 10 minutes:
DECLARE @date1 DATETIME
DECLARE @date2 DATETIME
June 18, 2004 at 3:30 am
Thanks to you both, mimorr and Edward - I had already worked out where the problem was, and what the error meant.
My question was more around the error message...
June 17, 2004 at 8:52 am
If you add SET NOCOUNT ON to your sql, you will not get the (x rows affected) line at the bottom of the output. This should also take care of...
June 17, 2004 at 3:47 am
That is what I ended up doing!
I was just trying to keep everything tidy and not have to have an extra table holding this one value. It certainly was...
May 25, 2004 at 8:30 am
, thanks Greg.
Not quite sure how to go about that!
I'll give it a go, but in the meantime, if anyone has any examples, they...
May 25, 2004 at 5:18 am
Absolutely perfect - thanks!
I was obviously trying to complicate matters.
May 11, 2004 at 2:23 am
All you need to do, is put two = signs between your custom error parameter and the value e.g.
if %DOWNLOADEDALLFILES%==1 goto NOTREADY
if %DOWNLOADEDALLFILES%==0 goto END
Hope this helps.
March 12, 2004 at 8:34 am
I modified this a little to parse in the rowcount from the previous table which enabled me to create how ever many columns were needed.
December 3, 2003 at 7:58 am