is a little more detailed explanation what I was thinking of when...

I don't really understand what you're looking for...

Assuming you don't have duplicate values in col [si], you should get "1" for count(min) and "1" for count(max), once the syntax is...

Thanx for the sample data.

What would be your expected result?

To me it's not clear what would be the criteria for building the group of three weeks: Does it start Jan. 1st or starting from this week backward?

Anyhow, I would...

The following might help you:

DECLARE @AgentQueue TABLE ( customerId VARCHAR(15) NOT NULL,QueueXML XML NOT NULL )

INSERT INTO @AgentQueue

SELECT '1', '

'

SELECT

t.c.value...

Hi,

following please find a solution based on Jeff Moden's article[/url]

IMPORTANT NOTE: As per my understanding this code will only work if the order of the columns to be ranked is...

I just voted for MCA (since there is just one vote for this group so far it doesn't make the poll an anonymous one anymore). 😛

Reason:

The question is "Who is...

You're welcome.

(Even though I didn't add any information that I came up with. So, all the flowers belong to Jeff 🙂 )

To add CLR to SQL Server you need to have SS2005 and up.

If you have the option to go for SS2005 I strongly recommend to decide it BEFORE you start...

The data as provided in the original post is in html format rather than xml type.

The xml type gives you a data structure whereas html usually includes format information as...

SET Humor ON

A query using "like 'ep_f_%'" shouldn't return any row starting with 'AP_'... 🙂

SET Humor OFF

Hi,

you could either use (dynamic) Cross Tabs or the PIVOT function.

Dynamic cross tabs are used if you don't have a fixed number of target columns.

Please read the following two articles...

I just looked up the error on MSDN, but the recommendation doesn't really help ("Remove the remote table column of DBTYPE_DATE data type from the query select list or predicate...

Well, I just used "strip html" as search criteria on this forums search box. So, no big deal. 😉

Sometimes it's just a matter of finding/knowing the right search string to...

Please provide sample data as described in the link in my signature. The table defs are a first step, but the table should have some data, too.

Also, it would be...