I have a small problem using a reporting tool against Oracle. I am trying to run a report that directly access table using SQL statements. The thing is, that based on how much data it can retrieve, it would pull the data differently. What I am doing specifically is as follows: If the user running the...

Hi experts, I have a stored procedure and when I got an sql error I want to be able to retrieve the full message... Here is an example: When I try this using query analyzer: select * from InvalidTable I see this message: Server: Msg 208, Level 16, State 1, Line 1 Invalid object name 'InvalidTable'...

Ok, hopefully this is an easy one for you. The following is a part of a SQL statement I am running. LTRIM(RTRIM(LTRIM(RTRIM(ABCHCD) + ' ' + CAST(ABABTX AS VARCHAR(10)) + '' + RTRIM(ABACCD) + ' ' + RTRIM(ABAECD)+ ' ' + RTRIM(ABFXCD) + ' ' + RTRIM(ABDFCD)))) ABFXCD...

Hi all, I'm having this problem. When I print from my VB application to Crystal Reports, I get this error message.. "SQL Server Error '20527'" Any idea as to what's causing this? Thanks! Puay Aun

Background: I have an Excel file, used for data tracking purposes, with columns of information changing depending on the month and year when the file was downloaded from the server. I can't tap into the server using SQL or something else, and I can't stop the output file from randomizing some...

I have a project I am still working on that I got some outstanding help on from one of the Access guru's, GrahamMandeno. I have an issue I am trying to resolve. Basically, I have a form that allows the user to print BOLs (bill of ladings). They select the carrier/trailers they want to print from...

Hello, I am quite certain we cannot use the LIMIT clause for what I want to do - so wanted to find if there are any other ways we can accomplish this. I have a table which captures which user visited which store. Everytime a user visits a store, a row is inserted into this table. Some of the fields are...

Dear experts! I am struggling with a sql statement and can't get the correct join type to work. The problem lies at line 45: left outer join vt_tbl_arbeit_crit_date l on l.lng_gebiet = k.cnt_gebiet In table L vt_tbl_arbeit crit_date I have 13 rows for each "lng_gebiet" but need to output...

Hi Experts, i have a table the that have 2 fields (startDate, EndDate) of datetime type, and it save the date with the time hh:mm:ss, now i am trying to write an sql query that calculat the diffrents between these two fileds including the time for example startDate EndDate --------------------------...

I know there is a way to connect to a SQL Server Database using Excel and return a result set back by specifying a query. Is there a way to make changes to this data and write it back to a SQL table. Thanks!