This recent thread may help

http://www.sqlservercentral.com/Forums/Topic1721408-392-1.aspx

If (as I think you do?) you re-use column names in other tables then if you have CustomerID in your Customer Table, as the PKey or as a Unique constraint/index,...

Not sure what you are needing to achieve, but did you perhaps need:

SUM(COALESCE(pd.premium_amount, 0))

in which case you won't need pd.premium_amount in the GROUP BY.

I imagine that you don't want the...

Assuming you want to create the same Foreign Keys on the "new" table, and other Constraints similarly, there might be several that you need to rename in the event you...

COALESCE(pd.premium_amount, 0)

or

ISNULL(pd.premium_amount, 0)

COALESCE allowed unlimited parameters and will change datatype to that of the highest precedence - so if you have INT and...

autoexcrement (9/21/2015)

---

I have some stored procedures that do updates using table aliases, like this:

UPDATE TableAlias

SET ColVal = 1

FROM RealTable AS TableAlias

WHERE TableAlias.ColVal <> 1

This allows me to include joins and...

Only one I can think of (i.e. a...

I imagine SSIS has come on a lot over the years, we built "Tools" years ago that have served us well so I haven't had need to use it, as...

Never occurred...

Wow, that's handy. Thanks for telling me because I would have assumed that was not the case and then done...

Could you cross apply [capd_moduleenrolment], instead of inner join (including the tables that then JOIN to it, AND there relevant Where clause bits and pieces)?

Ah .. .so ALTER TABLE ... REBUILD rather than ALTER INDEX ... REBUILD ?

I had a look at BoL and it appears that ALTER TABLE ... REBUILD will rebuild clustered...

Just a thought: perhaps the default in the popup formfield could be changed from # to "#000000"? as I probably had not been using enough digits either (although that was...

Thanks for that. I've tried to use COLOR and failed, I had never thought to use QUOTES before ...

This contains some RED text

This contains some [color="#ff0000"]RED[color] text 🙂

That said, HIGHLIGHT...

I agree, except that whenever I see it used it is never used with the Full Recovery Model (equivalent) syntax, even...