Chris makes an excellent point. If there is no such mechanism, maybe you should add one. All assuming that this particular group is entirely ad hoc.

If I get this correctly (and I did look very closely at it), you need to push your current query into a common table expression (CTE), so that you can...

I'm afraid that I cannot make out much of your post. It appears that your query has been truncated. Not that I know how much help it would be to...

Looks like you are in the entirely wrong forum. This is a forum for SQL Server questions. You need to find a place where they discuss Excel.

Originally, when SQL Server was released, you could use both singe quote(') and double quote(") as string delimiter. However, when SQL was standardised, it was decided that only single quote...

I am still not sure that I understand. If you don't want to compute the hash value on update, just don't run that UPDATE statement. Or what am I missing?

Any chance you could clarify your question? I don't really follow what you are asking for.

I have no idea what was going on, but I'm curious what error message did you get when writes did not commit?

You need to learn about data types. An expression in SQL Server has a static data type. CASE is an expression. And thus, a CASE always return the one and...

SSDT is a free add-in to the Visual Studio shell. It is somewhat confusing. Sue says that it replace BIDS, and that is true, but SSDT has two faces. Originally,...

Doing that in a stored procedure? Ouch! Lot's of string parsing to do. Not fun in T-SQL.

Have a look at SSDT (SQL Server Data Tools). It will find such errors.

The actual name of the a #temp is somewhat longer - to ensure that two processes do not clash.

A #temp table is always dropped when the scope in which it...

A #temp is local to the process and disappears when the procedure exits. A global ##temp table can be seen by all processes and goes away when the process that...

All users have the right to create temp tables, and as far as I know that cannot be revoked.

You are creating permanent tables, and that is never going to work...

Your format specifies 16 fields, but the data fields only has 15 fields. The format file has a field OverrideSIRIUSPartyNameCheck, which appears to be missing in the data file. When...