Am urmatoarea procedura sticata
LTER
PROCEDURE [dbo].[BuildeXPOArchive]
@anul
as int
AS
BEGIN
SET NOCOUNT ON;
DECLARE @MonthTable TABLE(nrluna INT,numeluna Varchar(3),Link varchar(300))
INSERT
INTO @MonthTable values(1,'IAN','')
INSERT
INTO @MonthTable values(2,'FEB','')
INSERT
INTO @MonthTable values(3,'MAR','')
INSERT
INTO @MonthTable values(4,'APR','')
INSERT
INTO @MonthTable values(5,'MAI','')
INSERT
INTO @MonthTable values(6,'IUN','')
INSERT
INTO @MonthTable values(7,'IUL','')
INSERT
INTO @MonthTable values(8,'AUG','')
INSERT
INTO @MonthTable values(9,'SEP','')
INSERT
INTO @MonthTable values(10,'OCT','')
INSERT
INTO @MonthTable values(11,'NOV','')
INSERT
INTO @MonthTable values(12,'DEC','')
select
distinct YEAR(startdate)as anul into #ctean from Exhibition where [Deleted]=0
select
* into #temp from @MonthTable
cross
join #ctean;
with
ctefinal as
(
select
nrluna,numeluna,a.anul,b.link from #temp as a
left
outer join
(
SELECT YEAR(startdate)as anul,MONTH(startdate)as luna,+'www.addcompany.ro/arhiva/EXPOZITII/'+cast(year(startdate)as varchar(4))+'/'+case MONTH(startdate) when 1 then 'ianuarie'
when
2 then 'februarie'
when
3 then 'martie'
when
4 then 'aprilie'
when
5 then 'mai'
when
6 then 'iunie'
when
7 then 'iulie'
when
8 then 'august'
when
9 then 'septembrie'
when
10 then 'octombrie'
when
11 then 'noiembrie'
when
12 then 'decembrie'
end
+'.html' as link FROM Exhibition as a group by YEAR(startdate),MONTH(startdate)) as b
on
a.nrluna=b.luna and a.anul=b.anul
where
[Deleted]=0
)
select
nrluna,numeluna,anul ,isnull(link,'http://') as link from ctefinal where anul=@anul
END
problema e la Linia asta :
select distinct YEAR(startdate)as anul into #ctean from Exhibition where [Deleted]=0.
Cand rulez imi zice :
Msg 207, Level 16, State 1, Procedure BuildeXPOArchive, Line 29
Invalid column name 'Deleted'.
procedura se compileaza iar interogarea merge din comand line nu am reusit sa gasesc explicatia.Folosesc sql server express
poate aveti idee de ce se intampla
Va multumesc
Secolul XXI ori va fi religios ori nu va fi deloc