Of course that subquery returned more than 1 value. If can post some ddl, sample data and exactly what you are tying to do I will help.

I don't understand that...

Are you asking how to get a list of them or how best to display it in your application? If it is the first, you already have that knowledge from...

Hi Jim welcome to SSC. The question you pose is pretty vague but I can try to give my version of an answer on a few items.

jimw923 (4/8/2011)

Using SQL Server...

You have a couple choices to make this work. The case statement in a where clause the way you trying isn't going to work. If the proc is pretty small...

Yeah I was already formulating my response about a nice easy one for a friday especially after yesterday's challenging question and even more challenging discussion. Well the question really was...

You could also get the big query to do what you want by using the big case statement instead of the derived column name.

Another suggestion is to use your end date to calculate the Fin_Year instead of bring forced to change this every year

select

case

when MONTH(AIMTC_ProviderSpell_End_Date) > 4

then CAST(year(AIMTC_ProviderSpell_End_Date) - 1...

First thing is you might consider making your select statement a lot simpler

select a.id as a_id, a.datetime as a_datetime, b.id as b_id

from atest_detail b

left outer join atest_header a on...

Good question Wayne! Need more coffee after missing this one. 😛

There are lots of people on here willing to help but we need something to go on. We are not familiar with your project and we can't see you screen....

Try this post.

Then in the spirit of your name you can try this one :-D:-D:-D

File size of 300MB shouldn't be an issue with streaming. You can get 600MB into a file stream on a 32bit system in .NET. If you are properly disposing of...

I didn't even really read the create table statements. I saw the insert at the bottom with a StudentID, skimmed up and saw it referenced the students table and that...

Sounds you were not releasing the files correctly. If you streamed them and the properly disposed you should never have any issue reading a file just about any size.

If...

No matter how you slice and dice this you are going to have some challenges. You are essentially trying to get a partially sorted result and this just simple isn't...