I'm thinking something like this...

WITH

scores(ID, creationdate, score, MCC) AS--SAMPLE DATA

(

SELECT 1, '2014-08-02', 30, 7422 UNION ALL

SELECT 2, '2014-08-03', 40, 7422 UNION ALL

SELECT 3, '2014-08-01', 100, 7500 UNION...

It looks like John beat me to it, if you can post a query plan that would be a great help - see: How to Post Performance Problems[/url]

I would second both recommendations and add that you can't go wrong with any Itzek ben-Gan book.

Learn what a tally table is; that has changed my career.

This site...

... I was thinking, using the logic in my previous post you could create a dbo.SubstringBeforeSSI function (examples included in the code)...

ALTER FUNCTION dbo.SubstringBeforeSSI

(

@string varchar(1000),

@substring varchar(100),

@substring_index tinyint

)

/*

DECLARE @string varchar(1000)='10.0.1600.22',

@searchPattern varchar(100)='.',

@substring_index...

This wont perform as well as what Eugene posted but is a solid, set-based way to solve this problem dynamically...

Using my Ngrams8k function:

ALTER FUNCTION [dbo].[nGrams8K]

(

@string VARCHAR(8000),

@n TINYINT,

@pad BIT=0

)

/*--

Created by:Alan Burstein

Created...

Another Approach:

;with

CurrentResutSet(Period, Sense, mt, Total) AS

(

select '2014_S27', 'CPT', 1, 215 union all

select '2014_S27',...

As Louis said, DDL and what you have tried will help us help you faster. That said, I think you are looking for this:

WITH

your_data AS

(SELECT *

FROM (values ('ClassA',10001,'Y','Eligible',1,1),

...

dagnea (9/16/2014)

---

...he insisted that the log file on the publishing database will not get truncated and will grow until the stopped subscription is started and the subscriber synched.

Does this make...

A couple variations (these will get you the same query plan as what rxm posted).

SELECT isnull(cast(id as varchar(12)),'Total'), sum(cnt)

FROM @rollup

GROUP BY id with rollup;

or...

-- since we're only...

I suspect they were talking about:...

:Whistling:

Sean Lange (9/11/2014)

---

Alan.B (9/10/2014)

---

months as

(

select 1 as MoNo, 'January' as Mo union all

select 2 as MoNo, 'February' as Mo union all

select 3 as MoNo, 'March' as Mo union all

select...

months as

(

select 1 as MoNo, 'January' as Mo union all

select 2 as MoNo, 'February' as Mo union all

select 3 as MoNo, 'March' as Mo union all

select 4 as MoNo,...

I love SSMS 2012 and have not had any of the issues you describe. I'd reinstall or repair ssms.

SQL Guy 1 (9/10/2014)

---

Hi all.

We have transactional replication. We have a index rebuilding job on publisher, but subscriber is still highly fragmented.

Should we create defragmentation job on subscriber, or...