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.

Beceriler: Microsoft SQL Server, SQL

Daha fazlasını gör: 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

İşveren Hakkında:
( 13 değerlendirme ) Newberry, United States

Proje NO: #18884472



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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 110%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(33 Değerlendirme)

Bu iş için 11 freelancer ortalamada $161 teklif veriyor


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, Daha Fazla

$98 USD in 0 gün içinde
(210 Değerlendirme)

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 Daha Fazla

$222 USD in 3 gün içinde
(1 Yorum)

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

$222 USD in 10 gün içinde
(1 Yorum)

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 Daha Fazla

$150 USD in 3 gün içinde
(0 Değerlendirme)

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 Daha Fazla

$210 USD in 3 gün içinde
(0 Değerlendirme)

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 Daha Fazla

$140 USD in 12 gün içinde
(0 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

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 Daha Fazla

$277 USD in 2 gün içinde
(0 Değerlendirme)

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 Daha Fazla

$45 USD in 3 gün içinde
(0 Değerlendirme)

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

$155 USD in 3 gün içinde
(0 Değerlendirme)