Viewing 3 posts - 1 through 3 (of 3 total)
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...
July 21, 2009 at 1:53 pm
#1027895
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...
July 21, 2009 at 1:08 pm
#1027869
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 =...
July 21, 2009 at 1:00 pm
#1027866