Yes, I'm familiar with PLCs. I used to work for a company that wrote custom data collection and reporting systems for manufacturers.

I'd start out by looking up the JOIN, GROUP BY and HAVING clauses in Books Online.

Does this solution take into account that multiple data points could be collected in an alarm state? Does it also take into account that a machine can fall into and...

Maybe Something like...

Declare @MatchLevel int

Set @MatchLevel = 1

Select ColumnCount =

Case when 1ML <= @MatchLevel Then 1 Else 0 End

+ Case when 2ML <= @MatchLevel Then 1 Else 0 End

+...

You can perform cross database joins/unions by fully qualifying the table names like

Select a,b,c

From database.schema.table

union all

Select d, e, f

From database.schema.table

etc...

I hope the set based purists don't yell at me... 😀

I'd create a temp table populated with the machines and date ranges I want to process. I'd also create a...

Is it a typo, or are you really intending on selecting the same table into itself?

I've noticed this on occasion as well (something runs well/as expected in query analyzer, but...

I've been developing VB apps since around '98, and we have never really used ADOs built in record creating/editing capabilities. If you can, a better route is to create an...

Look up the SET ANSI_WARNINGS and SET ANSI_NULLS statements in the Books Online, and let us know what you find...

I see another potential problem here...what is the datatype of your column in the table? You are declaring your variables as type varchar, but if your columns are a datetime,...

You haven't recently turned on transactional replication have you? That may cause your log size to increase. Also, Index reorganization and rebuilding (depending on your recovery model) are fully logged,...

If you're using SQL 2005, then SSMS IS Query analyzer as well... They are not 2 seperate tools like they were in 2000.

Another thought here...

you can "cast" a column to a particular collation at select time.

For Example

Select distinct LastName COLLATE SQL_Latin1_General_CP1_CI_AS

From testtable

If you had a case sensitive column, you can...

A very warm New Year to you too (and hopefully not because of global warming 🙂

Are you asking to do something like this?

Select * from

table1 join table2 on whatever

Where...

OK. Well, sometimes just writing something out loud helps you problem solve.

I decided to do a schema compare to find a list of indexes in the main database that...