Viewing 15 posts - 886 through 900 (of 3,221 total)
LutzM (11/5/2011)
bitbucket-25253 (11/5/2011)
Have you looked at this article by Jeff Moden. It might give you enough info to solve your problem.
Ron, I don't think it's a running total scenario....
November 5, 2011 at 10:11 am
Have you looked at this article by Jeff Moden. It might give you enough info to solve your problem.
November 5, 2011 at 7:23 am
sthenmozhi14 (11/5/2011)
Hi bitbucket,Thanks a lot... its working...
🙂
Your welcome and thanks for letting me know ....
November 5, 2011 at 7:09 am
You cold use the COALESCE function for example:
DECLARE @v-2 VARCHAR(5)
SET @v-2 = NULL
--returns a blank ...
November 5, 2011 at 6:41 am
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...
November 4, 2011 at 6:36 am
May I suggest reading this article by Jeff Moden to determine if it can satisfy your requirement.
November 1, 2011 at 10:03 pm
PhilM99 (11/1/2011)
Thanks, will do that in the stored procs and views... how to do that in tables?
Read this for a nice explanation.
November 1, 2011 at 9:23 pm
PhilM99 (11/1/2011)
Here's what I did as an experiment:
Using...
November 1, 2011 at 8:57 pm
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...
October 30, 2011 at 6:29 am
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...
October 29, 2011 at 1:26 pm
ericwenger1 (10/27/2011)
Thanks for all of your hard work
And thank you for replying, after my taking so long to respond I was afraid that you might miss the post. Hope...
October 28, 2011 at 5:31 am
JonFox (10/27/2011)
October 27, 2011 at 2:59 pm
Evil Kraig F
Awesome piece of code used, abused, re-abused, then rebuilt from the ground up with beer popsicles and dust bunnies
Now there is an idea .. have those beer popsicles...
October 27, 2011 at 2:47 pm
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 =...
October 27, 2011 at 2:26 pm
Tom Brown (10/27/2011)
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...
October 27, 2011 at 12:52 pm
Viewing 15 posts - 886 through 900 (of 3,221 total)