Viewing 15 posts - 661 through 675 (of 3,544 total)
SQLRNNR (6/30/2014)
David gave him most of the answer already but he didn't try to do anything with it other than say it doesn't work.
Actually Lynn's solution looked like my first...
Far away is close at hand in the images of elsewhere.
Anon.
June 30, 2014 at 9:02 am
At what level are you sequencing STORE2 and STORE, ItemID , ItemProgramPricingID or combination of columns?
How will UNI and UNI2 fit in this processing?
*Edited*
p.s. Please post your expected results for...
Far away is close at hand in the images of elsewhere.
Anon.
June 27, 2014 at 8:49 am
SQLRNNR (6/27/2014)
Is this good enough to save the OP from getting fired?
:ermm: Hope the job does not ride on this solution alone :pinch:
Just something I pieced together from what...
Far away is close at hand in the images of elsewhere.
Anon.
June 27, 2014 at 8:39 am
Third time lucky 🙂
WITH cte (itemID,ItemProgramPricingID,Price,Quantity,Points,ProgramCodeName,RowID)
AS (
SELECTipp.itemID,
ippv.ItemProgramPricingID,
ippv.Price,
ippv.Quantity,
ippv.Points,
p.Code,
ROW_NUMBER() OVER (
PARTITION BY ipp.itemID,ippv.ItemProgramPricingID,ippv.Price,ippv.Quantity,ippv.Points
ORDER BY CASE WHEN p.Code = 'STORE2' THEN 1 ELSE 2 END ASC)
FROMItemProgramPricing ipp
JOIN ItemProgramPricingValues as ippv on ippv.ItemProgramPricingID=ipp.id
JOIN Programs...
Far away is close at hand in the images of elsewhere.
Anon.
June 27, 2014 at 2:32 am
Deleted
Far away is close at hand in the images of elsewhere.
Anon.
June 26, 2014 at 9:57 am
Deleted
Far away is close at hand in the images of elsewhere.
Anon.
June 26, 2014 at 9:25 am
SELECT a.ID
,DATEADD(day,ISNULL(SUM(b.AddDays),0),GETDATE())
,DATEADD(day,a.AddDays+ISNULL(SUM(b.AddDays),0),GETDATE())
FROM #mytable a
LEFT JOIN #mytable b ON b.ID < a.ID
GROUP BY a.ID,a.AddDays
Far away is close at hand in the images of elsewhere.
Anon.
June 25, 2014 at 7:09 am
Far away is close at hand in the images of elsewhere.
Anon.
June 25, 2014 at 6:22 am
Why are you posting this again when the solution was posted in another topic?
You cannot pass a variable number of columns to reporting services.
You have to use a matrix...
Far away is close at hand in the images of elsewhere.
Anon.
June 24, 2014 at 9:17 am
;WITH cte (RowID, slot_col1, time_sched_start_dt, time_sched_end_dt)
AS (
SELECT ROW_NUMBER() OVER (ORDER BY a.time_sched_start_dt),
slot_col1, time_sched_start_dt, time_sched_end_dt
FROM #return_schedule a
),
cte2 (GroupID, time_sched_start_dt, time_sched_end_dt)
AS (
SELECT RowID-ROW_NUMBER() OVER (ORDER BY time_sched_start_dt),
time_sched_start_dt, time_sched_end_dt
FROM cte
WHERE slot_col1...
Far away is close at hand in the images of elsewhere.
Anon.
June 24, 2014 at 9:11 am
Removed as wrong solution
Far away is close at hand in the images of elsewhere.
Anon.
June 24, 2014 at 8:27 am
waseemshaikh345 (6/19/2014)
Hey David, for the YTD, which totals the months funded contracts is there a different type of expression for it? or do I need to filter it?
You will have...
Far away is close at hand in the images of elsewhere.
Anon.
June 20, 2014 at 1:45 am
Set the expression for the Hidden property for the January column to
=Switch(1<Month(Parameters!StartDate.Value),True,1>=Month(Parameters!EndDate.Value),True,1>=Month(Today),True,True,False)
February to
=Switch(2<Month(Parameters!StartDate.Value),True,2>=Month(Parameters!EndDate.Value),True,2>=Month(Today),True,True,False)
etc
Note that based on your requirements no data will be shown when the report is run in January
Far away is close at hand in the images of elsewhere.
Anon.
June 19, 2014 at 2:14 am
Why would having it as a table or matrix make any difference to the output?
If you want to persist with a table then hide columns that do not correspond to...
Far away is close at hand in the images of elsewhere.
Anon.
June 18, 2014 at 10:50 am
Removed as per previous post :doze:
Far away is close at hand in the images of elsewhere.
Anon.
June 18, 2014 at 10:47 am
Viewing 15 posts - 661 through 675 (of 3,544 total)