Thanks for the reply.

Yeah I knew about this SP. I was hoping for a readmail procedure through.

Worked it out shortly after - decided on a alternative solution now anyway. But for anyone who's having the issue;

Public Sub Main()

...

hi mate, here's the script. Works fine, with the limitation mentioned above.

drop procedure usp_Display_Pattern

go

create procedure usp_Display_Pattern

@widthOfPattern ...

thanks for the reply mate,

basically I have to create a stored procedure which will accept several params to produce an output. The only issue I'm having is the replication restriction.

One...