This looks like it works...

CREATE TABLE #Test(
 col1 int,
 col2 int,
 col3 int);
GO
INSERT INTO #Test VALUES 
 (1, 203, 1232)
,(2, null, 2343)
,(3, 502, 15566)
,(4, null, 4566)
,(5, null, 4545)
,(6, 601, 4545)
,(7,...

This is the approach.  You can use CHAR instead of BINARY, but then you have to worry about padding the strings so that the MAX() works correctly.  You can also...

• This reply was modified 6 years ago by drew.allen.

SQL Tables represent sets which are UNORDERED.  There is no concept of "values that exist right before it", because there is no concept of "before". You have to specify some...

One of our groups is using MongoDB and we got a notice that we're evaluating making it more widely available.  In the announcement was a link to a course we...

This is a packing intervals problem, not a gaps and islands problem. The two are different, but related.

Please provide sample data and expected results. We can't run your query, because...

Thanks again!  So are you saying the table structure in my example would be OK for data storage, but instead of using checkboxes at the UI level, use a...

Typically one would use a bit value setting to reduce space usage.  For example:

languages int NOT NULL

You'd want a separate table with the language code values:

CREATE TABLE #language_codes (...

separate...

I will be honest about this. I am one of the few people who actually sits down and reads ANSI/ISO standards. They are incredibly dull, and you need to...

You've designed this in such a way that it's cumbersome to add new languages.  Checkboxes requires you to update your web form and having a separate column requires you to...

I should know the answer to these questions, but I'm having trouble with a couple of my queries.

First, my goal here is to compare data from a table in...

Why are your seconds stored as strings? Convert them to integers, then this should do the trick.

SELECT  *, [HH-MM-SS] = CAST(DATEADD(SECOND, l.Seconds, 0) AS time(0))
FROM...

Good and bad. worked a bit and then spent the last day and evening with...

You haven't said what you are using to display this information.  It may be (much) easier to do this in your presentation layer than the database layer.

Drew

I personally don't...