Viewing 15 posts - 9,811 through 9,825 (of 13,874 total)
Do you have SSIS installed too?
June 17, 2013 at 7:11 am
Script tasks and script components are different things - which one do you mean?
June 17, 2013 at 4:47 am
Do you have anything on the resultset tab?
Edit - well done on solving it.
June 14, 2013 at 8:46 am
Try putting
SET NOCOUNT ON
at the top of your proc.
June 14, 2013 at 8:26 am
swetha.prachi (6/14/2013)
The data in the file is encrypted and we need to decrypt it
Do you know how to do it with execute process task?
Thanks,
Swetha
Taking SSIS out of the equation, do...
June 14, 2013 at 2:45 am
mrichardson 57577 (6/13/2013)
If I was selecting just 1 column in a simple query it would probably work, but...
June 13, 2013 at 9:28 am
I never said it was a good idea - Gail's answer would have been mine too.
June 12, 2013 at 6:34 am
$w@t (6/12/2013)
I am not going to use it anywhere..I faced this Question in interview..so i posted here
I Just want to...
June 12, 2013 at 5:57 am
$w@t (6/12/2013)
Hi,Can we call stored Procedure inside a function
Thanks
Why did you ask this question, when you already believed you knew the answer?
Would you consider implementing the method shown...
June 12, 2013 at 5:30 am
mahavidhya24 (6/11/2013)
Cross apply is very difficult than join ...i think there is no data available depends upon your requirement give the table of contents connected with this query.
Please explain what...
June 11, 2013 at 11:49 pm
There is an alternative way of doing this - you might like to check to see whether it performs any better:
with maxJournal
as (
select ClientId
,JournalId = MIN(JournalId)
from Journal
group by ClientId
)
select *
from...
June 11, 2013 at 11:47 pm
mrtrich99 (6/11/2013)
Lidou123 (6/6/2013)
Hi,I have the same problem.
Did you found the solution ?
How to prevent the creation of a folder which already exists
I have not. I just manually rename the...
June 11, 2013 at 11:29 pm
sarah.cook (6/6/2013)
I need to create an id from a nvarchar value that is repeatable, sort of like a checksum or a hash, except that it needs to be unique...
June 11, 2013 at 11:23 pm
I would add an OUTPUT clause to your DELETE query. Have a look at the examples here.
June 11, 2013 at 8:34 am
No problem and thanks for posting back.
June 11, 2013 at 7:34 am
Viewing 15 posts - 9,811 through 9,825 (of 13,874 total)