Viewing 15 posts - 2,056 through 2,070 (of 3,221 total)
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...
March 3, 2010 at 7:24 am
kaspencer
Your reputation is now properly in the gutter.
Remember that this should be a group of professionals, and trash talk is not appropriate, nor appreciated by those of us who...
March 3, 2010 at 6:29 am
For a list of East Coast PASS chapters use this link
March 2, 2010 at 2:44 pm
I need to delete for UI proposes
Question: Does the UI use dynamic SQL or call a stored procedure?
Question. How long does the "deleted" row need to be...
March 1, 2010 at 3:33 pm
1) We're creating a stored procedure to handle the update. Right?
The Stored Procedure (Sp) will add a new row (INSERT) to the TrailerInventory table. It could be rewritten to...
March 1, 2010 at 3:07 pm
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,
...
March 1, 2010 at 10:00 am
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
March 1, 2010 at 6:55 am
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...
February 28, 2010 at 4:36 pm
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...
February 28, 2010 at 10:39 am
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
February 28, 2010 at 9:12 am
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...
February 28, 2010 at 8:31 am
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...
February 27, 2010 at 2:10 pm
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...
February 27, 2010 at 1:39 pm
Din not see imu92's solution before posting mine .. Imu sorry about that ...
February 27, 2010 at 11:41 am
Viewing 15 posts - 2,056 through 2,070 (of 3,221 total)