Search results for query: *

Hello, I am jsut wondering how I can use decode in procedure in an insert into statement...here is what I try to accomplish... insert into table select field1, field2, (if field1 = this, and field2 = that) then 'thisthat' as field 3 from other table Thanks in advance for any help

Hi, I got an error trying to pull in the procedure I created in Oracle. The error said "Invalid Cursor" Is there any other way to call the procedure in Crystal? Any help will be appreciated.

I am just wondering if there is a way to remove the very last character in a field. Thanks in advance for any help.

Is there a query that I can use to check sizes of tables in Sybase?

I have a problem of trying to export tables from Access to Sybase server. But I keep receiving error saying: "reading from server timeout". Does anyone know the cause of that and the resolution. Thanks in advance for any help.

I have a problem of trying to transfer tables from one Sybase to another Sybase. But I keep receiving error saying: "reading from server timeout". Does anyone know the cause of that and the resolution. Thanks in advance for any help.

Hello, just wondering if it is possible to change the modified date of a file in Windows without actually openning it and saving it.

Hello, I am just wondering if there is any way to write all the information of files in a directory to a text file. (i.e. Name, Size, Type and Modified)

I have a parameter to allow users to enter as many values as they want and they will be used in Record Selection. I would like to print these parameter values on the report. I know I can use maximum and minimum for the upper and low bounds, What about those in between? say the user enters 10...

Hello, This is the scenario. I have a table with saleperson, sale, and paid and some other columns. one saleperson may have multiple records in this table. What I want to do is to compare the paid and sale column. If any of the records for that saleperson with sale > paid then I will update a...

I am just wondering how I can remove a column from a table. I thought it would be alter table (table name) alter column (column name). But it gave me an “Incorrect Syntax” error. Thanks in advance for any help.

I have a field with char type and 17 in length and user entered various length of data in it. Some are 5, 10, 12, 14 or 15. But the last character is the one in interest. I am just wondering how I can run a query to get the last character of that field. I have tried substring, char_length...

Hello, hope someone can help. I want to get data for last quarter with any given date. E.g. for today's date, I would like to run the report for 10/1/2002 up to 12/31/2002. For next Thursday, I still want to run the report for the same quarter. However, for two months from now (any date in...

Hello, Hope someone can help. I have a Access db and a column containing a lengthy value (something like a couple of short paragraphs). I would like to display it on a ASP page but it displays the paragraphs in one big block continuously without a break in paragraph like the original format...

Hello, I have a table and would to get those duplicate records based on only five columns in the tables. For instance, if column A through E are the same, then they are the records I want to show up. Is there a methodology to handle this? Thanks in advance for any help.

Hi, I want to calcualte the penalty on itmes clients checked out and became overdue. Here is the penalty I would like to calculate. If an item have been over due for 15 days the first 10 business days would be free. Any calendar days after that (in this case, 5 days, including weekends) would...

Hi, I am using SQL Server 2K. But I am having problem using DTS. I tried to transfer about 10 tables from one Sybase server to another. However, when I scheduled it it only passed the first step which is to create table and it failed the next step which to copy data...I have been trying to...

I just have a question about the drilldown. I have drilldown on one of the fields in my group footer. On drilldown, it display Header, detail and the subtotal (in group footer). I am wondering if there is any way to subpress just the subtotal info and only display the Header and Detail info...

I just wonder how I can do square root calculation in Crystal 7. I believe there is no such function except in Crystal 8. Thanks for any help in advance.

I have a table with a column called salesmanID, when I sorted this column either in ascending or descending order, it is strange that some of the id of salesmanID are not sorted. For example, some of the 0098152's records are mixed with (sorted within)0098746. Is there a way to fix it. Thanks...