We have a large database with engineering data from a number of sensors. Some data is boolean, some is analog. The time base is generally 1 second,...
Roji: THANKS! I had tried concatenating the wildcard to the field, but my syntax was not working. Yours did. Perfect, thanks for the quick help....
In a "normal" database text search, the field may have full phrases in the records, and then I am looking for a word or a subphrase in that field,...
Oops. So fixated on the count portion. My bad! Thanks again! Chuck
OK, I think a temp table will work fine for this. What about part 2, getting the date_time of the last fault? Thanks again Chuck
Thanks. This is a great start. I do not have an identity column, that sure would help. The timestamp is asynchronous, so I cannot use that. Perhaps...
I have data that includes a time_date field, and a large number of data fields. One field in particular is a status number, which can be 0, 1, or 2....
Frank: Thanks again for detailed responses. This has been a great help, and the one varient is running great. I'll try out the other two you...
Here is a query that does seem to work, doing what I want. Please comment if this is an efficient way of doing it, though it does seem to work "fast...
Please note that in my example, I want to list the data associated with this time stamp selected. Therefore the data is not aggregated. I need some...
Thanks for the detailed input. Frank, your example is exactly the situation I am pursuing. For clarity, I have posted a very small example, with only...
We have a large table (100 columns, 70,000 or more rows) of experimental data. The column is Date_Time, in , yes, DateTime format. The time base on...
Separate names with a comma.
