Sounds like dynamic sql task here... What problem are you trying to solve?

I've been told to stay away from that include file so I'll forward that to you.

here's the bit that's missing :

response.write "No Of Records = " & rs1.fields("Fieldname").value...

Sorry didn't see this last question untill now...

just add

CASE WHEN datepart(m, tblInvoiceMaster.invoice_date) = 5 AND year_col = 2004 THEN...

Too much distraction here... can't post fast enough now .

Unles you preffer doing a count(*) for each table which can be slow, I would suggest you keep using the index technic.

If you don't want have out of date info,...

Hey Steve, is it possible to have the nightmare stories back up on the site someday? I'd like to reread some of those..

I'm sure you'll have a few questions after this one... Don't be afraid to ask.

Here's how I open a record set that uses a stored proc

proc code :

CREATE PROCEDURE [dbo].[SPNDemo] @ObjectName as varchar(50), @id as int output

AS

SET NOCOUNT ON

SET @id = object_id(@ObjectName)

SELECT

...

I like using the sys* tables... they are in every database and it avoids the time loss of making/deleting the temp tables... and I figured that my exemple was clear...

Never be sorry for not knowing something... be even less sorry for finding the solution .

sql = "EXEC sp_NoOfRecords" &_

" @VTitle='" & VTitle & "'"

rs.CursorLocation=adUseClient

Set rs = Conn.Execute(sql)

How did it get fixed?

And how the hell did you do that?????????????

Can you tell us in what situation?

Nice trick... but I thaught that the RecordCount problem was due to the cursor and lock type, not the location. Do you have any readings on this.

BTW it's the...

That's true... experience does come at a cost.

I'd like to come in a interview and answer that question : How much experience do you have with Sql Server

A : (while...