LutzM (11/5/2011)

---

Ron, I don't think it's a running total scenario....

Have you looked at this article by Jeff Moden. It might give you enough info to solve your problem.

http://www.sqlservercentral.com/articles/T-SQL/68467/

Your welcome and thanks for letting me know ....

You cold use the COALESCE function for example:

DECLARE @v-2 VARCHAR(5)

SET @v-2 = NULL

--returns a blank ...

A good question, glad I had my first cup of morning coffee before attempting to answer. Rather surprised at the low percentage (34%) of correct answers. So congratulations...

May I suggest reading this article by Jeff Moden to determine if it can satisfy your requirement.

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Read this for a nice explanation.

http://sqlserverperformance.wordpress.com/2011/01/10/fun-with-extended-properties-in-sql-server-2008/

PhilM99 (11/1/2011)

---

There was a clue in your answer, Gail so I pursued it. So with respect, can I ask you to revisit your reply?

Here's what I did as an experiment:

Using...

Within your stored procedue use a TRY CATCH block of T-SQL code.

From Books On Line (BOL)

USE AdventureWorks;

GO

-- Verify that the stored procedure does not exist.

IF OBJECT_ID ('usp_GetErrorInfo', 'P') IS NOT...

Had to stir up some long dormant brain cells for this question.

It brings back the days when I was first introduced to relational databases and coding user interfaces...

And thank you for replying, after my taking so long to respond I was afraid that you might miss the post. Hope...

JonFox (10/27/2011)

---

@bitbucket I guess it depends on what Walton is actually trying to do. I was assuming that for his purposes 13 and 13.0 were equivalent; that very well may...

Now there is an idea .. have those beer popsicles...

Be careful with FLOOR for example:

DECLARE @Msg1 VARCHAR(20)

DECLARE @Type1 VARCHAR(10)

SET @Type1 = 'INT'

DECLARE @PARAM1 INT

SET @PARAM1 = 13

IF @Param1 = FLOOR(@Param1)

SET @Msg1 =...

Tom Brown (10/27/2011)

---

Hi All.

Its been a while since I've been active in "the thread".

Sorry to barge in throwing you off the important subjects of phone choice and how...