Why are you creating constants when you can just use the date functions in the where clause?



SELECT sum(Salesamount)
FROM Table
WHERE salesdate BETWEEN ...

Just replace where I had @userInput with getdate() function


SELECT sum(Salesamount)FROM TableWHERE YEAR(salesdate) = YEAR(getdate())


You can do the same with the date functions example.

There are alot of ways to do this here are a couple examples.

Using Year() function

Select sum(Salesamount)
From Table
where Year(salesdate) = Year(@userInput)

You can't use the alias in the boolean test plus you should use a having clause to test the count(*) and not the where clause.


Select title, count(*) As Cnt
From poss_titles
Group By title...

I beleive you need to use a full outer join with a coelesce on the 3 keys to get your desired result.


SELECT coalesce(a.Recordingid,b.recordingid), coalesce(a.Connection,b.Connection),...

Did you try using wild cards.


Select * from Table1
Where Name LIKE ('%' + @Name + '%')

Have you tried joining the subquery in the from clause instead of using the inline view.

You should use code blocks as it makes it alot easier to read.



[/code}

Did you try an inline view? something like this maybe

[code=sql]
select

I actually remember reading both of these threads and had commented on one of them but I still did not correlate them.

@sknake - thanks, I didn't realize there were multiple threads relating to this db.

I don't see where you are getting the alias 'c'

Besides that i think you are making it more difficult then it has to be.



select *
from dbo.tblLevelOneApprover a,...

Link82

Group by does exactly that; groups your result set by the fields provided, in the example provided by sknake.


GROUP BY tblManagers.managerID, tblManagers.managerLastName,...

I can't see any easy way to parse this string in a single select statement. I would try each individual piece at a time and then once you can parse each piece put them back together.

You might...

You should be able to create a stored procedure and try to break off a piece at a time.

If you don't need the data live maybe you can make a dts package to run daily to parse these strings and...

I have question.

How were these records imported into the table in the first place?

It would have been easier to parse them correctly when they were initially loaded.