Here's a demo using Northwind...

CREATE PROCEDURE DemoForErik
@CategoryID Int = 100,  -- default values
@CategoryName VarChar(50) = 'Erik Little'
AS

IF EXISTS(SELECT * FROM Northwind.dbo.Categories...

Since everything else in the results you want is a constant but for the year, why not just good old concatenation...?!?!

select 'Jan 1, '...

Still not sure if I've understood correctly, but if I have...why don't you just set defaults for your orderID, shipAddress etc...check @@rowcount - if equal to 0, then send select...

I could swear I've seen an (almost) identical post to this one but can't seem to find it now...my search however threw up the following 2 links that may help...

btw...why're...

Erik - what's your question..?!?!

Miguel - it's not at all clear (at least to me) what exactly you hope to accomplish..

It seems that you want to dynamically create...

Adrian - have you thought of converting this to an article (or two) & sending it to Steve - I'm sure a lot of us would be interested in something...

I'm (sorta) repeating what I said in the other (Walmart) post...nobody's being held hostage - no one's holding guns to our heads - we're all free to browse and read...

Arun - I don't understand what "site collection" means...if you're talking about a list of databases and their sizes, you could do exec sp_databases to get your results..else someone who...

This is in response - not to Steve's post - but to all those who cannot figure out why this topic featured in "Editorials" at all...

Other than "Anything that is...

Miguel - you could also do something like this w/out a cursor ...

Northwind database...

declare @strViewText varchar(8000)
select @strViewText = text from syscomments
where id = object_id('dbo.Invoices')
print @strViewText

Or you could use "Upper" & "Lower"...something like this...

SELECT REPLACE(UPPER('a'), 'A', LOWER('A')) AS UpperTOLower

SELECT REPLACE(LOWER('A'), 'a', UPPER('A')) AS LowerTOUpper
UpperTOLower          ...

Mike Metcalf/Doubting Thomas.....Beat me now or forever hold your peace....I'm now #2 on the list....& just to silence you I started all over again as "sushila"...Phew - exhausting work this...

'kay Mike - think I'll quit while ahead - I made it to #8 on the list....YAAAAAAAAY

yeah, yeah - it's all very well to say bounce him off the steeple and the dish but HOW...?!?!?! - Santa's either been scraping his butt off in a straight...