Viewing 15 posts - 2,371 through 2,385 (of 2,469 total)
It means that not everyone loves a smartarse.....
Take heart Remi - I'm sure you have the gratitude and admiration of the zillions of people you've helped this past year...who needs...
May 9, 2005 at 9:33 pm
Until someone comes up with a better solution - create a stored procedure to format the next number and insert into table by passing the input service date:
1) Declare variable...
May 9, 2005 at 12:41 pm
You're welcome! Maybe you can post feedback if this fixes the problem!
May 9, 2005 at 11:58 am
Ties in well with the other article on "order by" - despite language issues, the step by step approach with snapshots etc. is very easy to understand.
May 9, 2005 at 10:24 am
Hi - came across this in one of my searches.....
**********************************************************
The Oledb32.dll file is NOT upgraded when you upgrade from Windows 2000 to Windows Server 2003?
When you upgrade from Windows 2000...
May 9, 2005 at 6:44 am
Use -
WHERE username IS NULL
May 9, 2005 at 6:35 am
Have you tried using the dts import/export wizard in Enterprise Manager ?! That should be quickest and easiest.
May 9, 2005 at 6:17 am
This is by no means elegant but since the # of categories is UNKNOWN I cannot think you can avoid cursors.....something like this in a stored procedure/UDF ?!?!
CREATE PROCEDURE Get_Top3
AS
DECLARE...
May 7, 2005 at 5:59 pm
I hope you can set the datatype to datetime for all your date fields - I don't know how many other tables you are querying but it can really...
May 7, 2005 at 9:27 am
If there is a possibility of an empty string in that field then:
SELECT * FROM tblResponses WHERE LEN(Notes) > 0
would work better!
May 6, 2005 at 12:25 pm
are the "periodbegindate" and "weekofdate" columns smalldatetime datatypes ?!
May 6, 2005 at 8:01 am
Viewing 15 posts - 2,371 through 2,385 (of 2,469 total)