Viewing 15 posts - 106 through 120 (of 389 total)
venkat5677 (5/14/2014)
I changed destination table column length to 255 but no luck
Not sure.If you really have a luxury to change the length of destination table column.
However can you please provide...
May 14, 2014 at 11:27 pm
Phil Parkin (5/14/2014)
rhythmk (5/14/2014)
May 14, 2014 at 11:22 pm
There are blank values or spaces in the columns in your source file.Better to TRIM or limit the length to certain number as per your requirement using SUBSTRING.
May 14, 2014 at 6:07 am
Nice question with very good explanation.Thanks Andy.
May 14, 2014 at 12:54 am
lsalih (5/13/2014)
Thank you both. So how you correct the query to print 1.9?
Gail has already provided it 🙂
May 13, 2014 at 7:57 am
Resender (5/13/2014)
It's more me wondering why I should get truncation errors on colums while I'm expecting null values in that column & explicity said that...
May 13, 2014 at 7:43 am
lsalih (5/13/2014)
Sorry, one correction... I just realized that the user wanted to get the actual decimal result, in this case the result should print 1.9.
declare @val1 int
declare @val2...
May 13, 2014 at 7:38 am
As mentioned by Gail first you can not store decimal values in int.So anything after the decimal will not be considered i.e. 1.0 to 1.99 all would give you values...
May 13, 2014 at 7:30 am
Can you please provide more information like what is source,destination,transformation and error message etc.
May 13, 2014 at 7:11 am
With the help of Eirikur Eiriksson's code.You acn try this.
;WITH test
AS
(SELECT POLICY_DETAILS_ID,HISTORY_ID,CODE_ID,
ROW_NUMBER() OVER(PARTITION BY POLICY_DETAILS_ID,HISTORY_ID ORDER BY code_id) AS rn
FROM @POLHIST)
SELECT POLICY_DETAILS_ID,HISTORY_ID,
MAX(CASE WHEN rn = 1 THEN code_id END)...
May 13, 2014 at 1:23 am
Ola L Martins-329921 (5/12/2014)
If you find it easy - good for you and keep it to your self. No...
May 13, 2014 at 12:26 am
madhukars 32911 (5/12/2014)
Yes,I want to use JOINS, but this relationship is to be generated automatically on selection of the tables by the user.
I don't think in MS SQL this is...
May 12, 2014 at 4:06 am
What do you mean from auto relationship ? Please correct if you want to link all the tables.If so you can do it using join.
May 12, 2014 at 3:19 am
Not sure about your requirement.However you can always define a variable to store the curent date value and can use it as per your requirement whether in Execute SQL Task...
May 12, 2014 at 1:53 am
Nice and easy one.One can answer by seeing the first query itself.No need to see other query as only one option has answer as 1000 for first query 🙂
May 12, 2014 at 1:43 am
Viewing 15 posts - 106 through 120 (of 389 total)