Search results for query: *

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

solution? 1. Rename the server back to the original name. 2. Script out all of the jobs and then delete them. 3. Rename the server to the new name. 4. Add back the jobs by running the script generated from step 2. ========================== Date is a way to show you care Time is a great healer...

You don't understand how a database stores date and time This starts off talking about ASP but then is really in general terms and is probably the most comprehensive overview of Dates and Times! http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=189 ========================== Date is a way to...

Clicking on the down arrow should open it as the Widest table name.. other than that I have no clue sorry ========================== Date is a way to show you care Time is a great healer DateTime is just damn confusing Tim

>Something about the dll not being registered. So why not register it ========================== Date is a way to show you care Time is a great healer DateTime is just damn confusing Tim

BOL is the place to go -- Check it out! Type in Create procedure ========================== Date is a way to show you care Time is a great healer DateTime is just damn confusing Tim