I have tried using instr. While running query for reports with lesser number of rows, it works fine. However when running query where Report1 has 40000 rows and Report2 also...

OK..

thanks.. i will use a data reader then..

thanks anyways..

Thanks Dave..

I am not able to open the website. Dont know why..

Can you please copy the entire stuff and email it to me at c.vaibhav@yahoo.com

thanks alot!!!

Regards,

Vaibhav

Thanks Gianluca.

Few questions:

1) Instead of #MyTable I need to put a query which joins two tables. I actually have two tables which contains the required data.

2) I want the user...

Hi,

Thanks for your valuable time.

I have written the query to create the table:

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

...

okay.. thanks for all your help.. lets close this thread..

i'll rather have a standard input for payment terms.. 30 PDC is too vague for computer to understand..

I am finally...

thanks arun..

but my payment terms has string value too..

I can convert immediate, advance to 0 however it also contains values such as 30 pdc, I want to be able to...

okay.. i got the following query..

DateAdd("d", PaymentTerms, InvoiceDate)

Here "d" represents day.. Payment terms represents number of days that needs to be added to invoicedate.. it should be in integer..

Sometimes Payment...

ohh.. thanks.. I got it done.. The query is:

select t1.price + isnull(t2.price,0) as totalprice from table1 t1

left outer join table2 t2 on t1.product=t2.product

regards,

Vaibhav

extra information..

the two tables that I am talking about are not physically present but they are created using a select statement..

Thanks..

Vaibhav

okay..

well following is the example.. I have made my requirement more specific..

this must help..

I have two tables with unique product name column and different quantity..

For eg:

1st table has following values

Product1...

no response..

Thank you so much for your time..

I tried to run the query that you have posted.. I think we are close but still not there.. When I run the query...