Oh, no, 'row key' is not a name. Those are two names, name of the...

Note CONCAT() is here since 2012 only. You are asking at wrong forum or trying to use what doesn't exist.

Thanks for sharing, looks very promissing.

"Written for Microsoft SQL 2008 R2 or later, but should run on MSSQL 2005.".

No, spShowSlowQueries() will not compile in 2008 because sys.dm_exec_query_stats() was...

Suppose

select col1, min(col2), max(col2) , count(col2)

from mytable

group by col1

returns 1 , -10, 5000, 1000

What do you mean, select col1, col2 ... ? Which col2 value?

If i got it right.

CREATE TABLE [dbo].[MstrPerson](

[PrsnCode] [char](8) NOT NULL,

[PrsnName] [varchar](30) NULL,

[PrsnGrpCode] [varchar](12) NULL,

[PrsnMdfdBy] [smallint] NULL,

[PrsnMdfdOn] [datetime] NULL,

CONSTRAINT [PK_MstrPerson] PRIMARY KEY CLUSTERED

(

[PrsnCode] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =...

Besides providing DDL and test data script you should explain yor task in more details.

Looking at the desired output i see no reason why Person.PersonGrp ='grp1' matches both 'grp1'...

halifaxdal (1/16/2015)

Jeff Moden (1/16/2015)

Its fine the way you have it. If your history table has exactly the same schema and datatypes as the source table, then there's something very...

Quite well elaborated, thank you.

Thanks for sharing it.

In the posted trigger code there is DECLARE @USER_MASTER_ID INT which is never used. I guess code is simplified for a reason. Any chance that some @USER_MASTER_ID calculations are causing...

Just to help restate the task in more formal way let's start with this (not tested due to lack of DDL and sample data script)

-- Date interval params

declare @sd date...

Something like

select

case

when <logical expression1 depending only on High, Medium, Low columns> then 'High'

when <logical expression2 depending only on High,...

In Management Studio you may use Expot and Expot Wizard to import data from Access.

Next your queries may be saved as stored procedures or views or TVFs. But i think...

At least share an error message. Is it "Subquery returned more than 1 value" or what ? Or better show the trigger .

This is because sp_executesql runs the query in a separate context where no variables from calling context are available.

See BOL for how to declare and pass parameters for dynamic...