What about this...

SELECT edl.date_list, r.room_id

FROM ttc_room_tracker rt

RIGHT OUTER JOIN ttc_event_date_list edl

ON rt.event_date = edl.date_list

RIGHT OUTER JOIN ttc_room r

ON rt.room_id = r.room_id

WHERE rt.location_id = 2 AND r.location_id = 2...

Hi

You could do this in a number of ways but the query plans would be inefficient most of the times.

Dynamic sql may be a better solution to this. Check...

Great explanation Adi.

First why do you want to do this.

You would need to use dynamic queries to do this. You can pass the columns and their values as a string in a...

I liked it.

Stored procedures are also easier to debug than a trigger and can handle multiple table modifications better with the help of transactions.

As long as your trigger does not get too...

Suspended status means that the command is waiting for some other action to be performed so that it can continue.

Checkpoint writes modified pages from the memory on to the...

I assume that the column TimeIN is a datetime column.

Either there are no records for the date or more likely there is a time part along with the date part...

What an anti-climax.

Check this ...

select Replace(convert(char(20),GETDATE(),107),',','st,').

You will have to do some manipulation towards setting "st" part. Ex:- if the data is 5 then it should be "th" (5th) and so on.

Keep in...

I doubt whether reversing the tables could help a lot here.. anyway its worth a try. Mostly SQL will come up with a good execution plan irrespective of the order...

You need to create 2 logins and grant access to the db for only those 2 logins as mentioned in previous post.

Also make sure that the database role membership is...

Why do you want to change to case sensitive?

If your clustered indexes are on identity columns then you have some control over the order of the data. If the indexes are on other columns then it would be...

Mobile phones ringing incessantly and people bumping into my chair while walking around other wise its "LIVE AND LET LIVE".