Hi,

Im new to SQL Server. I'm trying to execute the following query

create view v_IB_IssueView1 (CreatedMonth, StatusSubmitted, StatusOpen, StatusPending)
as select CreatedMonth, sum(case CorporateStatus when 'submitted' then 1 else 0 end),
sum(case CorporateStatus when 'open' then 1 else 0 end),
sum(case CorporateStatus when 'pending' then 1 else 0 end)
from tbl_IB_Issue_new1
group by CreatedMonth

and I'm getting an error that says:
Server: Msg 208, Level 16, State 1, Procedure v_IB_IssueView1, Line 2
Invalid object name 'tbl_IB_Issue_new1'.

Here tbl_IB_Issue_new1 is a table

Now I dont know where i'm goofing up ..can someone pls help me out with it.... plssssssssssssss

Thanks,
Shruti Majithia
Quinnox Consultancy Services