Viewing 15 posts - 151 through 165 (of 2,452 total)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 5, 2017 at 12:05 pm
Michael Esposito - Wednesday, July 5, 2017 11:52 AMI added it to my original post. Thanks for the tip!!
some sample data insert...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 5, 2017 at 11:54 am
???..."next numbers...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 4, 2017 at 11:13 am
"For the examples above the next numbers generated should be CNCB17000002,CNPO17000002,CNCP17000004"
???..."next numbers generated?"....from where/what/which process?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 4, 2017 at 11:08 am
please confirm what version of SQL you are using.....in some of your other posts IIRC you said you were using 2008??
This is a 2016 forum
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 4, 2017 at 7:40 am
just a thought......
CREATE TABLE #ProductPrice(
ProdId VARCHAR(6) NOT NULL
,BasePrice INTEGER NOT NULL
,Pricegroup VARCHAR(3) NOT NULL
);
INSERT...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 4, 2017 at 3:50 am
from your example data it appears that you are applying the same discount to all sizes. ________________________________________________________________
buy get 5% off, buy 3 get 10% off, buy 4 get 15% off.
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 3, 2017 at 11:05 am
what consideration have you given to when to wish alter a price?
are you intending to keep a history of price changes per item?
If you have a start/end datetime...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 3, 2017 at 9:42 am
I want to know how many orders (can more then 1 row) have the same...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 2, 2017 at 1:03 pm
not exactly sure of what you are asking.....but to start the discussion why cant you use COUNT & GROUP BY
eg
SELECT COUNT(*) , OptionID, Quantity
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 2, 2017 at 9:15 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 1, 2017 at 8:40 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 1, 2017 at 8:07 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 1, 2017 at 6:02 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 1, 2017 at 5:48 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 1, 2017 at 1:51 am
Viewing 15 posts - 151 through 165 (of 2,452 total)