anytime!

I just saw your other post....there was someone yesterday who seemed to have a novel approach to storing all the db object create scripts in a stored procedure and then...

why can it update only one row ?! what is your update based on ?! could you pl. provide some more details ?!

Nisha - you can use enterprise manager and the scripting wizard to script the text either into individual files or all stored procedures in one big file and then print...

here goes...

CREATE PROCEDURE ProcTestPrint

AS

SET NOCOUNT ON

IF EXISTS(SELECT * FROM Products WHERE ProductName = 'A')

BEGIN

PRINT 'Title of the report = ProductName'

PRINT ' A'

SELECT ProductName, amount_SUM

FROM Products

WHERE ProductName = 'A'

END

IF EXISTS(SELECT *...

Oops - guess I'm guilty as charged then! I just posted a stored procedure that set the nocount off at the end...

ps: In my...

so you have to check the existence of both product names (a & b) before you print them ?!

just out of curiosity....may I ask why you need to do this...

midan - you would just have to use what sara gave you and put it in a stored procedure - almost verbatim...the nocount has been set so that you don't...

Mike - I'm an English major in THIS Life!

You find either waldo or carmen sandiego Mike - & you've found me!

ps: There - now I've practically given it away!

Hey morbid Mike...

"Death, be not proud, though some have called thee

Mighty and dreadful, for thou art not so....."

here're some detailed accounts (unearthed from googling) of identical user griefs:

1) If you let DTS create the table in excel, then apparently it converts a numeric

field into varchar - in...

shashank - you can open up the procedure in your "master" database and look at the code!

Use enterprise manager!

declare @Share int

declare @Share1 int

declare @Share2 int

declare @Pool int

declare @Amount int

SET @Share = @Share1 + @Share2

IF (@Share > 0)

SET @Amount = @Pool / @Share

ELSE

SET @Share = 0 ...don't...

I think there're very few who haven't seen days like these....a mantra I learnt a long time ago (which doesn't even sound like words of comfort at first read being...