Viewing 15 posts - 4,531 through 4,545 (of 11,676 total)
sqlserver12345 (10/13/2013)
Msg 137, Level 11, State 1, Line 0
[Microsoft][SQL Native Client][SQL Server]Must declare the scalar variable "@ID".
Msg 16805, Level 11, State 1, Procedure sp_makewebtask, Line...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 14, 2013 at 3:33 am
PhilipC (10/14/2013)
Thank you. No real advantages for us in using Windows 12 over 2008 R2 really.
Ed of course forgot to mention the slick Metro user interface! :w00t: 😎
Reason enough to...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 14, 2013 at 3:28 am
Please read the first article in my signature on how to post questions. 😉
It will give you more info on how to post table definitions, sample data etc.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 14, 2013 at 3:20 am
nalini.kumari143 (10/14/2013)
As per my Client requirement That's y am asking is it possible in control level using with execute sql
Clients and their strange requests sometimes. :rolleyes:
You can do it in...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 14, 2013 at 3:07 am
pavithrareddyc (10/14/2013)
I wanted to try using cursor. I know that performance is poor but still i want to implement the logic using cursor.
You can start by providing table DDL, sample...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 14, 2013 at 3:06 am
sureshdk (10/14/2013)
In some environrment xp_cmdshell is disabled/removed because of the hardening purpose. So we may not use this, is there any alternate method?
Yes, use the options in SQL Server Agent...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 14, 2013 at 2:35 am
Koen Verbeeck (10/14/2013)
nalini.kumari143 (10/14/2013)
Hi,is it possible to do this task on control flow level in ssis
No, you need a data flow.
Any reason you don't want a data flow? They...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 14, 2013 at 2:30 am
nalini.kumari143 (10/14/2013)
I want to implement the SCD with row level log using CheckSum option in Execute Sql Task
My Source table : Emp_Source(EId ,EName,Sal,Deg,Staus) -- here staus is add/update/delete
My Destination...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 14, 2013 at 2:30 am
Any reason why you need to use a cursor?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 14, 2013 at 2:29 am
Interesting point of view. I find it quite a hassle though to execute SSIS packages using the way you proposed. Validating a package to find out if it is 32-bit...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 14, 2013 at 2:20 am
nalini.kumari143 (10/14/2013)
Hi,is it possible to do this task on control flow level in ssis
No, you need a data flow.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 14, 2013 at 2:10 am
wendy elizabeth (10/12/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 14, 2013 at 1:00 am
TSQL is set-based, meaning, it's all or nothing in a transaction. If one row fails, the entire statement fails.
You can however achieve your requirements very easily in SSIS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 14, 2013 at 1:00 am
Easy one, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 13, 2013 at 1:39 pm
I guess those add-filled blogs are free of hosting charges, so they can linger in limbo for a long time.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 11, 2013 at 7:35 am
Viewing 15 posts - 4,531 through 4,545 (of 11,676 total)