+1

Definitely. The other method uses a While loop which might give performance issues.

Edited: Incorrect response removed.

raghuldrag (7/18/2012)

---

company_no location_no issue_no lot_no quantity confirmed_qt.... value ...

You can try logging into the system with Windows Authentication if you have administrator rights

You can then change the password for sa and also add new users

Does the above query work for you?

The table structure you have...

How did you decide on the lotno's?

Do you have any other columns in these 2 tables or any other tables associated with these tables?

compny location lotno amount

-----------------------------

A chen d77 3000...

You can change the query as below

SELECT*

FROMcte_Rooms R

WHEREEXISTS ( SELECT * FROM cte_Rooms RInn WHERE R.HotelID = RInn.HotelID AND R.RoomID = RInn.RoomID AND RInn.DenseRank = @diff )

SQL Server handles this by itself if you use the ISOLATION LEVEL as READ COMMITTED

You can check the below link for more details in Isolation Levels

http://msdn.microsoft.com/en-us/library/ms173763%28v=sql.90%29.aspx

The CTE method I could come up with

; WITH cte_Recursive( Parent, Child, RN, Level ) AS

(

SELECTT.Orgunitcode, T.Childorgunitcode, ROW_NUMBER() OVER ( ORDER BY Orgunitcode ) AS RN, 1 AS Level

FROM@TEMP AS...

geidy_killer89 (7/13/2012)

---

my database [sahia] the table [carti] i want to automaticaly change the [datead] field , with the curent date

when i insert or update a record. I've tried...

Your explanation is not very clear

Can you provide some more details along with an example and sample results

If you want to create an Index on a View, the View must be created using the "WITH SCHEMABINDING" option

This restriction has been enforced to avoid any changes to schema...

Matt Miller (#4) (7/12/2012)

---

Kingston Dhasian (7/12/2012)

---

Try the below steps:

1. Update the appropriate NOLIVRE and CODEEMPLACEMENT in Inventaire first to NULL

2. Update the appropriate CODEEMPLACEMENT column in LivreEmplacement table by using...

Try the below steps:

1. Update the appropriate NOLIVRE and CODEEMPLACEMENT in Inventaire first to NULL

2. Update the appropriate CODEEMPLACEMENT column in LivreEmplacement table by using your query

3. Update the appropriate...

Andy Hyslop (7/12/2012)

---

Hi

This error means that you have a foreign key referencing your table.

To perform this update you will have to remove the constraint Fk_Inventory_BookLocation from the table

I would be...