Fatal Exception Error

Here is a challenge for you.

1. Compose a QOD that full fills the objectives of the QOD.

You might want to start by reading Steve Jones article...

Remember that this should be a group of professionals, and trash talk is not appropriate, nor appreciated by those of us who...

For a list of East Coast PASS chapters use this link

http://www.sqlpass.org/PASSChapters/EasternSeaboardUSA.aspx

Question: Does the UI use dynamic SQL or call a stored procedure?

Question. How long does the "deleted" row need to be...

The Stored Procedure (Sp) will add a new row (INSERT) to the TrailerInventory table. It could be rewritten to...

Warning - this code has not been tested extensively -- so you must do so before placing into production.

CREATE Procedure Dbo.TrInven

@DOTNumber INT,

@OwnerId INT,

...

Sorry to be so long in getting back to you

Think you might be referring to IDENT_CURRENT - check it out in Books On Line or

http://technet.microsoft.com/en-us/library/aa933217(SQL.80).aspx

I'm creating triggers that create/update a record in a history table as records are added to a master table. If a new record is added to the master, a history...

gil_500

Is the EXCEL work book on the same server as is your instance of SQL Server?

It should be noted that the Excel file must be located in the SQL Server...

This might help you.

http://www.sql-server-helper.com/tips/read-import-excel-file-p02.aspx

Basically you need to add to your openrowset command is: ;HDR=No

Excel 8.0;DATABASE=c:\temp\items.xls;IMEX=1;HDR=No

Have you attempted to use:

For your sp's use the following:

SELECT text FROM sys.syscomments

Note that the above will return the first 4000 characters of your procedure. With SSMS direct...

wendy elizabeth

Would it be too difficult for you to create a report that will NOT return any data and test what the report will show or do? And then...

Use the SELECT statment to be sure that you retrieve the required values, and when that proves to true, then change the SELECT into a UPDATE

CREATE TABLE #Table1(id INT)

INSERT INTO...

Lutz you WIN

Din not see imu92's solution before posting mine .. Imu sorry about that ...