Do you mean something like this?

CREATE TABLE [dbo].[Table_3](

[Col1] [nvarchar](50) NULL,

[Col2] [nvarchar](50) NULL,

[Col3] [nvarchar](50) NULL

) ON [PRIMARY]

INSERT INTO dbo.Table_3

SELECT NULL,NULL,'d' UNION ALL

SELECT 'X',NULL,NULL UNION ALL

SELECT NULL,NULL,NULL UNION ALL

SELECT NULL,'X','C' UNION ALL

SELECT...

Does your table contain a clustered index ?

I did NOT create this SP (Refer to the header for the author). But in testing it in my Sandbox DB it appeared to do what you desire to...

So a QOD instead of a birthday present for me .... ugh

L' Eomot Inversé (4/4/2012)

---

Nice easy question.

Like Hugo, I found it somewhat odd that only one option was provided for the result of step 2; it might have been a good...

Your Table:

CREATE table Temp(ID int, Name varchar(10))

--Inserting data for testing

INSERT INTO Temp

SELECT 1,'First' UNION ALL

SELECT 2,'Second' UNION ALL

SELECT 3,'Third'

The new table you need to create using your SP

CREATE TABLE...

+1

Error Level 16 indicates that the error can be corrected by the user.

From what you have stated, I am led to believe that there is more to your problem than...

Duplicate posting.. please reply here

http://www.sqlservercentral.com/Forums/Topic1277750-391-1.aspx

Wondered the same, but alas and alack after my...

An expansion on my prior post.

CREATE PROCEDURE [dbo].[usp_GetErrorInfo]

AS

SELECT

ERROR_NUMBER() AS ErrorNumber,

...

Are you familiar with a TRY CATCH block if not start here:

http://msdn.microsoft.com/en-us/library/ms175976(v=sql.100).aspx

Also please note if you post table definition(s), sample input and desired output you are more likely to get...

Modified your code, in an insiginificant manner to:

CREATE table Temp(ID int, Name varchar(10))

CREATE table Temp1(ADTID INT,ID INT,Name varchar(10))

INSERT INTO Temp -- Add 1 row of data to Temp

SELECT 10,'Some name'

SELECT...

It being a "bug"...

To illustrate the differences try this code

USE Northwind

GO

SELECT COUNT(4) AS 'Count by col number' FROM dbo.Audit -- counts nulls

SELECT COUNT(Item) AS 'count specific col' FROM dbo.Audit --counts only non null...