Help with coding in SQL

• tasnim.siddiqi

  Ten Centuries

  Points: 1063

  More actions

  July 9, 2010 at 2:51 am

  #234895

  Hi Guys,

  I am writing a stored procedure. My objective is to put a random number in a column of table, where the fields are null. So my column is App_ID. But the catch is, the App_ID column must have unique numbers and since I am generating numbers randomly there maybe instances when the same random number is generated. Therefore to take care of that I was using IF statement. So part of my code is below but I get an error "Invalid column name 'App_ID' ".

  DECLARE @temp int

  SET @temp = ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT)) --This code generates a random number

  IF @temp = App_ID --This is the part giving error.

  BEGIN

  UPDATE Event_Person_Info

  SET App_ID = @temp

  Where (NOT(App_ID IS NULL))

  END

  END

  I know why I get the error, its because App_ID is a column and @temp is variable. Since I want to check if the value stored in @temp is present within the column App_ID, if not present then I will UPDATE. Can anyone please help me how can I do this check within the column App_ID. Would be great if you could modify the given code.

  Thanks in Advance!

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  July 9, 2010 at 3:15 am

  #1190671

  This is an SSIS forum. I suggest that you raise this in the T-SQL forum here.

  ---