I finally have what i wanted, thanks Guys, here is the Code:

declare @ids varchar(8000),

@Station nvarchar(4),

@BeginDate datetime,

@EndDate datetime,

@BeginTime nvarchar(8),

@EndTime nvarchar(8),

@Scheduled int,

@Duration int,

@Program nvarchar(355),

@product nvarchar(6),

Thanks for your reply, You are right about the temp table having control, i used a right join and i started getting results, i'll work more on it and get...

Hi WanyeS, thanks for your reply, actually thats not what i want, if you check my post, what i want is to display also the date that does not meet...

I just don't know what is wrong, i actually created the temporary table, and tested it outside the query and it shows me that the temporary table actually contains data,...

Thanks for your reply, i'll work on it and get back to you. but how do u suggest my temp table look like.

Thanks

Timotech

Hi Guys, i'm back again on this topic, i need some help, i've tried everything i know.

From my previous posts, i have this code:

declare @AdDate datetime, @Station nvarchar(4), @BeginTime nvarchar(8),...

Thanks so much the link you provided gave a lot of insights, i'll work on it and let u know of any challenges.

Thanks

Timotech

Thanks Guys, you are all very correct, everything works very fine. Thannks

Hi all, please how can i ensure that i get accurate dates for example, if i enter '28 feb 2011' for @BeginDate, and i count one year back, i want...

Guys, thanks for your contributions, actually u're all right, but what i noticed is that when i use query designer, it brings that error, but declaring @BeginDate as datetime in...

All right guys i saw my mistake about the function, it actually works, but i did a mistake with this line:

@ids nvarchar(11),

its supposed to be something like this @ids...

Anyway guys, i solved the bigger problem again, remaining the smaller one, i.e how to adjust the function

This is my code:

ALTER PROCEDURE [dbo].[stp_GetReconciliationRadio_sel] (

@ids nvarchar(11),

@Station nvarchar(4),

@BeginTime nvarchar(8),

@EndTime...

Hi Guys, seems like that other issue is not a big problem, i have a bigger problem, how can i insert the result of the cte into a table called...

Hi Jeff, thanks for your reply, since then i've been doing a lot of experiments, i have a little challenge though.

I want to be able to pass in dynamic dates...

Hi Guys, I got it, this is the code i used, works ok

declare @BeginDate datetime, @EndDate datetime, @Station nvarchar(4), @BeginTime nvarchar(8), @EndTime nvarchar(8),

@Scheduled int, @Duration int, @Program nvarchar(Max)

set @BeginDate =...