Viewing 15 posts - 526 through 540 (of 3,221 total)
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...
April 9, 2012 at 7:16 pm
Does your table contain a clustered index ?
April 8, 2012 at 11:59 am
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...
April 5, 2012 at 5:44 pm
Koen Verbeeck (4/4/2012)
W00t! Steve approved my QotD on SSIS 2012. It will be published around 18th of April.
So a QOD instead of a birthday present for me .... ugh
April 4, 2012 at 8:16 am
L' Eomot Inversé (4/4/2012)
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...
April 4, 2012 at 8:10 am
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...
April 4, 2012 at 7:50 am
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...
April 3, 2012 at 8:36 pm
Duplicate posting.. please reply here
http://www.sqlservercentral.com/Forums/Topic1277750-391-1.aspx
April 3, 2012 at 7:38 pm
OzYbOi d(-_-)b (4/3/2012)
tks for the question.Wonder how many would have jumped at "6 columns" for STEP 2 if it were an option...
Wondered the same, but alas and alack after my...
April 3, 2012 at 12:17 pm
An expansion on my prior post.
CREATE PROCEDURE [dbo].[usp_GetErrorInfo]
AS
SELECT
ERROR_NUMBER() AS ErrorNumber,
...
April 3, 2012 at 9:25 am
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...
April 3, 2012 at 8:52 am
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...
April 3, 2012 at 6:52 am
Alex-668179
I do mind. But the data is only incorrect because of the bug in SQL Server that does not handle SELECT * correctly inside a view.
It being a "bug"...
April 2, 2012 at 4:31 pm
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...
April 2, 2012 at 9:05 am
Viewing 15 posts - 526 through 540 (of 3,221 total)