Viewing 2 posts - 1 through 2 (of 2 total)
I don't know where you going to code this batch exec code but can you do this?
if within sql then
declare @execstatementsbatch nvarchar(max)
select @execstatementsbatch = ''
SELECT @execstatementsbatch = @execstatementsbatch ...
February 2, 2011 at 10:13 am
#1281541
You can make this function more generic by taking one more parameter
@Separator VARCHAR(5)
and inside the code instead of hard-coded comma you could use this parameter.
This will handle the cases...
November 30, 2010 at 12:04 am
#1256619