sorry, couldn't go through the whole code ..it's too big for a quick look;

1)was this initially taking less time = If data is less , report generating...

OOOPs I Found the solution....

http://mangalpardeshi.blogspot.com/2009/06/multiplying-column-values.html

Thanks

Now SQL server Management studio opened. But here cant find server name.(no server - local)

Pls help

after those warnings i continually installed. Then Components selection window ONLY workstation components ... check box enabled.. Others are disabled

Others are

1)SQLServer DB services

2)Analysis services

3)Reporting Services

4)Notification services

5)Integration Services

need advice

i got below warning msg while im installing

1) SQL Server Edition Operating System Compatibility

2)IIS Feature Requirement

Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is...

very sorry .. that file was from another PC...

Under my PC there are no Setup Bootstrap folder

Only EULA,SDK and Shared folders.. lot of folders are missing under 90...

This is log file

Microsoft SQL Server 2005 9.00.1399.06

==============================

OS Version : Microsoft Windows XP Professional Service Pack 3 (Build 2600)

Time ...

Thanks .. I needed this output..

Thanks again for your quick Reply

Are there any place to Mark this thread as Answered post

Amount = money

select SUM(CAST(AMOUNT AS decimal(18,2))) FROM tableName

I go through Books Online. But still no better idea.

There are no any sql mechanism for it. Want to do my own (in my sp)

Thanks both of you

sorry. mean time there are no replies. and i think i was at wrong forum category. tats the reason for post it again. i apologies for it

BEST REGARDS

SAPATHSOFT

ya thanks for reply. Your correct.That kind of thing i want to do. so how i do user permission for single table.can you send me more details or some useful...

hi...

My new row number is letter + Row number. I tried to do " Get all rows and get repeated rows and sort. then giving new name to above...

Thank you very much Jack,

This message useful for my case.I needed this

:smooooth:

Regard

Sampath

(SriLanka)

hi,

First i want to thanks both of Grasshopper,Jack Corbett to replied me.

Still my problem is same. Earlier i used cascade for delete my foreignkey references. But now i remove cascade....