Viewing 15 posts - 796 through 810 (of 2,452 total)
fareedhmohamed (4/16/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 17, 2016 at 11:49 am
djmenon21 (4/17/2016)
Can someone please help me build this ?
I have just pretty basic knowledge of SQL...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 17, 2016 at 11:45 am
djmenon21 (4/17/2016)
These tables from our data warehouse provide enough information to answer (you may not need all...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 17, 2016 at 11:34 am
Hi...can you please post some table/data scripts as per post below.
Also your expected results based on the sample data you provide.
Thanks
Helps us help you
https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 17, 2016 at 9:20 am
great start...now some sample data please and your expected results based on that sample data.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 17, 2016 at 6:49 am
fareedhmohamed (4/17/2016)
Hi,Do u want me to add further code for my database?
Thanks
by all means do...it will probably help us help you
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 17, 2016 at 6:40 am
oh ...and by the way, I am afraid that screen shots arent the best way of providing data....they can visually explain what you are attempting, but it far better...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 17, 2016 at 6:22 am
personally I wouldnt put a trigger on the order/orderdetails tables...I would probably get the front end application to do the necessary calculations PRIOR to writing to the back end tables...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 17, 2016 at 6:14 am
fareedhmohamed (4/17/2016)
Hi,Yeah, that is correct.
Thanks,
which one is correct?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 17, 2016 at 5:57 am
fareedhmohamed (4/16/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 17, 2016 at 5:21 am
T.Ashish (4/15/2016)
There are no index or execution plan issues with this query.
How have you decided your statement above is correct?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 15, 2016 at 11:05 am
can you post the actual execution plan please.
quick scan thro your code....
case when
1 = 1
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 15, 2016 at 10:24 am
how to present a question with easy to use script for all .
https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
voila:
CREATE TABLE Bball_Stats(
PlayerId INTEGER NOT NULL PRIMARY KEY...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 14, 2016 at 3:22 pm
smiF (4/14/2016)
a.Find the Most Points scored per game by Position
b.Find the Number of Rebounds per game by Coach
NOW, I know...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 14, 2016 at 3:19 pm
(And, if you want to submit to the next SQL Saturday in Exeter, I'm sure we would accept!)
if it was in Exeter, then I would go as well, never...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 14, 2016 at 6:47 am
Viewing 15 posts - 796 through 810 (of 2,452 total)