taking null

• swekik

  SSC-Addicted

  Points: 486

  More actions

  May 30, 2008 at 9:05 am

  #124000

  DECLARE

  @intCurrentRowId INT,

  @intMaxRowId INT,

  @fname VARCHAR(100),

  @lname VARCHAR(100)

  SELECT @intMaxRowId = MAX(intRowId) FROM [#tab2]

  SET @intCurrentRowId = 1

  WHILE(@intCurrentRowId<=@intMaxRowId)

  BEGIN

  SELECT @fname=fname , @lname= lname FROM [#tab2] WHERE intRowId = @intCurrentRowId

  IF(@fname IS NULL)

  BEGIN

  INSERT INTO #TAB3

  SELECT @lname

  END

  ELSE

  IF(@lname IS NULL)

  BEGIN

  INSERT INTO #TAB3

  SELECT @fname

  END

  ELSE

  BEGIN

  INSERT INTO #TAB3

  SELECT @lname+'.'+@fname

  END

  SET @intCurrentRowId = @intCurrentRowId +1

  END

  INSERT INTO #TAB3

  SELECT ISNULL(SUBSTRING(lname,1,1),'')+fname FROM #tab2

• ravichandra pasagadugula

  Newbie

  Points: 6

  More actions

  May 30, 2008 at 9:16 am

  #822403

  whats the problem in the script?

• swekik

  SSC-Addicted

  Points: 486

  More actions

  May 30, 2008 at 9:18 am

  #822405

  check urinbox

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  May 30, 2008 at 9:40 am

  #822424

  Please post your question so that we can try to help you.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass