Welcome to Sign in | Help

problema ciudata de Sql

  •  01-08-2009, 2:36 PM

    problema ciudata de Sql

    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
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems