Thanks in advance for your help.

StmtText        

----------------

Set NoExec on

(1 row(s) affected)

StmtText                                                                                                                                                                                                                                                                                

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SELECT pi.PropertyAddressState AS STATE, 

  p.POPCY,

  p.POPDIF90CY,

  p.ZIP,

  p.ZIPNAME AS CITY

FROM  ReplyREI.dbo.Reply_PropertyInformation As pi

RIGHT...

I returns millions of rows. I have another proc that narrows down the server further, but I wasn't sure about the join..

I've added the union all and just wanted to make sure I had the syntax right for the select

    AND tlq.time_frame_id IN (select val from @args)

Thanks for your help!!

alter  ...

4 TB for everything including backups.

Our total data is about 150 gig to date, but I want to make sure I have enough space every where..

I read some articles...