Search results for query: *

Cyrstal v8, MS Sql 2000 db. I'm trying to get the age, in days, of Workorder statuses. The statuses are stored in one table(wostatus) with a change date. Here's an example: wonum status changedate --------------------------------- 2932 WAPPR 2005-05-01 08:55:00.000 2932...

Using the BCP utility I can create CSV files with no problem. But I would like the ability to update an existing CSV file instead of creating a new one. Is this possible?

Crystal 8 Sql 2000 I have a report of Purchase Orders that is grouped by the order date based on the year. This works great but I want to group on the fiscal year instead. The fiscal year is 12/1 to 11/30. What kind of formula could I use to do this? I dont have or want any kind of data...

I'm using a batch file to delete files based on the file name. The file name is formatted like this: "log07-14-2004.txt" I need a way to take the current date in DOS and minus it by one day. Here's what i got so far: @echo on set currdate=%date% set mm=%currdate:~4,2% set dd=%currdate:~7,2% set...

I have a record selection fromula thats giving me some trouble. {equipment.eqnum} like "*"&{?Eqcode}&"*" Its works with one input parameter but when i check "allow multiple values", i get this error: "This Array must be subscripted. For example: Array[i]." The cursors lands between & and...

For some reason my Quick Launch Bar appears on the right end of the task bar. Is there a way to move it back to the left end next to the start button? I've already tried; rebooting,turning the bar off and back on, and dragging and dropping. Any other suggestions? Thanks Charles

I'm trying to query a table to find certain Glaccount codes. The datalength of the code varies, the maximum length of the code is 15, but I only want to find the codes that have a datalength of 10. Here's the catch; Some of the codes have only 10 char, but there will be a code that matches the...

Here's there a simple way to calculate a specific time based on a time + a number of hours and minutes. I.E. dim timein as date = "7:55 am" dim hours as decimal = "8.05" dim answer as date answer = timein + hours answer = 3:58 pm I've tried Datediff but it doesnt give me what i need. Any...

I have some character strings that look like this: PM-FV-CARS-TRUCKS-5k PM-FV-CARS-TRUCKS-10k PM-FV-CARS-TRUCKS-100k I would like to get just the number out of the string. i tried using this: declare @jpnum varchar(25) set @jpnum = 'PM-FV-CARS-TRUCkS-100k' select...

I tried this formula, and got the error listed above. if Length({equipment.eqnum}) = 9 then left ({equipment.eqnum},3) else left({equipment.eqnum},4) I just want to show the frist 3 characters of my field if the data length is 9. Otherwise show the frist 4 characters. Any help would be...

I need a forumla to give me a page number everytime a new page footer is printed. I'm resetting the page number after the group footer, but I would also like the number of pages in the whole report also. Thanks

I'm new to SQR, I was wondering if there is a way to call an existing SQL stored procedure from an SQR program? Thanks Charles

Happy New Year I have two issues, I hoping that y'all might be able to help me with. I'm running SQL 2000. One of my logins always list one particular Host no matter what machine it is logged in from. I deleted and recreated the login several times, but it still does the same thing. And its...

I'm querying a Excel spread sheet and would like the values that are returned to be contained with qoutes. Here's my query: SELECT * FROM OpenRowSet ('MSDASQL', 'Driver=Microsoft Excel Driver (*.xls);DBQ=c:\test', 'SELECT column1 FROM [sheet1$]') I want the results like this...

Is it possible to run multiple Stored Procedures like a single transaction? Example in the Query Analyzer window I run this: myproc '@p1','@p2,'@p3','@p4' go myproc '@p1','@p2,'@p3','@p4' go myproc '@p1','@p2,'@p3','@p4' go myproc '@p1','@p2,'@p3','@p4' go if one of these SP returns an error...

Hi, I ‘m trying to create a stored procedure with two variables that will do a simple insert into TableOne, and then insert into TableTwo based on the values inserted into Tableone, plus values that were pre-existing in Tableone. Heres an example TableOne: location...

Hello, I have an inventory report with account numbers as follows: 410003,413001,413002,413003,413004,416001,416002,416003, etc... I want to group the report using only the frist four characters of the account number, ie 4100,4130,4160. I used this forumla to create the group names,"left...

I want to create a sp to grant select rights on certain tables for certain users. I created the following query, but I get error messages. I have tried different data types with qoutes and without, but always seem to get the same results. Any ideas? Here's my test query: declare @name SYSNAME...