Search results for query: *

SQLDenis - Thanks for the tip. However, wouldn't you know, I Googled again and found this Microsoft reference that exactly addressed funky db and table names just by adding another command line parameter: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_bcp_61et.asp...

I know, I know... Why do I have a database with a '/' in the name. But I do and with many processes already built around it, so renaming the db is out (for now anyway). This is the offending database name: deposit/loans My trouble is trying to bcp in a data file as such: bcp...

I like SQLBills idea, but I don't think that will work; when I tried to declare a variable, assign it a table name and select from that variable it errs out. Since you are using a curser anyway, why not just pull every column from the given table and disregard the results from the extra...

I suggest using the Dateadd() function - the function adds the number of hours/days/months etc (see your SQL help) The query would then look like: SELECT max(payment_history.date_paid) as ms FROM payment_history WHERE payment_history.date_paid between @start and dateadd(dd,1,@finish)...

Terry - Muchos Gracias for the code! It really did the trick! Your use with the Having clause was excellent. Thanks again!

Thanks wsmall73 - but that gets me service order ids that also may contain other products, not just update products. I just need service order ids that contain only update products and no other products. Maybe this illustration will help: ServiceOrderId ProductName 1 Website 1...

I need to pull only Service Order Ids that are made up of entirely a certain type of product. Service Orders can contain many Products (1 ServiceOrder to Many LineItems) and I am looking for Service Order Ids that only contain ProductNames like "Update" and no other products. Here are...

Where can I find the data for the Status History as presented on the ARWeb Ticket Status Page Particularly the Date, State, and Person for each status of the ticket? Any help appreciated!! Thanks

I am trying to upgrade my ASP to CR8 from 7 but my logon code does not appear to work (see below) - I have checked the samples and Seagate knowledgebase but no solution helped - what am I doing wrong? '--> CREATE THE APPLICATION OBJECT Set oApp =...

Trying to find correct syntax for using RDC via ASP to run reports via Web. I have looked at the Crystal Samples, the Seagate KnowledgeBase, and now here with no luck at finding something that would help - so I post. Here is my code - with the "suggested" modifications per Seagate KB...

YES - what a huge pain. Took me 3 days to figure this out just after we had upgraded our server. Our problem was when we tried to export to Excel - it worked fine on the old machine - not on the new. Check in what would be your rptserver.asp file - there is a constant set there that IIS cannot...