Lowell (8/2/2013)

---

I just noticed every one of us skipped over a basic group by as an alternative, and went straight to row_number.

this is probably the simplest:

SELECT

name,

...

As Fall approaches, and with it cooler temperatures, I plan to cut back into my sawdust therapy. I spend many evenings and weekends in shop. It is very soothing and...

Why do you want triggers for this? What objects would you put the triggers on? If you want to restrict access by user the...

You're welcome. Glad that will work for you.

What do you mean by restrict the access?

Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1480403-392-1.aspx

Something this is probably what you are looking for.

select Identifier, Race, PrimaryLanguage, PreferredLanguage, MAX(Ethnicity) as Ethnicity, MAX(Ethnicity2) as Ethnicity2, MAX(Ethnicity3) as Ethnicity3

from TEST

--where identifier = 100276

group by Identifier, Race, PrimaryLanguage,...

Jeff Moden (8/1/2013)

---

That's got some serious errors in it. Although it happens frequently, no result set is guaranteed to be in the...

harsimranjeetsinghwasson (8/2/2013)

---

Hi,

Is there any catalog view for finding reference objects in other database or same but is written in dynamic query in view/store procedure/function.

I found some like syscomments,sys.all_sql_modules,sys.sql_modules but is...

Thanks for posting ddl and sample data. You posted a query which seems to have nothing to do with the sample table you posted? Also the table you posted doesn't...

Donnie Carvajal (8/1/2013)

---

I checked the execution plan on the production server as well and I am seeing close to the same values for this query.

The full database statistics updates have...

Here are two examples of how you could do that.

--method #1

with MyAddresses as

(

select a.name, b.address, ROW_NUMBER() over (partition by a.name order by (select null)) as RowNum

from a left outer join...

ScottPletcher (8/1/2013)

---

Luis Cazares (8/1/2013)

---

You could find this article useful

http://www.sqlservercentral.com/articles/T-SQL/88244/

SELECT AttribID

FROM MyTable

WHERE FormatID IN (12,15)

GROUP BY AttribID

HAVING COUNT(DISTINCT FormatID ) = 2

EXCEPT

...

riya_dave (8/1/2013)

---

but i need loop or condtion hwo to do it

example if primarycondition = 'HF'

then update table a

set secondary condtion = null

if there is no primary condition = 'HF'

then

if primarycondition...

DISTINCT?

GROUP BY?

It is kind of hard to say without more details about what your actual query looks like.