Minaz Amin (6/3/2008)

---

Hi All,

Recently my company got a contract to support one of its clients production unit. They had asked me to list out the

the points and send him...

Please do not make duplicate posts. It just annoys us and wastes everyones time.

If you execute this command:

select * from sys.transmission_queue

You will probably see that the transmission_status column has the following text: "The session keys for this conversation could not be created or...

This works just fine:

INSERT into TestTable( xmlData )

Values ( N'<root>text</root>')

Try this:

EXEC xp_CmdShell N'Dir C:\Tharindu'

It's simple enough to correct mine, given this clarification:

Select Room

From Rooms R

WHERE Not Exists (Select * from ReservationRooms RR

Where R.Room = RR.ResRoom

And CHECKINDATE < @DATEOUT

And CHECKOUT...

I think that that is the SQL native-Client library.

Post the different query plans (attach as xml-based *.sqlplan files).

If they have the same columns, try to combine them with Unions.

mark-o (6/2/2008)

---

Thanks again all...rbarryyoung, you solution works great...if Iwanted to choose an "OR" type of statement in the selection criteria so that a WOMAN could choose ("tall" OR "medium height,"...

[font="Comic Sans MS"]Hope springs eternal![/font]

Actually, I believe that DECLARE and SET are both part of the procedural language.

You could think of them as DDL & DML though, if that is helpful.

Try this:

Select Fruit, Inventory, '?' --you never defined "average of what?"

From FruitInventory

Group by Fruit, Inventory

Having count(*) > 1

Matt Miller (6/2/2008)

---

Save yourself some...

mark-o (6/2/2008)

---

i.e. my list of characteristics on the "GUYs" side includes items that the WOMAN doesn't care about (Judy want a man who is tall darak and handsome, but doesn't...