Viewing 15 posts - 8,131 through 8,145 (of 13,882 total)
...changed its output as parameter...
Can you please explain what you mean by this?
September 14, 2015 at 11:11 am
mar.ko (9/14/2015)
However, I don't agree that using comma-delimited lists violates any rules of relation theory.
A list is a list....whether it's in table form...
September 14, 2015 at 10:44 am
Kristen-173977 (9/14/2015)
Phil Parkin (9/14/2015)
This is not correct. They can insert into local table variables, which are then returned by the function.
Sorry, I mistook @RETABLE as a parameter to the...
September 14, 2015 at 9:42 am
Kristen-173977 (9/14/2015)
A Stored Procedure could do.
The Function could return the SQL, for the code...
September 14, 2015 at 8:34 am
This seems somewhat long-winded and will not scale well (because it's not an iTVF).
Can you give a bit of background about what you are trying to achieve & what the...
September 14, 2015 at 8:00 am
Kristen-173977 (9/14/2015)
Phil Parkin (9/14/2015)
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.
Any mileage in looking...
September 14, 2015 at 2:12 am
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
Viewing 15 posts - 8,131 through 8,145 (of 13,882 total)