I assume by your silence that you did in fact get your issue resolved. It is somewhat customary...

Group by would likely get you what you are looking for.

so what is this query doing?

Select *

From LLA_Audits t12

Join LLA_Audits t13

ON t12.AgencyID = t13.AgencyID

Where t12.AgencyID = t1.AgencyID

And year(t12.ReportDueDate) = year(t1.ReportDueDAte)...

pgmr1998 (5/15/2012)

---

Here is my code, but i get an error that says:

Server: Msg 156, Level 15, State 1, Line 13

Incorrect syntax near the keyword 'FROM'.

SELECT AgencyId, AgencyName, AgencyType,

...

SQLKnowItAll (5/15/2012)

---

Hehehe... Because nobody learns them or cares to. I'll tell you a question I have never been asked at an interview... "Are you familiar...

???

Select AgencyID, AgencyName,AgencyType, Count(docs)

from Agencies

where isOpenAllegation= 1 and WorkType = 'Agreed-upon Procedures'

group by AgencyID, AgencyName, AgencyType

???

From your brief description is appears that your data is not normalized. You should...

Can you try to more clearly explain what you are looking for?

CELKO (5/15/2012)

---

Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. If you know how,...

rabisco (5/15/2012)

---

Sean Lange (5/15/2012)

---

CLR is a way of executing a stored proc whose code is actually .NET code. This type of string manipulation is tricky and probably a bit easier...

CLR is a way of executing a stored proc whose code is actually .NET code. This type of string manipulation is tricky and probably a bit easier to code in...

There are lots of ways you can sort data in .NET. It really depends on what you are doing.

http://msdn.microsoft.com/en-us/library/13wb36xf.aspx

Something like this?

select name, Gender

from

(

select name, Gender, ROW_NUMBER() over (order by name) as RowNum

from #tmp

where Gender = 'M'

union all

select name, Gender, ROW_NUMBER() over (order by name) as RowNum

from #tmp

where...

That would be another way. 😀 Nicely done!!!

Are you 100% certain that the column that is throwing this error is the one you changed to varchar(max)? Is it possible that there are more characters than a field...

bighow2008 (5/15/2012)

---

Hi all,

I'm trying to update a table using a subquery. when I run the below script I get an error Msg 512. I have done updates like this in...

Steve Jones - SSC Editor (5/15/2012)

---

How often do we see on this site decisions made by people who work as DBAs that are awful? These people are often trained for...