Viewing 15 posts - 1,411 through 1,425 (of 3,221 total)
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...
March 1, 2011 at 12:56 pm
without additional information .. all I can say is use the proper WHERE clause
March 1, 2011 at 12:26 pm
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...
February 28, 2011 at 8:07 am
daveriya (2/25/2011)
i have a table like this
name ...
February 26, 2011 at 8:54 am
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...
February 24, 2011 at 9:22 am
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...
February 23, 2011 at 9:38 am
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...
February 22, 2011 at 4:22 pm
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...
February 22, 2011 at 12:37 pm
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...
February 22, 2011 at 10:49 am
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...
February 22, 2011 at 7:00 am
Jeff Moden (2/21/2011)
Well done, ladies...
February 21, 2011 at 1:18 pm
Let me add my thoughts great article and thanks for the code examples.
February 21, 2011 at 12:33 pm
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...
February 20, 2011 at 12:43 pm
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...
February 19, 2011 at 4:55 pm
Viewing 15 posts - 1,411 through 1,425 (of 3,221 total)