Hi Kurt it is complex but nice one,i thing you used CTE for update process i am stater of CTE as of now i have seen only select queries but...

try to replace the following part in your coding i hope it will work for you .

SELECT @lStr = N'DECLARE @tblAmount TABLE(LegalEntity VARCHAR(10), Amount MONEY );INSERT INTO @tblAmount (LegalEntity, Amount)'+

...

Hi Try the following script it will work for your reuirement

CREATE TABLE [practicedb].[dbo].[template_practice](

[LTM_INV_CD] [char](10) NOT NULL,

[LTM_TMP_CD] [char](9) NOT NULL,

CONSTRAINT [PK_template_practice] PRIMARY KEY CLUSTERED

(

[LTM_INV_CD] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...

Hi Try the following......

if exists(select * from sysobjects where name ='a')

begin

print 'passed'

UPDATE a

SET a.b = 1

...

Hey Guys,

Please check the following link there it is showing, Level is "SSChampion" for...