Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: converting statement

    Code should be like:

    INSERT @table(CallID, GroupName, CustPendCase)

    Select * from (SELECT '00500588' as CallId,'Desktop' as GroupName,Null as CustPendCase UNION ALL

     SELECT '00500588','SD Followup',Null UNION ALL

     SELECT '00500600','Server',Null UNION ALL

     SELECT '00500600','Service Desk',Null UNION ALL

     SELECT...

    September 24, 2005 at 1:18 am

    #592825

Viewing post 1 (of 1 total)