Viewing 8 posts - 1 through 8 (of 8 total)
How do I pass @UNC to another query?
use @UNC
set nocount on
SELECT CAST((ISNULL(SUM(CAST(hsi.itemdatapage.filesize AS Numeric(15,4))),0)/1024/1024/1024) AS NUMERIC(15,6)) as Storage
FROM hsi.itemdata, hsi.itemdatapage, hsi.doctype
WHERE hsi.itemdata.itemnum = hsi.itemdatapage.itemnum
AND hsi.doctype.itemtypenum = hsi.itemdata.itemtypenum
--AND hsi.doctype.itemtypenum > 100...
August 29, 2011 at 2:10 pm
Sorry, new to switching back and forth. I kind of own this bit since the other guy quit. It looks great. I knew there was a char function that could...
August 29, 2011 at 1:18 pm
That looks great, but will in work in a VBScript?
August 29, 2011 at 1:10 pm
Yep that worked, thanks. Hmm, less than one...learn something new every day...
August 26, 2011 at 2:11 pm
Here's what it says. The first query ran fine, the sencond I ran against one of my local dbs and it gave me an error
INSERT INTO GrowthofDBEXEC sp_track_db_growth
Msg 102, Level...
August 26, 2011 at 8:59 am
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'sp_track_db_growth'.
Thats all that gives me...
August 26, 2011 at 7:36 am
How do I put the results of a sp in a table?
August 25, 2011 at 3:16 pm
Viewing 8 posts - 1 through 8 (of 8 total)