urgent help needed with store procedure

• Vandy

  SSCommitted

  Points: 1827

  More actions

  December 15, 2006 at 3:52 am

  #193447

  Hi

  Actually i am running a report on sql reporting services 2000 my report has parameters of customer and it shows to Consolidate invoice for that customer. I want to give Invoice number to that invoice like 'CS19678' it depends on customer parameter when client choose customer then it will increment. mean for second customer it will show 'CS19679'. Is there anyway so that i can write one store procedure and when client pass customer parameter it will increment number automaticaly and store this number in a new table with customer code ,date and number......

  Thanks

• mimorr

  SSCarpal Tunnel

  Points: 4850

  More actions

  December 15, 2006 at 2:29 pm

  #678470

  Could you incorporate and identity column in your table and pass that to the client?

  
  
  Michelle