Here is entry from BOL: http://msdn.microsoft.com/en-us/library/ms186734.aspx

You will have to group by ALL columns not part of an aggregate. You did not include text_type_name in your group by.

Try this.

GROUP BY sam_typ_tst_typ.SAMPLE_TYPE_NUM, sample_type_name, method_name, method_descr_text, test_type_name

realvilla (6/20/2013)

---

I'm trying not to bother you any more but you did ask me to give you a progress update. I am stumped. I have working on this...

Here is a simple example to demonstrate.

create table #Left

(

LeftID int identity,

MyValue varchar(10)

)

create table #Right

(

RightID int identity,

MyValue varchar(10)

)

insert #Left

select 'no match' union all

select 'has match'

insert #Right

select 'has match' union all

select 'has...

venkyzrocks (6/20/2013)

---

HI Guys,

Please review the code below and I have pasted the DDL for it. The left outer returns more rows than the that in the left row itself and...

jhager (6/20/2013)

---

Hi,

A developer created several tables with PKs but no FKs. I used the Database Diagram feature to "map out" where the FKs should be, but when I saved the...

Try this:

AND isnull(table.DischargeDate, dateadd(day, 1, getdate()) >= @enddate

Keep in mind that if the value of @enddate is greater than the current date plus 1 this will still evaluate to false.

With...

ali.m.habib (6/20/2013)

---

Sean Lange (6/20/2013)

---

ali.m.habib (6/20/2013)

---

Sean Lange (6/20/2013)

---

ali.m.habib (6/20/2013)

---

I have stored prcuder like

create proc calcaulateavaerage

@studentid int

as

begin

-- some complecated business and query

return @result -- single decimale value value

end

and then...

Gotta love those ugly things. Glad...

You're welcome sqlme. 😀

Again my apologies for not reading the whole issue previously.

DKG-967908 (6/20/2013)

---

Hi Everyone,

Is it possible to stop SQL Injection Attack at SQL server level?

I have gone through some posts and articles that suggest all the checks at application level so...

ali.m.habib (6/20/2013)

---

Sean Lange (6/20/2013)

---

ali.m.habib (6/20/2013)

---

I have stored prcuder like

create proc calcaulateavaerage

@studentid int

as

begin

-- some complecated business and query

return @result -- single decimale value value

end

and then I want to...

257 columns and a select *??? Unless this is a DW that...

ali.m.habib (6/20/2013)

---

I have stored prcuder like

create proc calcaulateavaerage

@studentid int

as

begin

-- some complecated business and query

return @result -- single decimale value value

end

and then I want to

create proc the...

Glad you found a solution.