Viewing 15 posts - 8,131 through 8,145 (of 13,876 total)
I would recommend that you create a calendar table[/url] and create a left join from your calendar table to the table which contains data.
September 14, 2015 at 12:00 am
HookSqlDba7 (9/11/2015)
September 12, 2015 at 12:12 am
vipin_jha123 (9/11/2015)
I have 2 source folder .
I have created variable for both source folder like below
User::Source1 and User::Source2
and 1 destination folder variable like below
User::Destination
Now I have to search a...
September 11, 2015 at 1:42 am
Eirikur Eiriksson (9/9/2015)
Phil Parkin (9/9/2015)
Eirikur, a semi-colon before a CTE? I expected better from you! 🙂
Phil, not going into the begininator/terminator debate 😀 as this is a habit for the...
September 9, 2015 at 4:49 am
Eirikur, a semi-colon before a CTE? I expected better from you! 🙂
September 9, 2015 at 1:39 am
jaquino012 (9/2/2015)
How can i accomplish to delete a selected ID's using T-SQL.
I have use this query DELETE FROM `table` WHERE id IN (264, 265).
But if my parameters are selected,...
September 2, 2015 at 1:23 am
Resender (9/1/2015)
On this file server we have a share where we put flat...
September 1, 2015 at 11:57 pm
Lavanyasri (9/1/2015)
September 1, 2015 at 11:41 pm
Good work.
I have only skimmed the article so far, but one question which came to mind relates to project-level parameters.
As these are not part of the package DTSX, I am...
September 1, 2015 at 3:42 am
debbie.coates 19265 (9/1/2015)
Thats exactly right, LC has the priority, I just ran your script and tht is doing exactly what I am trying to do.
I think not. This code gives...
September 1, 2015 at 3:30 am
Vladan (9/1/2015)
i may be mistaken, but I understand the reply with "consecutive months" precisely in the way you asked the question 🙂 that is, that there is no overlapping except...
September 1, 2015 at 3:25 am
debbie.coates 19265 (9/1/2015)
Yes, but only in the case of Type "LC", this value can overwrite all otheres. All the other types are in consecutive months.
Can you give us some...
September 1, 2015 at 3:15 am
Vladan (9/1/2015)
I think that the problem is that you shouldn't need to update anything that is in this format. I can understand, that you create some report or whatever...
September 1, 2015 at 2:51 am
sql crazy kid (9/1/2015)
[LKP - If row exists in Target [104]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record...
September 1, 2015 at 2:38 am
vipin_jha123 (9/1/2015)
I created 1 variabel with string data type.and on expression I tried to convert zonevalue variable to string using (WST_D18) but not getting
May I ask how you ever expected...
September 1, 2015 at 2:34 am
Viewing 15 posts - 8,131 through 8,145 (of 13,876 total)