Viewing 15 posts - 13,951 through 13,965 (of 15,381 total)
L' Eomot Inversé (9/23/2011)
Sean Lange (9/22/2011)
TheOxblood (9/22/2011)
Yes it is for hotel reservation! 🙂
How can I allow per each room their status?
For example, RoomNo 10...
September 23, 2011 at 12:47 pm
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',...
September 23, 2011 at 12:44 pm
And more importantly do you have a primary key on this table? This is more challenging if you don't.
September 23, 2011 at 12:31 pm
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...
September 23, 2011 at 9:38 am
At least one of those fields has data that is not the same across all the records for that group.
September 23, 2011 at 9:15 am
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...
September 23, 2011 at 8:54 am
Glad you figured out the issue and thanks for letting us know.
September 23, 2011 at 8:21 am
Is the service running?
September 23, 2011 at 7:46 am
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...
September 23, 2011 at 7:44 am
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...
September 23, 2011 at 7:36 am
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.
September 23, 2011 at 7:02 am
HemSingh (9/22/2011)
WHERE '+@FieldName + ' = ' + CAST(@SearchText AS datetime);
-- I have...
September 22, 2011 at 2:58 pm
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...
September 22, 2011 at 1:47 pm
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...
September 22, 2011 at 1:39 pm
Any chance you can post the ddl for SrcCodeMap along with a few rows of sample data?
September 22, 2011 at 9:51 am
Viewing 15 posts - 13,951 through 13,965 (of 15,381 total)