How can I insert data without having null in each records using this temp table creation?
CREATE TABLE #InputIdTable (
GradeId int,BrandsIds int,ItemsIds int,ProgramIds int,dayspar varchar(200)
)
INSERT INTO #InputIdTable (GradeId)
SELECT DISTINCT
*
FROM SplitDelimiterString('15,2,3,8', ',')
INSERT INTO #InputIdTable (BrandsIds)
SELECT DISTINCT
*
FROM SplitDelimiterString('11,28,3,', ',')
INSERT INTO #InputIdTable (ItemsIds)
SELECT DISTINCT
*
FROM SplitDelimiterString('18,2,63,', ',')
INSERT INTO #InputIdTable (ProgramIds)
SELECT DISTINCT
*
FROM SplitDelimiterString('11,42,30,', ',')
INSERT INTO #InputIdTable (dayspar)
SELECT DISTINCT
*
FROM SplitDelimiterString('Sun,Mon,Tue', ',')
GradeId int,BrandsIds int,ItemsIds int,ProgramIds int,dayspar varchar(200)
)
INSERT INTO #InputIdTable (GradeId)
SELECT DISTINCT
*
FROM SplitDelimiterString('15,2,3,8', ',')
INSERT INTO #InputIdTable (BrandsIds)
SELECT DISTINCT
*
FROM SplitDelimiterString('11,28,3,', ',')
INSERT INTO #InputIdTable (ItemsIds)
SELECT DISTINCT
*
FROM SplitDelimiterString('18,2,63,', ',')
INSERT INTO #InputIdTable (ProgramIds)
SELECT DISTINCT
*
FROM SplitDelimiterString('11,42,30,', ',')
INSERT INTO #InputIdTable (dayspar)
SELECT DISTINCT
*
FROM SplitDelimiterString('Sun,Mon,Tue', ',')

Nitin SontakkePosted Jun 9, 2016, 8:46 AM