Viewing 15 posts - 121 through 135 (of 1,216 total)
Just a warning... The proposed solutions are probably OK in this case, where DateCreated of a row will never change (at least one can assume it). It wouldn't work if...
November 18, 2008 at 7:10 am
Hi,
please read the info about posting data (link in previous reply) and post structure of table Reservations along with some test data and required result from the supplied test data....
November 18, 2008 at 6:51 am
IMHO the problem is not whether it 2 or 3 is correct, but what is the answer 3?
If you read the "Sorry you were wrong" message, you!ll see that it...
November 13, 2008 at 5:37 am
Why does anyone impose such requirements as what must be coded in the primary key? In my opinion, this is not a good idea. I would go with IDENTITY column...
November 7, 2008 at 8:36 am
Actually, my first attempt could have been simpler - no grouping in the outer query is necessary, since the derived table c already handles that.
I've removed it, and added column...
November 3, 2008 at 5:04 am
Hello,
I've been looking at your sample data and it seems there is a slight mistake - Things table contains 3 rows, but 5 things appear in Captures table. Also, it...
November 3, 2008 at 1:54 am
Matt Miller (10/7/2008)
select TOP (@rows) WITH TIES *
From myTable
ORDER BY CustomerID
This will pull the first 2000 VALUES for customerID, and return any rows that match those.
This is a little...
October 8, 2008 at 9:53 am
OK, now we know a bit more about how you want to use it, and I hope you'll get some assistance soon. I know almost nothing about replication, so I...
October 8, 2008 at 7:58 am
Yes, it is possible. You could do it for example using dynamic SQL.
select * from sys.views
select * from sys.tables
will help you to find all missing tables. Once you have identified...
October 8, 2008 at 6:25 am
IF @iMenuId=NULL
That's probably yout problem, along with other uses of = or <> or other standard comparision operators with NULL value. This only works with ANSI NULLS OFF, and...
October 7, 2008 at 5:07 am
Alvin,
that's not gonna work... the two MIN() are independent.
If you have the same salary of 1000 in 12/2007 and 01/2008 (before and after that it was different), what will...
October 6, 2008 at 8:42 am
When I first looked at Jacob's solution, I thought "what a nice solution". Unfortunately, it is simple, understandable and easily maintainable, but it works only in an ideal life where...
October 6, 2008 at 7:19 am
Matt is right, using left join to derived table is better than correlated subquery. Unfotunately he has a typo in his post (ID and group by missing in the inner...
October 6, 2008 at 3:03 am
And now on a serious note... this is a bit scary for me:
all columns from brand---subcategory need to be renamed and included/repeated for all items in a single purchase by...
October 6, 2008 at 1:27 am
Please, teacher, I know, I know :w00t:
(sorry, I'm in a good mood today, so I couldn't miss the opportunity for a stupid joke 😛 )
October 6, 2008 at 1:13 am
Viewing 15 posts - 121 through 135 (of 1,216 total)