Luis Cazares (7/11/2016)

Mohit Dhiman (7/11/2016)

Can't see why this should not work. Which version of SSIS...

Miguel

Get sp_whoisactive and run it when you see the blocking. That'll tell you who or what is doing it, and you can ask or force them to disconnect.

John

Mid-morning for me, Jeff. Easier to think when you've been awake for a few hours!

John

Unless you upgrade to SQL Server 2016 and use the Query Store, you're not going to be able to get what you're looking for with total accuracy. You can...

I would generate it on the fly instead of persisting it...

Abhas

Assuming that Code is enclosed in double quotes ("CPP") but CIData isn't (n/a), I think your expression needs to look something like this:

Code == "\"CPP\"" && ClData!= "n/a"

John

Only if the queries that are being run are rubbish enough to include passwords in them. But it comes down to this: they either trust you to do your...

Not quite. The "sql" is telling the website that it's SQL code so that it can splash it with lots of pretty pinks and blues. No, type where...

Yes. Have a look at this.

John

You can either type those tags as you see them, or you can select them from the IFCode Shortcuts section, just to the left of where you type, in the...

If the admin of the server won't increase your privileges, I think you have no choice but to set up your own instance on which you can do what you...

It may be your company trying to protect itself against people posting code from its computers. You may find you have to do things like this to get it...

OK, so import the extensions using SSIS , bcp, BULK IMPORT, OPENROWSET or however else is easiest, as Joe suggested, and then use a query like the one I post...

Where does that list of phone extensions come from - another table, a spreadsheet, somewhere else?

John

Why not do it like this?

WHERE MyCol IN (

SELECT MyNumber FROM MyOtherCol

)

John