Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Specifying [TAB] as SQLCmd Column Separator

    Try creating the format file and Bulk insert using the format fil e

    format file goes like this , adjust as per your requirement (number of columns and columnnumber ) and...

  • RE: Trigger error

    Trigger will be called as many rows gets updated , so that should work ,

    USE [TRAIN]

    GO

    /****** Object: Trigger [dbo].[tr_CHECK_SRVSTAT] Script Date: 07/21/2009 09:47:25 ******/

    SET ANSI_NULLS...

  • RE: CASE Statement NOT working...

    Remove the "AND" and you all set if you need the "case" in select

    SELECT

    CASE

    WHEN ITM.MNR_CD = '100' THEN '15'

    WHEN ITM.MNR_CD = '105' THEN '10'

    WHEN ITM.MNR_CD =...

Viewing 3 posts - 1 through 3 (of 3 total)