Thanks for the link Sean. That explains it really well.

I was surprised when I saw the plan initially but now I am clear.

Is there no way you can change it or make somebody else change it?

techmarimuthu (6/25/2013)

---

i wanna store one date so that why i...

techmarimuthu (6/25/2013)

---

create table members

(

id int identity,

firstname varchar(30),

lastname varchar(40),

dob int

)

insert into members(firstname,lastname,dob) values ('Michel','David',19890630)

insert into members(firstname,lastname,dob) values ('Raja','Kumar',19900625)

insert into members(firstname,lastname,dob) values ('Rahul','Sundar',19910501)

insert into members(firstname,lastname,dob) values ('Arun','Edward',19901219)

i wanna...

We would definitely need more information to help you

Please explain the issue a bit more and also provide the DDL of the tables involved, some sample data and the expected...

This doesn't look difficult and it would be good if you try this yourself

If you are stuck somewhere, we would like to see what you have tried and where exactly...

I am not really sure about the output you are expecting

It would help if you can provide DDL of the table involved with some sample data and the expected results...

This is exactly the opposite of what the OP wants

You have been here for some time now.

I expect you to help us with some DDL of the tables involved, some sample data and the expected results based on the...

Will this work?

WHERE table.AdminDate <= @startdate AND ( table.DischargeDate >= @enddate OR table.DischargeDate IS NULL )

Hugo Kornelis (6/21/2013)

---

Though adding an integer to a datetime works (and is even documented HERE and HERE), I would strongly recommend against using it.

First, let's look at the internals. Operators...

Glad we could help you out 🙂

meltingchain (6/20/2013)

---

Sorry, here is the data.

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

...

Duplicate post. Please direct all the replies here

http://www.sqlservercentral.com/Forums/Topic1465520-391-1.aspx

Do you want to exclude the IP addresses only when a machine has more than 1 assigned?

What if there is a machine which has only one IP address assigned and...

knakka99 (6/20/2013)

---

Thank you Dhasian you have showed me a new approach to fix this issue (I thought that Pivot is the only way)

I appreciate your help 🙂

Also I have an...