Viewing 15 posts - 9,796 through 9,810 (of 13,874 total)
Hi Jeff
There's a free IDE for PowerShell here, in case you are coding using some bytepad editor 🙂
June 20, 2013 at 5:25 am
How do you intend to use this function? Have you considered writing it as a stored procedure instead?
June 20, 2013 at 12:38 am
Also, this sounds like it might be a task for SSIS - have you considered that as an alternative?
June 20, 2013 at 12:35 am
I would suggest that you need to change the design of the target database so that you do not have identity columns as PKs there. Just make them standard INT...
June 20, 2013 at 12:33 am
I've just skimmed this thread so apologies if this is not what you're looking for. But why not adjust the WHERE clause as follows:
where SomeVal2 = 'ABC' or SomeVal is...
June 20, 2013 at 12:26 am
gissah (6/19/2013)
Thank you sir, All I want to do is just populate the [BusinessDay] column on my table sequentially(1234...) if a day qualify as a business day or workday(MTWTF). Thanks
What...
June 19, 2013 at 10:43 am
We clearly operate in very different environments, as I stick by my comments too - glad that I gave you a laugh 🙂
June 19, 2013 at 8:18 am
Even if that is what you intended (it often isn't) ALWAYS EXPLICITLY USE BEGIN/END with IF/ELSE constructs:
ALWAYS is a bit strong. I'm not going to start replacing
if object_id('tempdb..#tmp', 'U')...
June 19, 2013 at 4:28 am
I just read your post and have no idea what you are asking for - or were you just informing people of what you are working on at the moment?
June 19, 2013 at 4:17 am
var05 (6/19/2013)
Thanks for your reply,Yes the account under which the sql agent jobs runs also has permissions to the shared folder. but the job is still failing. Any help?
Thanks!
Sorry to...
June 19, 2013 at 4:13 am
The SSIS temp table 'hack' is described here[/url]. A relatively straightforward publication of meta data does the job.
In 2012, the hack changes, but given the forum, I'm assuming that you...
June 18, 2013 at 1:14 pm
Are you selecting from a temp table in your process? Does your process have set nocount on at the top?
June 18, 2013 at 10:33 am
andy.westgate (6/18/2013)
Good to have that confirmed. It was the lack of mapping between the DFT and the Exceil destination that was throwing me but I have a couple of...
June 18, 2013 at 8:18 am
andy.westgate (6/18/2013)
This is also the problem I am having.
I want to execute a stored proc and output the results to...
June 18, 2013 at 7:58 am
Running out of ideas, I'm afraid. You are right in thinking that there is not normally any need to mess about with built-in assemblies.
June 17, 2013 at 7:49 am
Viewing 15 posts - 9,796 through 9,810 (of 13,874 total)