You don't want index_columns and indexes in the query as it exists, because it will just generate duplicate rows for no reason.

SELECT TOP (1)

st.name [Table Name],

c.name [Column Name],

t.name [Data Type]

FROM...

You need more clear examples.

For example, if line 1 was the starting line, which of these lines would be included:

0 200 0 0 501 --line 5

200 0 0 0 0...

That's a very interesting idea. It sounds very complex to implement, but quite nice once you get it working.

The trigger is actually rather easy to write and can be...

• This reply was modified 6 years, 11 months ago by ScottPletcher.
• This reply was modified 6 years, 11 months ago by ScottPletcher.

Bit data type is numeric in SQL: naturally 1 means Yes, 0 means No.

So:

CREATE TABLE dbo.table_name ( bit_column bit DEFAULT 1 );

But you also made the blanket statement that:

And...

• This reply was modified 6 years, 11 months ago by ScottPletcher.

Not necessarily true. Indexes can also allow SQL to avoid a sort (and sorts are expensive operations).

For example:

Add a clustered index on id to the table.

Then this query should...

You'd have to use an INSERT trigger. It could be an INSTEAD OF INSERT or an AFTER INSERT trigger.

Yep. Save the system variables (@@) into local variables (@) after the relevant statement(s), then test the local variables instead of the system vars. Note that you need...

• This reply was modified 6 years, 11 months ago by ScottPletcher.

I didn't, and wouldn't, look at the links. But thanks for the heads-up on this poster.

You can have the db name in an ALTER, just not the server name (note the message says two prefixes, i.e., a total of 3 levels of object name). ...

• This reply was modified 6 years, 11 months ago by ScottPletcher.

You must add an ORDER BY clause to the query to get the rows to be in a specific order. But, the ORDER BY must also be in a...

For clarification, a SQL column does not have to be all the same type: SQL has a type of sql_variant that is designed to handle different data types in the...

You can only put columns in the OUTPUT clause from the INSERTED and DELETED table(s), if/when each is present.

Sadly, you can't use any column from any input in the query,...

• This reply was modified 6 years, 11 months ago by ScottPletcher.

;WITH
cteCalcBaseDates AS (
  SELECT DATEADD(MONTH, 7 - CASE WHEN MONTH(GETDATE()) < 8 THEN 12 ELSE 0 END,
  DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()), 0)) AS Aug01,

The GROUP BY Entry Num should be enough:

SELECT H.Customs_Entry_Num,
  MAX(h.Total_MPF) AS Total_MPF,
  SUM(L.MPF) AS Line_Sum
FROM ADHOC.ATS_ESH H
INNER JOIN ADHOC.ATS_ESL...