Can we see the before and after procs?

Well you see that a single query can achieve that. But since you can do it in asp have the coders present the data as the personel wants it and...

I don't see anything that could make this fail.

What about the application side of the code?

Have you reran the proc with the same parameters when you had a failure? ...

keep in mind that if you do something like this you'll have to use a permanent table to update the progress meter table.

This might cause so big problems if you...

Create procedure megaWork @param as int --...

as

set nocount on

--reset progress bar

--step one

--update progress meter tab

--have the application open another thread and query that progress table

--keep working on the process of???

--reupdate...

forgot to mention to create the view using : WITH CHECK OPTION

This will forbid them to change the region_id, so their information will always remain accessible.

1 - Create a table with all the usernames and associate it with their region

2 - Create table dbo.CORP

3 - Create view dbo.vwCorp

4 - Create a function that returns the...

2 options come to mind.

1 - Have the proc update a progress table in the database, then query that table every few minutes to update the progress bar.

2 - Split...

Do you have an identity column?

Do you have a date inserted column?

Select top 1 Col1, Col2 from dbo.YourTable order by IdentityCol desc

or

Select top 1 Col1, Col2 from dbo.YourTable order by...

Does this break the record for the most space wasted with useless junk on this message board or what?

Now that you know how...

1 - I would update my cv because a query like this would get me fired from any respectable job I'd have.

2 - This query ASSUMES that the item is...

Just do something like this :

Create function dbo.a (@someparam as int)

RETURNS TABLE

AS

return (

Select id from dbo.yourTable where Something=@Someparam

)

GO

Create procedure dbo.b @SomeParam as int

as

set nocount on

Select * from dbo.tableB...

Hey znkin, just make sure you have an index on trans_date and test both execution plans... you'll see which query runs faster .

You can't exec a stored proc in a function. You'll have to copy the select in that function or convert the stored proc to a parametered function.

k.. Good luck with this project.