It may help if we can see all of the sproc. Maybe something else is causing the issue.

Mark

Here's a post that may be of some use:

http://www.sqlservercentral.com/Forums/Topic1236514-391-1.aspx#bm1236743

Mark

Set up the grouping within the tablix instead of 1 block of records:

http://msdn.microsoft.com/en-us/library/cc281376.aspx

Then use the AVG function as a footer to each grouping.

Mark

Here's a good explanation on the topic:

http://www.sqlservercentral.com/Forums/Topic1386707-391-1.aspx

Read the last post from GSquared.

Mark

It may also help if you post your current query and why you think it takes too much cpu utilization.

Mark

I agree with Lowell but if you must do it, try this. It's not fully tested but may get you started.

declare

@ID varchar(100),

@FirstName varchar(100),

@LastName varchar(100),

@Counter int,

@RecordCounter int

set @FirstName =...

You may want to look at how you store the numbers since having them with text makes it difficult to sort but this is a start:

declare @TTable Table(

House_no varchar(100)

)

insert into...

I'd have major concerns if they were the only ones that knew those passwords and why someone (her husband) outside the department/group (I'm assuming) is coming in and gaining...

It may also depend on what data you're returning. Are you looking for a set of records or a single value? If you can be more specific we...

You can use SSRS or create a small web site on an internal web server and create some basic .net web pages that act as reports and shows the data....

Post some actual values for your variables like @Offc. That may help identify the issue.

Mark

Sri,

Assuming Access is running the report on their machine, yes.

A better solution may be to make it web based to avoid Access altogether.

Mark

If your looking for a quick and easy way to get a fast query, sure, go with a flat table design. However, that doesn't exactly fit in to a...

Did you look at the execution plan on the query to see if there are any bottlenecks or possible improvements?

Do you have proper indexes on the tables based on your...

It's hard to say with out more information but you may need to us the update statement, not alter

UPDATE TABLE SET Fieldname = RIGHT(Fieldname , 2) WHERE LEFT(Fieldname , 4)...