Database

Vuyiswa wrote:

Update sde.Property_Backup p3
set p3.Attrib_code = p12.Attrib_code

<br />
if Exists(select * from sde.Property_Backup p1<br />
where substring(p1.func_key,1,5)='GEOSS' <br />
aND Exists (select p2.Property_ID,p2.Lis_key,p2.Func_key,<br />
p2.Attrib_code<br />
from sde.Property_Backup p2<br />
where p2.func_key = 'PV000000'<br />
And p1.lis_key = p2.lis_key<br />
And P2.aCTIVE =1))<br />
begin<br />
<br />
Update p2<br />
set p2.Attrib_code = p1.Attrib_code<br />
where p2.lis_key = p1.lis_key<br />
and substring(p2.func_key,1,5)='GEOSS' <br />
And P1.aCTIVE =1<br />
end<br />
<br />
<br />
and It gives me an Error <br />
<br />

Msg 208, Level 16, State 1, Line 10
Invalid object name 'p2'.
/pre>.

<br />
UPDATE p2 SET p2.Attrib_code = p1.Attrib_code <br />
INNER JOIN p1 ON p1.lis_key = p2.lis_key<br />
WHERE Substring(p2.func_key,1,5) = 'GEOSS' AND P1.active = 1

<br />
DECLARE		@CUR_LIS_KEY VARCHAR(20),<br />
			@CUR_ATTRIB_CODE VARCHAR(12)<br />
<br />
DECLARE PARENT_CURSOR CURSOR FOR<br />
	SELECT	 LIS_KEY, ATTRIB_CODE<br />
	FROM	SDE.PROPERTY_Summary P1<br />
	WHERE	EXISTS(SELECT 1 <br />
					FROM SDE.PROPERTY_Summary P2 <br />
					WHERE P2.FUNC_KEY LIKE 'GEOSS%' AND<br />
							P2.LIS_KEY = P1.LIS_KEY And p2.Attrib_code is Null<br />
													And p2.Archive_Date is Null <br />
                             <br />
)		<br />
<br />
OPEN PARENT_CURSOR<br />
	FETCH	NEXT FROM PARENT_CURSOR<br />
	INTO	@CUR_LIS_KEY, @CUR_ATTRIB_CODE<br />
<br />
WHILE @@FETCH_STATUS = 0<br />
BEGIN<br />
	UPDATE	SDE.PROPERTY_Summary<br />
	SET		ATTRIB_CODE = @CUR_ATTRIB_CODE<br />
	WHERE	FUNC_KEY LIKE 'GEOSS%' AND<br />
			LIS_KEY = @CUR_LIS_KEY<br />
	<br />
	FETCH	NEXT FROM PARENT_CURSOR<br />
	INTO	@CUR_LIS_KEY, @CUR_ATTRIB_CODE<br />
END<br />
<br />
DEALLOCATE PARENT_CURSOR<br />
<br />
<br />
<br />

declare @start datetime, @end datetime, @month varchar(10)<br />
<br />
set @month = 'feb'<br />
<br />
select @start = convert(datetime, '01-Apr-' + convert(varchar,datepart(year,dateadd(year,-1,getdate()))))<br />
select @start<br />
<br />
select @end = convert(datetime,dateadd(day,-1,dateadd(year,1,convert(datetime, '01-' + @month + convert(varchar,datepart(year,dateadd(year,-1,getdate())))))))<br />
select @end