Viewing 15 posts - 3,976 through 3,990 (of 8,731 total)
Considering that this fix is included since version 10.50.1797.0, you should have it.
October 23, 2015 at 12:49 pm
Degradable (10/23/2015)
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...
October 23, 2015 at 12:25 pm
drew.allen (10/23/2015)
October 23, 2015 at 12:03 pm
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...
October 23, 2015 at 11:58 am
This:
tblCall.DATEPART(yyyy,Call_Date)
Should be this:
DATEPART(yyyy,tblCall.Call_Date)
You qualify the column, not the function.
October 23, 2015 at 11:53 am
rourrourlogan (10/22/2015)
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
...
October 23, 2015 at 7:49 am
ranjitdaljitmand (10/23/2015)
October 23, 2015 at 7:44 am
Try this: https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-conditional-split/
Do you need more guidance?
October 22, 2015 at 2:53 pm
Andrew P (10/22/2015)
RE: the answers in this threadYou guys are joking, right? right guys? :blink:
Now I'm not sure if I read the question correctly 😀
October 22, 2015 at 2:42 pm
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...
October 22, 2015 at 1:49 pm
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
October 22, 2015 at 12:48 pm
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...
October 22, 2015 at 12:25 pm
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.
October 22, 2015 at 12:13 pm
farfel (10/22/2015)
Yes it does, thank you. Regardless though, we have found it best practice to make those variables nvarchar(max). Lazy, but effective.:-)
I wouldn't call it lazy if...
October 22, 2015 at 9:55 am
I'd probably go with a Conditional split transformation which will have subsequent derived column transformations and destinations for each table.
October 22, 2015 at 9:52 am
Viewing 15 posts - 3,976 through 3,990 (of 8,731 total)