One other way to write Lutz's solution:

DECLARE @tbl TABLE (Room_ID INT, Check_in_Date DATETIME, Check_Out_Date DATETIME)

INSERT INTO @tbl

SELECT 1 ,'20100530','20100604' UNION ALL

SELECT 1 ,'20100610','20100612' UNION ALL

SELECT 1 ,'20100613','20100617' UNION ALL

SELECT 2...

Using EXISTS with pass-through conditions may be more efficient:

USE tempdb;

GO

CREATE TABLE A (CusNo_A INTEGER NOT NULL PRIMARY KEY);

CREATE TABLE B (CustNo_B INTEGER NOT NULL UNIQUE, Second_CustNo INTEGER UNIQUE);

CREATE TABLE C...

gaurav-404321 (4/30/2010)

---

I am using Hindi fonts in windows application.

I have setted down the font of text box as hindi font. I am saving the text in sql server database

What is...

You can never have too many solutions. This one is very short:

UPDATE INLINE SET OldMsg = Msg

FROM (SELECT OldMsg = Msg, Msg = CASE...

DECLARE @data

TABLE (

id INTEGER PRIMARY KEY,

item ...

That is...

Jeffrey Williams-493691 (5/1/2010)

---

Is that new in 2008 - or can you do it in 2005 also? I knew about drop existing, but did not think you could do it...

In Enterprise Edition (and equivalents) an index can...

Garadin (4/30/2010)

---

I'll admit that I scanned this, but I didn't see anyone mention a UDF as the default constraint on the column that does a lookup for the value in...

Great stuff! Thanks so much for taking...

Ah. Yes, that is a bit of an issue isn't it? :rolleyes: 😀

Bradley Deem (4/30/2010)

---

Great question. I did not find it ambiguous, in fact this line removed the ambiguity.

Restore all transaction log backups taken since the latest differential backup restored with...

See Tail-Log Backups for all the details.

Peter Brinkhaus (4/30/2010)

---

Some other thing, why are you explicitly testing if the inserted row set is empty. If it is, the insert statement is a no-op (even the two insert...

anilkullam (4/30/2010)

---

As for as my knowledge is concerned, a differential backup shud have a base to start with, which is necessarily the recent full backup available (here for wednesdays diff...