Search results for query: *

Hi Guys, I have a simple store procedure which looks a bit like this: @ProductCodes as varchar(25) Select * from Market_Promotions where Booths_ID in (@ProductCodes) When I try to execute this and pass in a number of values I get an error message. Can you please give me some guidance...

Hi George Thanks for your quick response. i am using two queries, and they are very similar about from these to lines: po_code <> '0000 mb_deal_number <> '0000' The sub queries (select pd_main_group_code from Product_Dim where pd_key = '665777' Group by pd_main_group_code) do return a signal...

Hi Guys, I was wondering if i could get a helping hand in optimizing this query. I know its not perfectly formed and would really appreciate your expert guidance. Select ISNull(a.pd_main_group_code_desc,b.pd_main_group_code_desc), a.pd_super_group_desc...

Thanks, Ok forgot to mention i have other months in there to. and only want every aggregated up to a certain point of the month So Date Channel Actual 1/01/11 3 4545 1/01/11 1 666 1/01/11 6 5456 2/01/11 1 1511 2/01/11 1 4888...

Hi guys I have a data table which looks something like this: Date Channel Actual 1 3 4545 1 1 666 1 6 5456 2 1 1511 2 1 4888 3 1 1545 4 1 643 4 2...

Thanks Guys, you've all been a great help. Im still having a few problems getting it to work with my example but im sure ill work it out. Thanks again

Thanks Simi, Thant looks very interestin... Qik3coder, thanks also for your resoinse. Please see below for sameple data, this is how it has been presented to me... Year crs_code school sub % 2011 KT101 ML French 30% 2011 KT101...

Thanks for your response Simi, It needs to be in a table if at all possible. I have over 1600 records of which each crs_code can occur more than once. this is due to the fact a crs_code can have muliple subjects each with a different %'s.

Cause unfortunately SQL is the only language i know a bit about.... If you could head me in the right direction i would be very greatful Dave

Sorry this is how the data has been supplied to me from an external party. I've given the task to try and pivot it so i only have one record for each crs_code.

Hi r937, Thanks for you response, I agree it should. However on this occasion i don’t have the luxury to going back to the application owner and asking for this. Do you know how i might go about pivoting this data?

Hi Guys Im pretty new to sql and was wondering if one of you could help me out. I have a dataset which looks a bit like this: Year crs_code school sub % 2011 KT101 ML French 30% 2011 KT101 Law Law 50%...