Hi Jeff,

Many thanks for posting this. If I could ask how I would go about modifying it to return the correct date and time based on an input of startDateTime...

Hi Noel,

Looks very interesting (if a little complex for my head). I'll have a go and report back.

Many thanks

Robert

many invoices depending on selection criteria. Result set contains line items for many invoices. Each line items needs to be assigned with an invoice number. Selected orders by project therefore...

Step 1 -- Receive selection criteria from Report Engine and parse as parameters into procedure

Step 2 -- Create Select Statement utilitising parameters

Step 3 -- Assign invoice number to each line...

Yoda - Oh how right you are!

Unfortunatly it is both. These are invoices that are being produced with Crystal and CSV output and inserting into a transaction table. I dont...

Hi Yoda,

I'd love not to use a cursor. Yes I am aware of UPDATE.

I just want to assign a consequetive number to each row of a temporary table. The number...

Thanks to all.

I'll read the doc and see if there are better ways to do this. I tried to search for such a document, but could only get the first...

Hi Kenneth,

The dynamic Select is a collection of IF statments that make up the where clause. I want to assign each project with an invoice number so intend to order by...