For the data source? I will get that across ASAP...thanks all, I really do appreciate your suggestions...

Well, basically we have a SaaS application, for our end users (over 100 in number and growing fast), and from time to time, their admins tend to upload new files...

What they expect from the new DW, is to have these new fields created imported and available for reporting.

Just in case anyone has a similar problem to this, I'm sharing the solution that was provided by ScottPlecther with the help of a CTE. Once again many thanks to...

Hi Phill

Sure, its calculated with the following syntax:

SUM (ISNULL (L.T_AMT, 0) * CASE WHEN L.TDM= '0' THEN -1 ELSE 1 END) AS QTR_OPN_BAL

And its basically the sum of all...

Hi Phill

Thanks for getting back, DDL is:

USE [test]

GO

DROP TABLE [dbo].[named_query_table]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[named_query_table](

[A_LDGR_ID] [nvarchar](255) NULL,

[L_ORDER_DATE] [datetime] NULL,

[L_TDM] [float] NULL,

[L_T_AMT] [float] NULL

) ON [PRIMARY]

GO

while the syntax i'm using...

Thats very strange, I have an Enterprise Edition on a 64 bit Windows 2012 Server Standard Edition, and I get the following error:

Failed to deploy project. For more information, query...

Hello Phill

I have attached the sample data I am using, but saved the into an excel file (orders and employees), for a better understanding.

The excel attachment is the sample output...

@ramesh-2 Swaminathan: couldnt place the query within a function because of the update keyword...any ideas?

Thanks Ken

It was the spacing as you said that made all records updating to "Unknown". Do you also know how i can create an update function?

I used the following:

CREATE FUNCTION...

Hi

I added them to the CASE statement, but it updated every record with "Uknown".

Is there something im missing here?

Hello

There are three characters which is sent from end users in a flat file which is imported, within the file there are two sets of characters which need to be...

Hiya

I checked it as you advised, and found that they had different collations, is there a way around this with changing it from the engine but within my query?

[FitID]...

Even when i use <>, and an inner join it still returns the same thing.....which is strange.

on where to place the task within the data flow