>> I need to get a rolling count only of rows matching a particular criteria and to use the result in a concatenated output field [sic].

The remaining rows (those not...

You missed one of the major points in modern programming since the 1970s. SQL and other client/server-based architectures depend on tiers. SQL works in the database tier of your architecture....

The first and we ought to do is correct your DDL. Identity is a table property and not a column, and by definition can never be a key in a...

This is in the realm of mathematics and not standards. There is no ANSI/ISO standard for structured programming, RDBMS theory, or anything like that. However, our modern view of scales...

You don't seem to understand that a table must have a key by definition. But what you posted because of the columns are knowable can never have a key of...

Could you please start posting talents and venting your own language? Now we have to rewrite everything. Why do you think that the proprietary identity table property could ever be...

Look up the nested set model for hierarchies and trees. This will make your problem trivial. Also in the future, would you mind posting DDL instead of spreadsheet pictures? We...

Let's correct your DDL first. You really have only one employee and one customer, as your table names tell us? Probably not. Because identifiers are on a nominal scale, they...

>> I want to have a sum of the item count reset to 0 when the sum >= 6. <<

Did you know that a table must have a key by...

I hope you understand that the old Sybase IDENTITY table property (property -- it is not a column) can never by definition be a valid key. It is a count...

People don't read them, because they charge an exorbitant amount of money to get them. I, for one, would read them if they were available for free online.

The problems have...

>> I have sadly run into the issue where I don't actually know the question to ask to get the answer I need or to be able to formulate a...

Instead of inventing your own encoding scheme, did you ever consider using the ISO Standards that are already in place? Just Google them. This is as silly as using the...

>> I have a database with three tables linked [sic] together by 'DocumentNo'. Two main linked [sic] tables which output all rows with a full outer join. These records [sic]...

>> I have a table called tblgender like below <<

We need to fix a few things before you get anywhere. You're supposed post DDL so we don't have to guess...