I'll assume that:

1) you have some way to get the OrderType from the OrderID since you'll need the Type to join to the Buck bits table as it's given

2) you...

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, 4 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, 4 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...