I finally said the heck with it and wrote an SP:

CREATE PROCEDURE [DBO].[mystats]

(

@poolid int,

@empid varchar(50),

@pos int output,

@pts int output,

@ties int output,

@ahead int output

)

AS

BEGIN

 SELECT @pts=TotalPoints FROM playerStandings...

This view gets joined to a table of people/points by the number of points. It tells me for each person not only how many points they have but whether or...

Unfortunately xp_cmdshell is restricted in our environment... 

Still returns 4,979. Select count(*) in QA returns 5,000.

Aren't row counts in the System tables notoriously inaccurate? I thought I'd seen that several times in other posts.

Thanks for the contribution but

1. It's not accurate. I run it against a table with 5,000 rows and I get back 4,979. I need exact counts.
2. It doesn't work on Views.

Hmm... Not sure how that would work. Here's the whole context:

I have a table of distribution lists. Each list has a name (descriptive) and a table/view name that is the...

nb: I looked at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=258288#bm258319

and that doesn't solve my problem as far as I can tell.

I was entering the string as you did above with my SP:

Exec dbo.Instant_Status 'BF33FA65-D558-43F5-BE47-0F0D20AB0028'

but I was getting no return. I went back and found I'd copied the GUID from...

Thanks Sergiy,

I guess I could use your technique to pull the GUID of a row from a table and execute my SP. I was hoping someone would chime in on...

That did the trick!

I was so close...

That was dumb. Re-reading my own post, I'm in QA... Of course I can't use RETURN.

Sheesh!!! Virtual Monday.

Something like:

 

Create function dbo.checkdate (@dt as datetime) AS

BEGIN

Declare @test-2 datetime

Select @test-2=datefield from table

If @test-2 = @dt then return 0

Return 1

END

dbo.checkdate(getdate())

If I read it right you're assuming that if the first 5 characters match then the brokers are duplicates? If so, have you tested that to see if it really...

Maybe in QA, but not within a Stored Procedure...