Could you supply the table definition, some sample data and desired results from that sample data.

To do so easilu\y click on the first link in my signature block to...

without additional information .. all I can say is use the proper WHERE clause

Sridhar-137443

Can you execute your most used quires using SSMS, if you can click on the button "Show Actual Execution Plan", and execute the procedure, if production work load is such...

daveriya (2/25/2011)

---

hi

i have a table like this

name ...

Try this:

DECLARE @A DECIMAL(5,0)

DECLARE @b-2 DECIMAL(5,0)

DECLARE @P DECIMAL(3,0)

DECLARE @Ans DECIMAL(5,1)

SET @A = 7.

SET @b-2 = 12.

SET @P = 100.

SELECT ROUND((@A/@B) * @P,1)

--If you just wish to display the resutl:

--that is...

GSquared (2/23/2011)

---

Brandie Tarvin (2/23/2011)

---

WayneS (2/23/2011)

---

Brandie Tarvin (2/23/2011)

---

LutzM (2/22/2011)

---

Jeff Moden (2/21/2011)

---

...

I dun no... DE-troit boy goin ta ohia mur dan wonce in da sames yer mite git da kin...

To help those who want to assist you please post the table definitions, provide some sample data, the results need from that sample data. Use the format to provide...

Read the link I sent to you, there are methods of shortening the time required for a merge statement. It will all depend on the where clause utilized.

Also be...

Glad to be of assistance

A few questions:

1. Do the applications which access the DB use stored procedures or dynamic SQL?

1a. How many stored procedures does the application utlize?

2. Do you have...

The SQLServer:Latches object in Microsoft SQL Server provides counters to monitor internal SQL Server resource locks called latches. Monitoring the latches to determine user activity and resource usage can help...

Jeff Moden (2/21/2011)

---

Heh... no one even noticed recently... I slipped over the 24,000 post line, Gail topped 22,000 posts, and Gus has put the hammer on 10,000 posts.

Well done, ladies...

Let me add my thoughts great article and thanks for the code examples.

Grant Fritchey

You need to talk to your client and clarify exactly what they want. If they're anything like people I've worked with, they want everything. So then you have...

graham.hilton23

Your welcome, as you work it out come on back and post what you have done so as to help others who may have the same or a...