|
masond
Posting Yak Master
241 Posts |
 Posted - 03/12/2013 : 06:29:46
|
Hey Guys
I am really stuck with this issue that i am facing, and i am hoping you will be able to help me
My initial table consists of the following
SELECT [FDMSAccountNo]
,[Comments2]
,[Submission_Route]
,[Period]
FROM [FDMS].[dbo].[Comments2_All]
I then changed the table to
SELECT [Comments2_All].[FDMSAccountNo],
len(Comments2) as comments,
[Submission_Route]
,[Period],
account_status
FROM [FDMS].[dbo].[Comments2_All]
INNER JOIN
Dim_Outlet ON Comments2_All.FDMSAccountNo = Dim_Outlet.FDMSAccountNo
The length of (Comments2) varies in size from ( 23,27,30,31,32,33,41,42,43)
If the account status is anything other than ‘16’ then i want to get the last submission route populated and populate all future periods with the last known submission route.
Hope this make sense
|
|
Populating fields, with old data
