Degradable (10/23/2015)

---

Alan

The select on the table using my formula above is simple enough and returns the following.

PPRC_NumberPPRC_CurrencyPPRC_WholesaleWholesalePPRC_WOverride

1340055GBP76.8776.99000

1360025GBP137.98137.99000

What I am looking to do, is take the cost PPRC_Wholesale and do the...

drew.allen (10/23/2015)

---

You're trying to call a UDF DATEPART defined under the tblCall schema. Unless you've defined your own DATEPART function under this schema, I suspect what you want is...

Read this article: http://www.sqlservercentral.com/articles/T-SQL/68467/

It explains the problem that you're facing and gives different alternatives. It's missing the 2012+ solutions, but based on the forum that you posted, you shouldn't care...

This:

tblCall.DATEPART(yyyy,Call_Date)

Should be this:

DATEPART(yyyy,tblCall.Call_Date)

You qualify the column, not the function.

rourrourlogan (10/22/2015)

---

Thank you Everyone!

Luis! I was trying to add more codes to this section would the syntax look something like this?

SELECT *

FROM #SampleData

WHERE UniqID NOT IN (SELECT UniqID

...

ranjitdaljitmand (10/23/2015)

---

Hmm, I am slightly confused here because as per my understanding this wiil be a simple or rather a basic query to fetch those code...

Try this: https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-conditional-split/

Do you need more guidance?

Now I'm not sure if I read the question correctly 😀

So many ways to do this, that I can't decide the best option.:-D

Here are 2 ways.

CREATE TABLE #SampleData (

UniqID int,

Code varchar(10)

);

INSERT...

Use the sys.default_constraints system view.

SELECT d.name, OBJECT_NAME( d.parent_object_id) , COL_NAME(d.parent_object_id, d.parent_column_id)

FROM sys.default_constraints d

Lynn Pettis (10/22/2015)

---

mw112009 (10/22/2015)

---

FOUND THE MISTAKE.. ALL Set ....

Select object_name(SI.object_id) as tab_name,

( Select c.name from sys.columns c where object_id = SI.object_id AND c.column_id = SIC.column_id ) as [index_col_name]

from

sys.indexes...

You need to either include it in the GROUP BY or use it in an aggregate function. Otherwise, there's no logic to which value should be shown.

I wouldn't call it lazy if...

I'd probably go with a Conditional split transformation which will have subsequent derived column transformations and destinations for each table.

I can't remember on basic admin stuff, but this can help you for differences between SQL implementations of Oracle and SQL Server:

http://troels.arvin.dk/db/rdbms/

Of course, the same advise as the ones coming...