All Tags » sql (RSS)

Browse by Tags

  • Conditional SQL

    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...
    Posted to Queries (SQL) (Forum) by microsoft on 03-12-2010
  • Stored Procedure - Get Error Message Description

    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'...
    Posted to MS SQL Server (Forum) by microsoft on 03-12-2010
  • White space issue with SQL concatenate statement

    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...
    Posted to Queries (SQL) (Forum) by microsoft on 03-12-2010
  • Error '20527'

    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
    Posted to MS SQL Server (Forum) by microsoft on 03-12-2010
  • How do I query an Excel 2007 table using VBA in Access 2007?

    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...
    Posted to Access (Forum) by microsoft on 03-12-2010
  • How do I pass a toggle/switch to validate what type opf records to print?

    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...
    Posted to Access (Forum) by microsoft on 03-11-2010
  • Sql Query - Limiting query results

    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...
    Posted to Queries (SQL) (Forum) by microsoft on 03-11-2010
  • Joining problem - really urgent

    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...
    Posted to Queries (SQL) (Forum) by microsoft on 03-11-2010
  • Get Date and time different in SQL

    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 --------------------------...
    Posted to Queries (SQL) (Forum) by microsoft on 03-11-2010
  • Write to SQL Server Table from Excel

    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!
    Posted to Excel (Forum) by microsoft on 03-10-2010
Page 1 of 371 (3703 items) 1 2 3 4 5 Next > ... Last ยป