Steve - thanks for the reply.  I actually have the SQL to render the DATEs (see samples below)  What I need to know is how to render these in the...

--FIRST DAY of CURRENT MONTH

select DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)

--FIRST Day of the Year

select DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)

--FIRST Day of the Quarter

select DATEADD(qq, DATEDIFF(qq,0,getdate()), 0)

--LAST Day of Prior Month

select dateadd(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate()  ), 0))

--LAST...

PAD - thanks.. it worked!

Carl ~ thanks.  Your solution worked PERFECTLY!!!

-bt

You all have been more than helpful.  Question ~ when you mentioned 'Dont Forget 'IF' and 'TF' --- should I simply modify

((a.xtype='P' or a.xtype='U' or a.xtype='FN' or a.xtype='V')

to look...

Thanks for the responses.  Your replies helped me perform the following:

On Ent Mgr, I select PROPERTIES for the registered server name, then I selected the SERVER Properties tab and Checked the "allow...

well, the .Net developer replied that he is going to TRIM the column.

Works for me.  (thx folks!)

GOVIN - the schema and sample data are listed as the first entry (at top of this page)

I wound up using CURSOR processing to accomplish this:

--Declare/Open/Fetch/Close/Deallocate CURSOR sample

declare @OrderID int, @ResetID1 int, @ResetID2 int, @OrderItemID int

declare OrderItemTaxCursor cursor for

 select OrderItemID from...

Yes, I need all Persons w/ OR w/out an Application

Likewise, all Persons w/ OR w/out a Certification row 

thanks!  that worked great

I should have clarified a little further…

I need to do something like this, I think…

SELECT...

thx all. Problem resolved!

THANKS Phil!   I followed your recommended thread, found a pre-written proc, implemented it across a half-a-dozen jobs as the 1st step, and all is working great.

Much appreciated.

Bill

Yelena - it worked for me.  (w/ the dozens of GO statements embedded throughout the script)  I too was surprised that it completed successfully.