You can also just use a grouping function in a derived table:

select sq.col1, t.col2, t.col3, t.col4, t.col5, t.col6, t.col7

from

(select MIN(col1) as col1

from #test

group by col2, col3, col4, col5, col6) sq

join...

Kind of sad though ... I'm personally familiar with a number of companies that pay $200/hr (at an avg of 5-10 hrs per week throughout the year) or more for...

Usually the Mets completely give up at the end of August or the beginning of September. It's nice to see them get a head start on things this year.

And...

diegocroitoru (8/2/2010)

Great response.

Do you mind elaborating more on the:

FOR XML PATH(''),TYPE

).value('.','VARCHAR(MAX)') , 1,1,SPACE(0)) AS Concat_Values

string of your...

This works well too ...

select STUFF(Column1, 1, 6, '') as ModifiedValue

from Table1

There is a File Watcher Task available from http://www.SQLIS.com. Some people have reported memory leaks with it but I'm not sure if that's true or not. Another alternative...

What is the big picture of what you're trying to accomplish? I have a feeling that FREETEXT is not what you're think it's for.

I'm curious what the application is....

declare @searchPhrase varchar(max) = 'hl=en&source=hp&aq=sql+server+central& aqi=&aql=&oq=&gs_rfai=CNJ23UTtUTNGEEYuEhQT8-rGmAQAAAKoEBU_Q7u6a'

declare @searchParam varchar(255) = '&q='

select case when CHARINDEX(@searchParam, @searchPhrase) <> 0

then SUBSTRING(@searchPhrase, CHARINDEX(@searchParam, @searchPhrase) + 3, CHARINDEX('&', @searchPhrase, CHARINDEX(@searchParam, @searchPhrase) + 3) - (CHARINDEX(@searchParam, @searchPhrase)...

This is the same issue discussed in your other thread. Storing multiple delimited values in a single column is absolutely horrible design and you'll end up with nothing but...

What would be better is to do the formatting of data at the presentation layer. There are times (such as when producing system specific flat files) that this is...

I don't want to pretend I have a complete knowledge of your table structure and your data and what you want to return, so I can't tell you exactly what...

A LEFT JOIN will include data from the tables left of the join and whatever data that matches up from the tables on the right side of the join. ...

tom 29037 (7/30/2010)

YES! That works. I'm reading BOL about Common Table Expressions. I've never used them before. What is the general purpose of a...

Although the absolute fastest performance is going to be what Scott said, it is possible to do it inline. (And this was worth doing anyway so you could use...