Viewing 15 posts - 5,551 through 5,565 (of 11,677 total)
You can modify data that way, but it is rather quick and dirty.
And you need to be sure your view is updateable.
I'd still prefer to write a decent update query.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 16, 2013 at 1:58 am
Interesting question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 16, 2013 at 1:53 am
Erland Sommarskog (7/15/2013)
Koen Verbeeck (2013-07-15)
SSIS is completely renewed, introduction of SSAS tabular and Power View, columnstore indexes, AlwaysOn Availability Groups, ...
OK, there is try_convert() too. As for improvements to SSIS...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 16, 2013 at 1:30 am
Erland Sommarskog (7/15/2013)
The fact there is not an abundance of new great features may also matter. (Well, there is one: WINDOW FUNCTIONS!)
You must be joking right? 🙂
SSIS is completely renewed,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 15, 2013 at 2:23 pm
Erland Sommarskog (7/15/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 15, 2013 at 2:20 pm
You could use a lookup component to find out if a record in the data feed is a new record or an updated record.
You can insert new records with an...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 15, 2013 at 2:15 pm
Interesting question for a Monday 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 15, 2013 at 1:14 am
Sean Lange (7/12/2013)
Koen Verbeeck (7/12/2013)
Brandie Tarvin (7/12/2013)
Koen Verbeeck (7/12/2013)
Is there a difference in the US between passport and ID?
Yes, there is. Passport allows us to cross borders with other countries....
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 15, 2013 at 1:12 am
jjr.123 (7/14/2013)
other string variable to hold the packageName , and...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 15, 2013 at 1:10 am
sneumersky (7/12/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 15, 2013 at 1:09 am
Mike Gray-474150 (7/12/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 15, 2013 at 12:59 am
Maybe you installed the 32-bit client while SQL Server is 64-bit?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 15, 2013 at 12:57 am
The tool generates all the data found in the table, so it's all or nothing.
Maybe you can create a duplicate table and insert into that table only the data that...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 15, 2013 at 12:54 am
Are you sure it has the status "executing" instead of "running"? I have never seen the executing status before...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 12, 2013 at 7:23 am
This should get you started:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 12, 2013 at 6:49 am
Viewing 15 posts - 5,551 through 5,565 (of 11,677 total)