Ahh I missed that part somewhere along the way. You certainly don't need to use a cursor for this. You can use ROW_NUMBER(). I will toss together an example so...

I don't think you can use dynamic sql as the query for a cursor. Just take my example above and run your dynamic sql to fill a temp table and...

What is the point of the RoomAvailable table? Are you using that a holder for all available rooms? That seems like not a good idea to me. Seems like all...

prakash 67108 (9/22/2011)

---

Hi,

yes, i need dynamic query because i have to pass the table name and column name values through parameters as i shown in the query....i need cursor because...

TheOxblood (9/22/2011)

---

So, you are saying that the availability of the rooms will depend on the reservation time of the other?

SELECT * FROM Table WHERE ArrivalDate <> ... AND DepartureDate <>...

Unless you are trying to get the results for more than 1 row. You can't store multiple results in a single variable. If that is what you are trying to...

TheOxblood (9/22/2011)

---

Yes i am planning to merge it..

Yes it is for hotel reservation! 🙂

How can I allow per each room their status?

For example, RoomNo 10 is RESERVED at 7:00am-12:00pm

but 12:00pm...

I doubt you really need a cursor but the problem is the select statement for your cursor. Whatever you posted here is a total disaster. It looks like maybe you...

TheOxblood (9/22/2011)

---

oh! I forgot to remove the Status on the Reservation Table.. Sorry!

I need to retrieve all available rooms? do i need to create a new table?

how and what are...

I don't understand your question. Can you please clarify? Are you asking which sql server should you use to connect to your database?

Charlottecb (9/22/2011)

---

Sean Lange (9/21/2011)

---

That looks like a good start but you will have to add some of looping to handle multiple line inserts. If Lowell doesn't have time I can...

That looks like a good start but you will have to add some of looping to handle multiple line inserts. If Lowell doesn't have time I can give you a...

Glad you were able to find at least a temporary solution. I think you could take what you learned about how to use the Delimited split function and just add...

Whenever there is a delete statement there is a transaction started by the system. This trigger is just rolling it back. Yes it is probably redundant but best practice is...

LOL well I guess that would work too assuming they only send one type of file. I guess I am more used to users who send attachments of who knows...