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

T_SQL isn't very good at string manipulation, as you've possibly noticed. The easiest way would be to use a Regular Expressions CLR - you should be able to find...

Well, yes - if you've managed to move the data, even if you didn't do it in the most efficient way, you can still use it. But you can...

You're welcome. I didn't realise you were scripting out the INSERTs as well, and I agree with Gail that you should script out just the object creation, and use...

OK, take the penultimate join predicate and replace it with this:AND CASE -- make sure the end is after the start

WHEN d.PeriodStart > CAST(CAST(d.PeriodStart AS date) as datetime) + v.n...