The function returns Labor(sic) Day 2014 as opposed...

I always thought it was one of these:

I'm seeing 15% (13/85) for both at the moment.

It doesn't 🙁

I always use this feature. It's a great way of differentiating between development, staging and live connections.

Yes, it's double quotes for SSIS functions and single for T-SQL.

Thanks. It was a function that I'd never heard of either but came across it whilst looking up something else a couple of weeks back. It looks as though it...

That's better. In the unlikely event that anybody is more...

No,...

Easy one, thanks.

Ola L Martins-329921 (5/12/2014)

---

Only because you find it easy, it doesn't necessarily is for all...

If you find it easy - good for you and keep it to your self. No...

Doesn't work for me. If I press that combination I just get "Waiting for second key of chord..."

Perhaps it's because I have SQL Complete installed.

Easy (after I looked it up).

Despite popular opinion (see above) there's no "easy" answer to this. NOEXEC is good but it won't find everything and there is the risk that you might miss one somewhere.

I...

Hi,

I think you need to do the whole statement in dynamic SQL. Something like (in addition to what you have):

DECLARE @sSQL NVARCHAR(MAX);

SET @sSQL = 'USE [ +...