Viewing 8 posts - 46 through 53 (of 53 total)
Hi Gail,
My query is below. I've commented the field that I had to add to get the query to work. I'm only a sql novice so the code is...
June 23, 2009 at 2:27 am
select'Thanks Gail' union all
select'Most appreciated' union all
------------------------------
select'Regards.....Jason'
June 23, 2009 at 2:11 am
Hi Eli,
The query includes a calculated field that contains a correlated subquery which itself has 3 WHERE conditions. I can only get the query to work if i include all...
June 23, 2009 at 1:32 am
That's great...I really appreciate your help. Works a treat.
I realised half of the problem was the non-normalized table structure, but that's our IT team's responsibility - I'm just one...
June 11, 2009 at 5:20 am
Sorry if I wasn't clear.
The Range and Yearofvalue fields should be self-explanatory.
The other fields present prices for January, March, August & September (baseprice1, baseprice3, baseprice8, baseprice9).
What I'm trying to find...
June 11, 2009 at 4:56 am
Oops...forgot to say, I'm using SQLServer 2000.
Thanks,
Jason
___
June 11, 2009 at 4:19 am
That's the one. And would you believe probably the only combination I didn't try before posting.
Thanks again,
Jay
June 3, 2009 at 4:09 am
For a good beginner's guide you can't do much better (IMHO) than:
"SQL Queries for Mere Mortal" by Viescas Hernandez,
Jason
___
January 9, 2009 at 9:18 am
Viewing 8 posts - 46 through 53 (of 53 total)