SQL can't execute the query as you've written it because there may be multiple values of T1.LineNUM for a given combination of DocEntry and ChapterID.

For example, suppose these two rows...

You need to use sp_executesql rather than just exec(), because sp_exec allows value(s) to be returned:

DECLARE @SQLSTR nvarchar(500)
DECLARE @DELCOUNT int
...
SET @SQLSTR = 'Set IDENTITY_INSERT Table_2 ON;DELETE from...

I think the code below is much simpler.  The code is complete, no function needed.  And, yes, I took a short-cut, so, yes, this code will fail for 2100.  If...

• This reply was modified 6 years ago by ScottPletcher. Reason: Tweaked the code

That q obviously makes it self-evident.

Accounting entries are not properly classified simply by a + or...

So can you do this or can't you? The ONLY question you have to ask, is if the OP's design allows negative numbers. If the OP NEEDS...

I gotta go with...

SELECT OBJECT_NAME(c.object_id) AS TableName
FROM sys.columns c
INNER JOIN sys.tables t ON t.object_id = c.object_id
WHERE c.name IN ('Column1','Column2','Column3')
GROUP BY c.object_id
HAVING COUNT(*) = 3
ORDER BY TableName

• This reply was modified 6 years ago by ScottPletcher. Reason: To correct GROUP BY from "OBJECT_NAME(c.object_id)" to just "c.object_id"

I gotta go with Joe on this. The...

The slight extra space is to store the upper level(s) (root level and intermediate level(s)) of the index, which are the b-tree structure that allows quick searches to specific row...

SELECT ClientID
FROM #Projects
GROUP BY ClientID
HAVING COUNT(DISTINCT ClientRole) > 1
ORDER BY ClientID

I prefer using CROSS APPLY to assign alias names.  CAs can also cascade, where one alias can be used to create another alias(es).  That's very helpful sometimes.

select BSEG_ID,SP_ID,FINAL_REG_QTY,START_REG_READING, END_REG_READING,

ActualRead

from CI_BSEG_READ

cross...

.1. The PK itself.

.2. No.

.3. The clustering key column(s) are stored in higher-level index entries.  The deeper the index depth, the more space the upper levels of the index take.

I don't think his first post was particularly snarky, esp. for him,...

My next correction is a little more controversial. The reason that debits and credits exist has to do with the fact that when modern bookkeeping began in the Renaissance,...

I left one out, the sample INNER JOIN:

;WITH cte_A AS ( SELECT * FROM (VALUES(1, 'A', 10),(2, 'B', 20), (3, 'C', 30)) AS data(key_col, col1, col2)
), cte_B...