Viewing 15 posts - 2,011 through 2,025 (of 2,452 total)
pls confirm are the the FE tables now linking to SQL or the "old" BE (.after you made the table deletions) ?
out of interest...what are your "many issues"
concurrency?
performance?
data integrity?
iirc...a properly...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 6, 2012 at 2:39 pm
I think there's a small issue with the math. Using factorial would work for permutations (i.e. the orders of the colors matter), but is not right for combinations. ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 6, 2012 at 1:02 pm
mmiller 85218 (2/6/2012)
Sean Lange (2/6/2012)
J Livingston SQL (2/6/2012)
4 type of Colour
3 type of Size
5 type of Flavour
2*4*3*5 = 120 combinations
though how they are related beats...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 6, 2012 at 11:17 am
2 type of House
4 type of Colour
3 type of Size
5 type of Flavour
2*4*3*5 = 120 combinations
though how they are related beats me 😀
edit typo
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 6, 2012 at 10:41 am
KFC
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 6, 2012 at 9:03 am
Jeff Moden (2/5/2012)
J Livingston SQL (2/5/2012)
....really should have seen that, rather than just coding my "thought" process on how to break it out into what I required....:-)
Nah. I do...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 5, 2012 at 12:08 pm
Hi.. please provide table create / insert data scripts
we have been here before 🙂
http://www.sqlservercentral.com/Forums/FindPost1246891.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 5, 2012 at 10:29 am
quynh012012 (2/5/2012)
Hi,I do not agreed with you. Any way, your points of view make me thinking about some thing for my project.
Pls try to keep posting. Tks and best regards
So...you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 5, 2012 at 8:32 am
Jeff Moden (2/4/2012)
I'd say "spot on" except that you can simplify it all quite a bit.
SELECT prod_id, SUM(quantity)
FROM dbo.TestTable
GROUP BY prod_id
HAVING COUNT(DISTINCT sale_date)...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 5, 2012 at 6:28 am
preetpalkapoor (2/4/2012)
Prod id quantity
p2 11
p3 16
This...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 5, 2012 at 6:23 am
Assuming that by Ranking Functions you mean RANK,DENSE_RANK,NTILE & ROW_NUMBER are to be excluded
http://msdn.microsoft.com/en-us/library/ms189798.aspx
here is one possible way that manages duplicates
SELECT Salary,rn = IDENTITY(INT, 1, 1)
INTO #tmp
FROM SalaryTable
GROUP BY...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 5, 2012 at 5:57 am
Murphy'sLaw (2/4/2012)
-- Dispaly 5th highest and 2nd lowest salary in the same table (without rank functions)
Why "without rank functions"...??? (homework maybe 😉 )
_______________________________________________________________________
Not sure what you are expecting if...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 5, 2012 at 4:14 am
...anywhere close???
prod_id SumQty
------- -----------
p2 11
p3 16
if you provide the create table / insert data scripts as I have below...and your...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 4, 2012 at 5:46 am
Jake Shelton (2/3/2012)
There's got to be a way to copy the whole DB at a time, there are hundreds of separate tables in it.
if this a one time operation to...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 3, 2012 at 3:03 pm
you're welcome 🙂
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 3, 2012 at 2:36 pm
Viewing 15 posts - 2,011 through 2,025 (of 2,452 total)