Viewing 15 posts - 181 through 195 (of 207 total)
quote:
CREATE TABLE TBL (GRP INT, VALUE INT)
GO
INSERT TBL VALUES (1, 1)
INSERT TBL VALUES (1, 2)
INSERT TBL VALUES (1,...
December 12, 2003 at 6:53 am
Check the sql for "select top 1 ..."
Inner joins can do some interesting things to data sets if not properly applied. You may have an inner join where what you...
December 11, 2003 at 7:05 am
I have a couple of options for you,
In the job add a step using an ActiveX script option and check the date. if the date falls into your "do not...
October 31, 2003 at 6:02 am
quote:
Thanks. It worked.I had to use CAST for the Where clause.
DECLARE @ID int
SET @ID = 1
SET @where = ' WHERE ID =...
October 31, 2003 at 5:32 am
The relational tables is definately a better solution. I had to build a quiz app and keep track of who answered what (the quiz was related to a contest the...
October 28, 2003 at 11:15 am
quote:
In my dreams. Useually it goes:quote:
It Ddesn't work
October 23, 2003 at 5:58 am
quote:
The "correct" answer seems incomplete to me. After creating the sp the developer would also need to grant access to other...
October 22, 2003 at 7:34 am
I only have a smll complaint, but that's cuz I'm not a guru yet =).
It would have been nice if we were told what the problem was that the programmer...
October 22, 2003 at 7:04 am
I agree with Chris. I had a project that required a daily report to be sent out in HTML format via email. I just sucked out XML and did a...
October 14, 2003 at 6:34 am
I have to agree. The way the question was worded, and the answers given, I answered there was no way to temporarily disable foreign keys.
It would have been better to...
October 13, 2003 at 6:31 am
quote:
I've been warned about using xp_cmdshell to do this is there a more secure way of doing this?
September 29, 2003 at 7:41 am
Doesn't there have to be an "END TRANS" for this statement? I'm not familiar with using transactions, but I could have swore you had to have an END in there.
...
September 29, 2003 at 6:43 am
quote:
Sorry guys i thot this might be related...the code below doesnt work for me...any ideas
declare @x...
September 26, 2003 at 8:31 am
Change your vbscript to this:
Dim XMLHTTP
URL = "http://localhost/test.asp"
set XMLHTTP= CreateObject("Microsoft.XMLHTTP")
XMLHTTP.Open "POST", URL, false
XMLHTTP.Send
I tested the code sample given there and found the same issue. The code above will work however....
September 26, 2003 at 7:26 am
Viewing 15 posts - 181 through 195 (of 207 total)