Recent content by cybercop23

Mighty, I have a similar issue. We use a pocketpc handheld that uses IE to gather some data. I need to print to a remote print server located by the mobile user from the ASP page. I was thinking of doing something similar where I set up the remote printers on the server so I can print to them...

Thanks All. I echoed the output to a file and read the file back in using the "for" command and tokens and it worked. Thanks.

Hi all. I'm trying asign the result of a find command to a variable that I can check. If the result is what I expect I can continue processing, else wait some more. This is what I mean: :checkdone set checkdone=dir done*.txt | find /c "done" if checkdone == 5 goto done sleep 60 goto checkdone...

Thanks a lot. Works like a charm.

Hi. I'm trying to create a batch file that will be kicked off by the command scheduler, that will in turn kick off three other batches at the same time. Each batch runs about 30 minutes, so I want to kick them all off at the same time, as opposed to sequentially. Here's what I mean: Commnad...

Thanks much George. Had to cast the Amount from char(8) to numeric, and it worked.

George, That what was in my example. When I divide, it loosed the cents. So 123456 should be 1,234.56, however cast and convert will result in 1234.0000. It looses the 56 cents.

Hi all. I have some data that I'm importing from an ODBC. The source data is money represented as 123456 (1234.56). I import it as char(8) but need to display it to the user as 1,234.56. I tried convert, but it truncates the cents: CONVERT(smallmoney, Amount/100) 123456 -> 1234.0000...

The field type is datetime. I want to sepate them because of two things: 1) need to create an index on date and don't think I would like the time included in that index and, 2) The user will access this data via an ASP page that will ask for the start date and end date for what they are looking...

Best place to start when wanting to publish MS SQL data is www.asp101.com. They have lots of examples. Just cut and paste the code samples and change the connection string. Don't forget to give the user you are using in the connection string access to the database and the table, view or stored...

Hi everyone. I'm loading 100s of thousands of records weekly that have a filed as DATETIME (12/26/2005 11:26:00). I would like to separate this one filed into two. A date field and a time field. I can do that using the cast function. My problem is that I also need to create an index using this...

That did it. Thanks.

Mercwrought, that worked, except that it gives me the date as mm/dd/yy 00:00:00:0000. If I add the cast to remove the zeros, it again complains that I can't have a cast in my group by. Pattycake245, MS SQL is complaining about the cast or convert in the group by. Since I have numerous records...

Hi all. I need to sumarize sales by day for the past month. The issue is that my date field is smalldatetime since I get updated sales every 15 minutes. Here's my select statement: select Str,CONVERT(varchar(10), [TimeStamp], 101) as SDate,sum(NetSalesAmount) as Sales from SaleUpdates where...

It's that easy. Thanks much for the help.