Thanks for the DDL.  Yeah, the standard format of:

WHERE TransactionDate >= CAST(GETDATE() AS DATE))

will work just find for finding dates >= today at midnight.

Funny I actually tride to do a...

I don't see how OPENQUERY would provide any performance benefit here.  But, no, you can't create a temp table using OQ.

If you can provide more details of your specific situation,...

Don't limit yourself to a single format.  Just CAST it to date: if it's a valid date in any format, you'll get a date back.  If not, you'll have to...

That seems like a slick solution.  The...

What is the data type of the TransactionDate column?  If it's in the date/datetime category, then this condition:

where [TransactionDate] >= DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)

should pull all rows on or...

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, 2 months 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, 2 months 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