Viewing 15 posts - 7,756 through 7,770 (of 13,876 total)
vipin_jha123 (1/5/2016)
I have source flat file , I want to exclude the records containing below state.
I have created one variable which data type is string and value is as...
January 5, 2016 at 8:36 am
hartmann 74688 (1/5/2016)
Personally, I will continue to use datetime unless I need the additional accuracy afforded by datetime2. Why? Because datetime columns perform better and require less disk space than...
January 5, 2016 at 8:19 am
I spotted a few minor typos:
"legacy tables that uses datetime" - use
"some developer simply" - developers
"8 byte of storage" - bytes
"ambigous" - ambiguous
"Let;s " - Let's
January 5, 2016 at 8:18 am
hartmann 74688 (1/5/2016)
pjdijkstra (1/5/2016)
January 5, 2016 at 8:10 am
Have you considered using Change Tracking?
January 5, 2016 at 6:20 am
The columns in a single result set cannot vary between rows.
But maybe you can create a simple result set containing something like (RecId Rownum Data) where the Data column is...
January 4, 2016 at 4:59 pm
RonKyle (1/4/2016)
Are you sure that the connection string you were 'using in the package' was not being overridden by a config item (eg, an Environment Variable)?
Yes, I'm sure. ...
January 4, 2016 at 1:25 pm
RonKyle (1/4/2016)
January 4, 2016 at 1:07 pm
Alan.B (1/4/2016)
--For me, that's been the 0.0001% exception.
Wow. That suggests you have written/tested 10,000 (or more) TVFs :w00t:
January 4, 2016 at 11:21 am
TheSQLGuru (1/4/2016)
lucien.jacquet (1/4/2016)
January 4, 2016 at 10:27 am
mw112009 (1/4/2016)
Please see the attached pic first.
I like to add an event handler and in that I could setup a SQL task to write to a table when a "SQL...
January 4, 2016 at 10:13 am
Thanks!
If it's a single-database process, SSIS is rarely a recommended way forward. I'd still put the code in a stored proc though, and use SQL Agent to execute that...
January 4, 2016 at 8:19 am
karen.blake (1/4/2016)
So, there is a table where we need to...
January 4, 2016 at 7:53 am
Eirikur's response rendered what I was going to write mostly redundant. But I do have some minor points:
1) If you 'obfuscate' something, you make it unclear or difficult to interpret....
January 4, 2016 at 6:59 am
Eric M Russell (12/30/2015)
Orlando Colamatteo (12/30/2015)
December 30, 2015 at 12:52 pm
Viewing 15 posts - 7,756 through 7,770 (of 13,876 total)