Hi guys, what i'm i doing wrong its telling me invalid object name dbo.tbl_Radio

This is my code:

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

@Scheduled int, @Duration int,...

Thank you all Very Much.

Thanks man, 🙂

Perfect. Cold Coffee, you're the man, thanks so much for your help. Thanks Jeff also for your help, please how can i get an article or something that explains this...

Thanks so much Cold Coffee, sorry that my disturbance is too much, the '>' actually worked when i tested with one single date, i.e making @BeginDate and @EndDate the same....

Hi Jeff, Thanks, Actually i meant to say i'm also working on it, and expecting what u will also come out with. Thanks so much Cold Coffee, I tried your...

Thanks Jeff, I'll be expecting.

Thanks Guys, I ran this query and it worked very fine:

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

@Scheduled int, @Duration int

set @BeginDate = '2 jun 2010'

set @EndDate...

Thanks Guys, I'm working on it.

Ok, this is some sample data:

CREATE TABLE [dbo].[tbl_Radio](

[AdDate] [datetime] NULL,

[AdTime] [nvarchar](8) NULL CONSTRAINT [DF_tbl_Radio_1_Upper_Time] DEFAULT (N'19000101 00:00:00'),

[Duration] [float] NULL,

[FK_BrandId] [nvarchar](4) NULL,

[FK_BrandADId] [nvarchar](2) NULL,

[FK_StationId] [nvarchar](5) NULL,

[FK_ProductId] [nvarchar](6) NULL

)

Insert into tbl_Radio(AdDate,...

I tried something like this:

SELECT AdDate, COUNT(Duration) AS [Number Of Spots], @Scheduled AS ScheduledSpots, @BeginTime + '-' + @EndTime AS ScheduledTime,

(Select AdTime as "CapturedTime()" from...

Thanks so much, i already googled it, and i'll get back to you on my findings

Timotech

Thanks for your reply, how do i use the FOR PATH XML?

Thanks

Hi guys, thanks for all your help, i met this guy called Nate, who provided a solution to the problem.

CREATE TABLE #tbl_radio (

AdDate CHAR(12)

, AdTime CHAR(8)

, fk_StationId CHAR(4)

, Duration TINYINT

)

INSERT...

Thanks so much Nate, sorry i'm replying so late, thanks for your solution, it really did the trick. You're blessed.

Thanks

I'll try some experiments on it, and i'll get back to...