L' Eomot Inversé (9/23/2011)

---

Sean Lange (9/22/2011)

---

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...

This will do what you are asking for:

create table #List

(

ListID int identity not null,

OrderBy char(1),

OrderDate datetime,

OrderCity varchar(20)

)

insert #List (OrderBy, OrderDate, OrderCity)

values

('A', '02/22/2011', 'NEW YORK'),

('A', '02/22/2011', 'LONDON'),

('A', '02/22/2011', 'NEW YORK'),

('B', '02/22/2011',...

And more importantly do you have a primary key on this table? This is more challenging if you don't.

It makes sense that it can't be in a group if you think about it. Which value should be in the group?

To have your query return only one row for...

At least one of those fields has data that is not the same across all the records for that group.

glad you could fix it. I still say you don't need a cursor for this, but that is your choice. Feel free to come back and post some ddl and...

Glad you figured out the issue and thanks for letting us know.

Is the service running?

Hi and welcome to SSC. I have a pretty good idea of where you are heading with this but it is really hard to know for sure. It would be...

There's no reason why you should call a procedure passing a string value where a number is expected.

If you do it correctly from the app side, there's no way that...

Any chance you can post your solution so others who have this issue can find a solution? Glad you were able to get your issue resolved.

HemSingh (9/22/2011)

---

my search string is coming in string format from dateTimePicker of winform and i am trying like this:

WHERE '+@FieldName + ' = ' + CAST(@SearchText AS datetime);

-- I have...

This is good example of two very common problems with the way people use sql. First of all, you are storing two types of data in a single column. You...

Given the inability to do this via RI it looks like what you posted originally should work fine. The painful limitation of course is that it can only handle it...

Any chance you can post the ddl for SrcCodeMap along with a few rows of sample data?