DONT INSERT ZEROS

[100dtl]

Hi all,

I have a default row value is 0 so I dont need any more zero's, how do i alter this code so i dont add zero's

-- does the COORD x exist?
Set @cmd = 'insert into CARRSITE.dbo.temp ([ID]) (Select [Id] from CARRSITE.DBO.GERMNFR_COORD where [name]=' + cast(@x AS VarChar) + ')'
exec(@cmd)

select @eId=id from CARRSITE.dbo.temp
If @eId = 0
Begin
INSERT INTO CARRSITE.DBO.GERMNFR_COORD (NAME) VALUES (@x)
Set @eId=@@IDENTITY
End
if @columns is null
Begin
Set @columns = 'eID'
Set @values = cast(@eId AS varchar)
Set @where = 'eID=' + cast(@eId AS varchar)
End
else
Begin
Set @columns = @columns + ',eID'
Set @values = @values + ',' + cast(@eid AS varchar)
Set @where = @where + ' AND eID=' + cast(@eid AS varchar)
End

 

[hneal98]

Which part is coming up with the Zero's?

 

[100dtl]

Not sure but i think I've sussed it..

temp tables complicating matters

Set @eId=0
Select @eId=Id from carrsite.dbo.germnfr_coord where name=@x
If @eId = 0
Begin
INSERT INTO CARRSITE.DBO.GERMNFR_COORD (NAME) VALUES (@x)
Set @eId=@@IDENTITY
End
if @columns is null
Begin
Set @columns = 'eID'
Set @values = cast(@eId AS varchar)
Set @where = 'eID=' + cast(@eId AS varchar)
End
else
Begin
Set @columns = @columns + ',eID'
Set @values = @values + ',' + cast(@eid AS varchar)
Set @where = @where + ' AND eID=' + cast(@eid AS varchar)
End