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