7 Topics

Member Avatar for
Member Avatar for radiancebox

I'm using MS SQL 2012 - trying to LEFT JOIN 3 Pivots - but am running into issues within a query variable that I'm not sure how to debug. Each Pivot works on it's own - but the actual Joining is causing the issue. Any help is appreciated. First time …

Member Avatar for kgariando
0
3K
Member Avatar for ses03

i have four tables (1) tbl_module: modNo | modName _ _ _ _ _ _ _ _ 1 | module 1 2 | module 2 (2) tbl_subject subNo | subName | modNo _ _ _ _ _ _ _ _ _ _ _ _ 1 | a1 | 1 2 …

Member Avatar for Reverend Jim
0
247
Member Avatar for cyberdaemon

Good day, I am having a probem with my sql. I want to create a formula for my pivot field.. here is my code... SELECT * FROM ( SELECT REPORT.MATERIAL ,REPORT.Description ,REPORT.Material_Type ,REPORT.ATP_check ,REPORT.Delivering_Plant ,REPORT.Order_Quantity ,REPORT.Held_by_Finance ,REPORT.Rejected_OOS ,REPORT.Rejected_Others ,REPORT.Open_Order_Quantity ,REPORT.Order_Quantity_NKA ,REPORT.Order_Quantity_RKA ,REPORT.Order_Quantity_Others ,REPORT.Stock ,REPORT.DSD_Delivery ,REPORT.OUtBound_Haulage ,REPORT.Total_OutBound_items ,REPORT.InBound_Haulage ,REPORT.Haulage_In_Transit ,REPORT.Process_Order ,REPORT.Total_Inbound_Items …

Member Avatar for cyberdaemon
0
207
Member Avatar for clausont

I have a Gridview that I need to add a button for each row and need to do this programmatically. I am able to add the button, but I am missing something as it is creating a new column and adding the button only in the new column. When the …

Member Avatar for clausont
0
814
Member Avatar for straylight

Basically I am attempting a HW assignment for questions that a frequently asked in interviews. I am not sure if I am having problems with the coding or actually understanding what they question is asking for. Basically I am asked to find an element in a sorted array and that …

Member Avatar for Bob
0
202
Member Avatar for straylight

Hello, I am very new to C and having the hardest time with arrays. I am attempting to find a pivot point in a sorted array for example { 1 2 4 5 9 } might become { 5 9 1 2 4 }. I am thinking it should be …

Member Avatar for deceptikon
0
586
Member Avatar for PinoyDev

Good day. I have this running query that I want to pivot the sum of CurrentBalance where in Monthdate =[2011-11-30],[2012-12-31]...etc. But everytime I try to put the Pivot, it cannot detect the CurrentBalance column alias. Here is my query so far. use MFR_Merchandise go declare @MonthColumns as nvarchar(max) declare @SQLtext …

Member Avatar for BitBlt
0
192

The End.