Viewing 15 posts - 106 through 120 (of 390 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...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
May 14, 2014 at 11:27 pm
Phil Parkin (5/14/2014)
rhythmk (5/14/2014)
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
May 14, 2014 at 6:07 am
Nice question with very good explanation.Thanks Andy.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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 🙂
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
May 13, 2014 at 7:30 am
Can you please provide more information like what is source,destination,transformation and error message etc.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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)...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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...
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
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 🙂
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
May 12, 2014 at 1:43 am
Viewing 15 posts - 106 through 120 (of 390 total)