I see, so How can I encrypt the stored procedure?

michael vessey (6/8/2012)

---

wertyui (6/8/2012)

---

michael vessey (6/8/2012)

---

a couple of things here

1) remember to use...

michael vessey (6/8/2012)

---

a couple of things here

1) remember to use the WITH statement...

I have try what your suggest but unfortunately still the same result.

Thank you both of you for this help.

CREATE TABLE [dbo].[TransData](

[date] [smalldatetime] NOT NULL,

[acode] [varchar](6) NOT NULL,

[bcode] [varchar](30) NULL,

[amt] [numeric](15, 4) NOT NULL DEFAULT ((0))

)

INSERT INTO [dbo].[TransData](date, acode, bcode, amt)

SELECT '20110914', '6019','002',1427.1969

SELECT '20110914', '6019','001',454.3912

SELECT '20110914', '6019','002',99.6004

SELECT '20110914',...

@SSC-Enthusiastic

Thank you for your helping out.

yes, I would like to add it to where clause

DECLARE mySQL_cur CURSOR FOR

SELECT accno, accname

FROM tb1 T1 (Nolock)

LEFT JOINtb2 T2 (Nolock) ON T1.accno=T2.custcode

WHERE T1.date=@date and

GROUP BYaccno, accname

OPEN mySQL_cur FETCH NEXT...

Thanks Bro