Database

john john mackey wrote:

What seems to be failing is the .Find (the INSERT INTO didn't refresh the table???)

to_char(audit_event_date, 'HH24:MI:SS') between '18:29:59'
      and '19:00:00'

select 'grant execute on ' + name + ' to username' from sysobjects where xtype = 'P'
order by name

CREATE TABLE #foo (<br />
	foo_id TINYINT )<br />
	<br />
INSERT INTO [#foo] VALUES (1) <br />
INSERT INTO [#foo] VALUES (1) <br />
INSERT INTO [#foo] VALUES (1) <br />
INSERT INTO [#foo] VALUES (1) <br />
INSERT INTO [#foo] VALUES (2) <br />
INSERT INTO [#foo] VALUES (2) <br />
INSERT INTO [#foo] VALUES (2) <br />
INSERT INTO [#foo] VALUES (2) <br />
<br />
SELECT<br />
	COUNT(*)<br />
FROM<br />
	[#foo]<br />
	<br />
SELECT<br />
	COUNT(DISTINCT [#foo].[foo_id])<br />
FROM<br />
	[#foo]<br />
	<br />
DROP TABLE [#foo]

SELECT<br />
	A.PROPERTY_KEY - B.[UNITS IN PRO-V]<br />
FROM<br />
	(SELECT<br />
		COUNT(DISTINCT PROPERTY_KEY) PROPERTY_KEY<br />
	FROM<br />
		sde.VW_Toi_Deeds_Vuyiswa<br />
	WHERE<br />
		FUNCTION_KEY like '%GEOSS%') A,<br />
	(SELECT<br />
		COUNT(*) AS [UNITS IN PRO-V]<br />
	FROM<br />
		SDE.PROPERTY<br />
	WHERE<br />
		FUNC_KEY LIKE 'GEOSS%') B

SELECT
A.PROPERTY_KEY - B.[UNITS IN PRO-V]
FROM
(SELECT
COUNT(DISTINCT PROPERTY_KEY) PROPERTY_KEY
FROM
sde.VW_Toi_Deeds_Vuyiswa
WHERE
FUNCTION_KEY like '%GEOSS%') A,
(SELECT
COUNT(*) AS [UNITS IN PRO-V]
FROM
SDE.PROPERTY
WHERE
FUNC_KEY LIKE 'GEOSS%') B