Viewing 15 posts - 61 through 75 (of 183 total)
Hello
I have attached sample data in a csv formats and the three table structures as a text file, i hope this works.
this is the query i used:
SELECT Returns.ReturnDate,...
September 3, 2008 at 7:08 am
Hello
I want to use query 2 and 3 join together to return an accurate result set
August 29, 2008 at 1:47 pm
What will i have to write to extract records that are not blank?
August 21, 2008 at 10:53 am
1-placed an order over a certain amount -(all orders)
2-requested for an order over a certain amount to be delivered to a different address,-( all orders for new customers over 90...
August 19, 2008 at 9:52 am
Not able to attached execution query plans, file type not permitted
August 19, 2008 at 5:09 am
the execution plan is graphical, how will i be able to send that to you?
August 19, 2008 at 5:04 am
When you say table structure, do you mean the create table query?
August 19, 2008 at 4:46 am
And if i would like to find out orders placed by the a customer within a 7 day period will i use:
DATEDIFF(dd,T_OrderHeader.OrderDate,GETDATE()) BETWEEN 1 AND 7)
August 19, 2008 at 4:12 am
I got the right result, my mind was going towards an inequlity or something syntax to be needed - Thanks
August 14, 2008 at 8:03 am
I want know the last time a customer placed an order in addtion to the information required
August 14, 2008 at 7:41 am
Yeah, got one question for you though, what are the best and easily comprehensible books out there to understand T-SQL development?
August 12, 2008 at 8:49 am
Fixed, incorrect placement of syntax, eventually used:
WHEN 'REFUND' THEN - CAST (Amount AS MONEY)
August 12, 2008 at 7:28 am
Viewing 15 posts - 61 through 75 (of 183 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy