Isn't the...

Try the following code based on your original. All I did was move the reference to the new value table into a correlated subquery.

CREATE FUNCTION [dbo].[fn_Get_NewValuetbl]

...

Your function is doing a partial cross join. If you pass in the parameter "ABC" it will return "ABC" for every single value that you have in your new...

You've been around long enough to know that you should provide sample data and expected results.

It would also help if you provided the query where you are calling the function....

You should be doing this in SSRS (or whatever reporting software you are...

I wouldn't....

dougb 34607 (9/15/2011)

---

My problem is that I need to use the value in a report as part of a quantity calculation so I am stuck resolving the formula and my...

I think that you're approaching this backwards. Instead of starting from the filename and getting the file that matches it, you should start from the file and get the...

kramaswamy (9/15/2011)

---

You could probably identify which packages are doing the work by using some form of audit mechanism. Like, for example, if it's an UPDATE on a table, you could...

This would require that all records with the same CaseID and Date have exactly the same ProviderCode (PRV_ID) and TypeServiceCode...

You can use a CROSS APPLY.

SELECT ColMultiple, ColD/ColMultiple as ColAverage

FROM tblCustomer

CROSS APPLY (

SELECT ColA*ColB*ColC as ColMultiple

...

If you don't supply a time, it defaults to midnight (00:00:00.000). So the datetime that your comparing to is '2011-05-31 00:00:00.000' which is less than the datetime on the...

I still think that CROSS APPLY is going to be your better solution, but, again, without sample data there is no way to test the code. Based on Phil's...

Without sample data it's difficult to say what the best approach is, but there are two general approaches: Row_Number() or CROSS/OUTER APPLY. If you want tested code, you...

If you have a set number of emails, wouldn't it be easier to do this in a Derived Column Transformation?

I suspect that the Derived Column Transformation may also be more...