Đã hoàn thành

Advanced CrossTab/Pivot Query SQL Server

I have an extensive product database in SQL Server. I need to take 3 tables and combine them so that I have at the end a table with columns named after items of one table, with productid as rows with the field data concatenated data from 2 other tables. No mathematical functions are performed at all. Data is just collated.

1) Table 1 pdt_WebWidgets has 132 items I call "Widgets." Column names for the pivot crosstab will come from field labeltext. New widgets are occasionally added, so pivot must be able to include these new widgets as they are created.

2) Table 2 pdt_WebWidgetValue has over 7 million records, with fields ProductID, WidgetID, Value. pdt_WebWidgetValue.WidgetID=pdt_WebWidgetID

3) For [login to view URL] IN (2,6), we can join pdt_WebWidgetListBox (57,000 records) to pdt_WebwidgetValue ON

pdt_WebWidgetListBox.ID=[login to view URL]

AND (important)

pdt_Webwidgetlistbox.WidgetID=[login to view URL]

Again, this is only for items in Type=(2,6). For this WidgetType, we will concatenate the values in [login to view URL] as a comma-delimited list in the pivot fields. All other Types, we will just take the actual pdt_WebWidgetValue.Value. These should be single values, typically.

I already have a query that does this, but it can be very slow. I use a number of static temp tables to help build the data to get it ready and make it easier/faster for the crosstab to be built. I wanted to see if someone could design something that would run much faster, creating a static pivot table after collating the data, so I could reduce a number of steps in a SQL Server Agent Job.

Kĩ năng: Microsoft SQL Server, SQL

Xem nhiều hơn: sql server crosstab dynamic columns, sql server pivot, crosstab query example, sql crosstab without aggregate, sql pivot dynamic column names, sql server crosstab multiple columns, crosstab in sql server 2012, crosstab query sql oracle, excel pivot table sql server, parent child query sql server, uusing data adaptor aspnet query sql server database, sql server job bcp, arcgis vba query sql server, sql server job import xls, sql server job bid, excel web query sql server, access vab query sql server, asp net sql server job scheduling hosting, finding parent tree query sql server, pivot table sql server data source vb script

Về Bên Thuê:
( 13 nhận xét ) Newberry, United States

ID dự án: #18884472

Được trao cho:

Neno585

Hello, I can for sure build your pivot query in most efficient way. Table of 7 million rows shouldn't represent such a big issue if properly indexed but as you want items to be the columns and columns must be defined i Thêm

$110 USD trong 2 ngày
(33 Đánh Giá)
7.4

11 freelancer đang chào giá trung bình $161 cho công việc này

sumon355

Hello, As an expert in SQL, i am very much interested to do this project. I am not fully clear about the requirements, but as you did it already, i think i can just optimize it to run faster. If you want me to do it, Thêm

$98 USD trong 0 ngày
(210 Nhận xét)
7.4
dreammate0621

Hello! I am a programmer! I am interested in you project. If you hire me, I am gonna do my best for your project. I hope you have a dialog with me so that I can understand your requirements completely. I guarantee Thêm

$222 USD trong 3 ngày
(1 Nhận xét)
2.8
WebDevPro007

Hello Sir I can help you handle that, I have good experience on SQL. Contact me asap Sincerely Maurice

$222 USD trong 10 ngày
(1 Nhận xét)
2.4
WebExpert555

Hi, I have read your description carefully and very interested. Through over 8 years, I have rich experiences in database management with Microsoft SQL Server, SQL. So the project is very suitable and very easy f Thêm

$150 USD trong 3 ngày
(0 Nhận xét)
0.0
CitachiTech

Hi, How are you? I'm Hardik Kotecha. I've over 12 years of experience in Data Analytics, Visualization and Administration. I was in Chicago for 8 years working for Sears at their corporate headquarter as a Data Thêm

$210 USD trong 3 ngày
(0 Nhận xét)
0.0
HoneyApplePie

Hi euroluxhome Greetings !! Hope you finds in good health !! I saw your job post on www.freelancer.com and happy to assist you on same. I will redesign and maintain your details into a professional manner. Is it p Thêm

$140 USD trong 12 ngày
(0 Nhận xét)
0.0
lightingdavid

Hello. How are you? I am highly interested to work on the "Advanced CrossTab/Pivot Query SQL Server". I am a full stack website developer. I have more than 7 years experience in "Microsoft SQL Server, SQL". I will Thêm

$140 USD trong 1 ngày
(0 Nhận xét)
1.4
pawand7

hi I have good amount of knowledge about the SQL server. I can help you regarding your task. I have gone through your requirement. either you can share to me your query or I will write my self. kindly give chance to Thêm

$277 USD trong 2 ngày
(0 Nhận xét)
0.0
i4ConsultantDev

Hi, I am writing this after reviewed your project description. I am interested in your project and Kindly drop a message so we can discuss. • Overall 6+ years of experience in Software Development Projects. • Ov Thêm

$45 USD trong 3 ngày
(0 Nhận xét)
0.0
gkhuntia5

5 yr experience in sql Relevant Skills and Experience Sql, storedprocedure, function, trigger views

$155 USD trong 3 ngày
(0 Nhận xét)
0.0