Take a look at the first link in my signature for best practices on posting questions. Basically you need to post ddl (create table statements), sample data (insert statements) and...

GrassHopper (2/21/2012)

---

Sean Lange (2/21/2012)

---

You might want to add an IF EXISTS around both the create and drop statements. The way this is if you run it twice with the same...

And why the cursor? You should be able to this in a single update statement without too much trouble.

I have to admit I shudder everytime people on here talk about using Access...

You might want to add an IF EXISTS around both the create and drop statements. The way this is if you run it twice with the same parameter it will...

It is hard to say without more details but you say it is just a single query? You will be a lot happier down the road using a view instead...

Gotcha, the problem is that there is only an event on the table. Like I said, the view doesn't change, the base table is what changes. You got me stumped...

Sure here is the basic syntax...

Create procedure SomeProc

(

@Variable somedatatype

) as begin

insert SomeTable (Columns)

select Columns from SomeOtherTable

...

A view is not the data...it is...well a view of the data. You don't change the data in a view, you change the data in a table.

It seems there is...

I think the OP is looking for something like this:

select * from

(

select c.name as CarName, r.*, row_Number() over(partition by c.idCar order by date desc) as RowNum

from #cars c

join #rent...

SQLKnowItAll (2/20/2012)

---

Cool then maybe I can now feel like not being a snarly ogre. 😀

What do you mean? Please see the first link in my signature about best practices for posting questions.

This is relatively simple but without ddl (create table scripts) and some sample data (insert statements) it is not likely you will get much help. Please provide as already requested....

Are you doing any actual processing of anything in here? This looks like nothing more than a select statement? If so, then a view is probably a better choice than...

You will probably have...