ChrisMoix (8/12/2009)

---

blandry said:

Last time we hired a DBA I was stunned at how many applicants had good SQL skills, but Zero .NET, Zero CLR skills. I know, I know, some...

Faiyaaz (8/12/2009)

---

Understandable, but what I mean is, like a notification popup when using the production db, a popup occurs warning you that you are on production. Why I ask, is...

Please read the second article in my signature block regarding asking for assistance on performance problems. Based on your post, there really isn't much we can do to help...

What is the fill factor on the table?

NewbieCoding (8/12/2009)

---

CREATE PROCEDURE [dbo].[p_getCallStats]

@Col1 int = null,

@col2 datetime = NULL,

@col3 int = NULL

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON

...

You will have to reinstall SQL Server 2005. There is no uninstall at this time for service packs. I think this may change in the future, possibly with...

Read about Recursive CTE's...

rja.carnegie (8/12/2009)

---

A previous exercise elsewhere, which I think was about testing for primes in the fewest characters of script, was where I learned you can use @ as a variable...

What did you find? Details please, someone else may have the same question.

Not really sure what you are asking here. Could you provide more information about what you are trying to accomplish?

Hope this gets you started in the right direction. All I did was mimic the sample code from BOL (Books Online).

create table #t1 (id int,pid int,s varchar(100))

insert into #t1...

To get help faster and get working tested code, please read the first article I reference in my signature block regarding asking for assistance.

To really help you, we need the...

Why not change this:

AND (VV.Fund_Valuation_Date = (SELECT MAX (Fund_Valuation_Date)

FROM dbo.Fund_Valuation VVV

WHERE VVV.Fund_Valuation_Date < '2006-09-01'

AND VVV.Fund_Number = V.Fund_Number

AND VVV.Class_Type_Abbr_Name = V.Class_Type_Abbr_Name

AND VVV.Class_Type_Category = V.Class_Type_Category))

to this:

AND VV.Fund_Valuation_Date = (SELECT MAX (Fund_Valuation_Date)

FROM dbo.Fund_Valuation...

Actually, I may have figured it out. Took a lot of digging and guess work. Preliminary testing looks good, but it is late, and I really don't feel...

drew.allen (8/11/2009)

---

I think that this line from...