have stored proc always return a blank record

Using sql server 2005

I have a stored proc that is a query and when there is no data return I still want the query to return an empty record with NULLs. whats an easy way to do this?

I've done this before using temp tables but wwondering about an easier way

thanks

Re: have stored proc always return a blank record

you can use like this in your store procedure if its only use to get the data

IF EXISTS (SELECT * FROM TableName WHERE COLUMN2 = @value1 AND COLUMN2 = @value2)
BEGIN
-- your query if the data exists in database
END
ELSE
SELECT NULL AS NoValue

Hope it will solve your issue

Re: have stored proc always return a blank record

IF EXISTS(SELECT * FROM MyTable WHERE Condition=true)
  SELECT * FROM MyTable WHERE Condition=true
ELSE
  SELECT NULL AS Column1, NULL AS Column2, NULL AS Column3, [etc...]

Re: have stored proc always return a blank record

TabAlleman

IF EXISTS(SELECT * FROM MyTable WHERE Condition=true)
  SELECT * FROM MyTable WHERE Condition=true
ELSE
  SELECT NULL AS Column1, NULL AS Column2, NULL AS Column3, [etc...]

very nice, I like it.

this works well assuming the initial exists query is fast, if its slow i guess you would have to weigh using a temp table vs using what you did above