In ASA there is a LIST() aggregate function, so the query would be simple as this:

select FirstName , LastName , list(ContractType) from contrators

group by FirstName , LastName

MSSQL does not have...

That's a bug in sqlserver.

Datediff(m,@birthdate,getdate()) subtracts dates and returns months.

Datediff(d,@birthdate,getdate()) subtracts dates and returns days.

Datediff(yy,@birthdate,getdate()) subtracts year parts, contrary to expectations and documentation wich says "Returns the number of intervals...

Infinity is not a number.

It's not equivalent to null either. The example was meant just as a method of presentation. To let you understand what is null like. It's...

In numeric expression think of NULL as infinity (for some expressions) rather than 0, as 0 is an exact value, infinity is not:

[something] + [infinity] = [infinity]

[something] * [infinity]...

Thumbs up. You're a dba and see this poorly designed app. You...

'sa' account should be used for administrative purposes only. If a third party application uses sa account, it must be modified to either explicitly ask for user credentials, use windows...

Thank you.

However, it doesn't help me much as is, because I need identify it without knowing the exact name.

But, I came up with a pretty solution - autogenerated names differ...

Every table must have a surrogate key, integer, guid or whatever used for referential integrity. Natural keys must supplement integrity, because:

1. they're not always available (usually for 10-20% of tables)

2....

You rarely need an index for more than few columns. For index to be efficient, it must assure at least partial selectivity, best on most selective column.

For example, you have...

That does it. I completely missed the fact that instead of trigger happens before action. There are some restriction on this type of triggers, but better than nothing. Thank you.

Transactions...

Thanks, but I'm aware of that. According to "best practices", a trigger should not mess with transactions.

Besides, a well behaved client gets kicked: starts transaction, executes update, trigger rolls back and...

Create a surrogate column that holds uniform versioninfo that is updated by insert,update trigger. You can use code from previous posts for transformation.

Unless the table is very small in...

SELECT c.CT_Id , c.Category , COUNT(mt.CT_Id) FROM Category c left outer join MasterTransaction mt on mt.CT_Id = c.CT_Id GROUP BY mt.CT_Id

Since parent categories have no transactions, their count...