I was once interviewing for a role and the candidate turned up 1 hour late. Her explanation was that the address of our office was "Lower Mortlake Road" so she found...

Frank raises an interesting point - that people shouldn't apply for these positions in the first place. I lay alot of the blame for this at the door of a...

Fair point Chris but I assumed from Josh's meant that he once saw a CV (or similar) that talked about "Sequel Server". If this was the case I can understand Josh's actions!

-Jamie

I work in the city and £50k minimum I would say. A colleague and myself were looking on Jobserve the other day and there were senior SQL DBA jobs offering...

With flying colours!!! 

ffff

<quote> I hope Jamie has unsubscribed from this post..what a lot of meaningless trash to clog the inbox with!</quote

Err, I actually didn't. I went...

No particular reason. Its just part of our sproc template that's been in use since well before I came here.

As tricky as the stuff in the 30th post of this thread?

I did try it, honest . Check the 7th post of this thread. Admittedly not wrapping it in exec(). If only I'd known!!!!

Still, our...

Really? OK, here ya go! I could go through and colo(u)r code it all but I'm sure you're capable of copying it into QA

Yeah, that's not particularly nice is it?

I'll stick with the OA methods that Paul has written for me (he's only actually sat 3...

The anomoly is nothing to do with concatenating strings in the exec() function. I know because when I executed the following:

declare @str1 varchar(100), @str2 varchar(100), @str3 varchar(100)

Hey, that's very cool. SP:StmtCompleted did the job!

There was one anomoly. When I did "exec (@sql1)" then I did indeed see all the statements executed along with the comment "--Dynamic...

Yes, that's exactly what you need. This article should help: http://www.sqlis.com/default.aspx?59

-Jamie