HowardW (9/21/2011)

---

You might want to recheck your facts. BOL says differently:

http://msdn.microsoft.com/en-us/library/ms187928.aspx

---

Input when you convert to datetime;...

Actually a SELECT statement should be allowed as long as it only...

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...