Recent content by WhiteKnight57t

Sure can but what program are you using? possibly replace all + with & ========================== Sorry to be terse some say it's a curse I know it's worse I'm just diverse -Tim

there is no such function as Format! http://www.devguru.com/technologies/vbscript/quickref/functions.html ========================== Sorry to be terse some say it's a curse I know it's worse I'm just diverse -Tim

debug!! write out the String of the strSQL before you execute I bet a variable is missing!! ========================== Sorry to be terse some say it's a curse I know it's worse I'm just diverse -Tim

Define not working? is there an error message ========================== Sorry to be terse some say it's a curse I know it's worse I'm just diverse -Tim

you have to save Date as DateTime in SQl not smalldatetime Read Bol datetime data type, overview ========================== Sorry to be terse some say it's a curse I know it's worse I'm just diverse -Tim

Well you are trying to delete table called txtTableName What you want to delete is the Actual table name that you passed into the SP And By the way this is a very BAD idea for a stored procedure I'd be very worried that you delete tables this way! ========================== Sorry to be terse...

so anything not an aggregate function "AVG" has to be in the Group by SELECT Pid, AVG(qty) FROM Line_item Where Pid = '2' GROUP BY Pid ; ========================== Date is a way to show you care Time is a great healer DateTime is just damn confusing Tim

Always But always Make the relationships in the DB 1) it helps to maintain itegrity -- (spelling not a strong point) 2) 6 months down the road you still know what joins to what and how ========================== Date is a way to show you care Time is a great healer DateTime is just damn...

Donut You Star you ========================== Date is a way to show you care Time is a great healer DateTime is just damn confusing Tim

Now I read that his question as I have things running on processor 1 so can I set this to run on processor 4. To which I answered No ========================== Date is a way to show you care Time is a great healer DateTime is just damn confusing Tim

From my understanding server will run on one processor unless it finds a need to use more. ========================== Date is a way to show you care Time is a great healer DateTime is just damn confusing Tim

Really you are trying to convert the Date into strings to check! Not a good idea try converting as Lothario suggest but convert to a date And Convert your VBScript date too Convert(Datetime, CONVERT(NVARCHAR(15),FIELD_DATE,101), 101) and the VBScript Cdate(Datetext)...

Yes search convert in BOL ========================== Date is a way to show you care Time is a great healer DateTime is just damn confusing Tim

SELECT * FROM plat_calls.dbo.calls where year(calldate) = 2001 And Month(calldate) = 2 ========================== Date is a way to show you care Time is a great healer DateTime is just damn confusing Tim

What is wrong with calling you SP like this NoAnswerTest " & val("AcctNum") & ", 0, '" & Val("DDate") & "'" ========================== Date is a way to show you care Time is a great healer DateTime is just damn confusing Tim