Got It guys ,

I just Convert Data Type to String [DT_STR]

I used the same one and also in DD part i am getting current date , but i need date from 06/18/2012 to 06/24/2012

How can i do that ?

I Got it guys , It was my mistake .

Insert into #Ashah (Invoice_Number)

values RIGHT ('0000'+Store#,4)+ RIGHT('0'+CAST(DATEPART(DAY,GETDATE()) AS varchar),2)

...

Still getting error in SSSS (Invoice format)

Thank you

SSCrazy

Thank you for reply But I am creating this invoice for only past 2 years.

And if i have store Number 12 or 121 how can i maintain "SSSS"

In my...

Number Date ...

Its going to be invoice by day , By Store . And for second invoice they will have correction column for that

3935 (6/21/2012)

---

Hey How are you there ?

I have to create stored procedure , i can do that but the difficult part is i have to add INVOICE and the...

3935 (6/21/2012)

---

Hey How are you there ?

I have to create stored procedure , i can do that but the difficult part is i have to add INVOICE and the...