For Any Use & On Any Platform
Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.
Course Of The Month
10 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SQL Query of this Tables
Posted on 2011-03-09
Attached one Excel file, which i stored one table records
I want to output of record which i defined in excel file.
Please check excel file and give me proper solutions.
Thank you.
Tablerecords.xls
I want to output of record which i defined in excel file.
Please check excel file and give me proper solutions.
Thank you.
Tablerecords.xls
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
5
2
8 Comments
The information looks incomplete. I assume you want to fetch all records grouped on a particular customer?
Is that correct? If not, then let me know your filter creiterions and i will provide you the Sql query..
Is that correct? If not, then let me know your filter creiterions and i will provide you the Sql query..
Yes all records come form different tables like products,orders and customers.
So i am using with join query all three tables and make this output
but in product name, weight and price column are different and remaining are same records
so i want to put in one rows so i get output.
Please provide me query on this problem.
Thank you.
So i am using with join query all three tables and make this output
but in product name, weight and price column are different and remaining are same records
so i want to put in one rows so i get output.
Please provide me query on this problem.
Thank you.
Active today
Try this.
SELECT DISTINCT Order#,
OrderDate,
PaymentType,
Price,
RTRIM(SUBSTRING(ISNULL((SELECT ',' + ProductName
FROM your_table t2
WHERE t1.Order# = t2.Order#
for xml path('')),' '),2,2000)) ProductName,
SUM([Weight])
OVER(PARTITION BY Order# ) [Weight],
ShipType,
ShipVia,
Company,
FirstName,
LastName,
[Address],
City,
[State],
Zip,
Country,
Phone,
Email,
Comments
FROM your_table t1
Thank you for giving good query solution
But this query do not DISTINCT of the record. see the attach excel file which giving me output of result
It displays 2 record same.
Please give me solution.
Output.xls
But this query do not DISTINCT of the record. see the attach excel file which giving me output of result
It displays 2 record same.
Please give me solution.
Output.xls
Please give me solution of about query
But this query do not DISTINCT of the record. see the attach excel file which giving me output of result
It displays 2 record same.
Please give me solution.
Output.xls
But this query do not DISTINCT of the record. see the attach excel file which giving me output of result
It displays 2 record same.
Please give me solution.
Output.xls
Active today
try this.
SELECT DISTINCT Order#,
OrderDate,
PaymentType,
SUM(Price)
OVER(PARTITION BY Order# ) Price,
RTRIM(SUBSTRING(ISNULL((SELECT ',' + ProductName
FROM your_table t2
WHERE t1.Order# = t2.Order#
for xml path('')),' '),2,2000)) ProductName,
SUM([Weight])
OVER(PARTITION BY Order# ) [Weight],
ShipType,
ShipVia,
Company,
FirstName,
LastName,
[Address],
City,
[State],
Zip,
Country,
Phone,
Email,
Comments
FROM your_table t1
Featured Post
What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface.
Change Cu…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month10 days, 11 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
631 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.