Matt Whitfield (9/30/2009)

Like I said, it's not an ideal solution. (<- That's three times now). But, clearly it's an OK solution for the OP, seeing as it seems that is...

Matt Whitfield (9/30/2009)

---

Apart from SET...

I'm pretty sure it's not.

SqlDataReader members give you metadata about data stream ALREADY RETURNED by the query/procedure.

They cannot give you any info...

CREATE CLUSTERED INDEX TransactionDetail_AccountDate ON dbo.TransactionDetail(AccountID, [Date])

GO

DECLARE @AccountID INT, @AccountRunningTotal MONEY

UPDATE T

SET @AccountRunningTotal = AccountRunningTotal

= Amount + CASE

...

Can you explain the logic of the output?

"status" indicates a result of actions taken on an entity, or lack of any action.

Every time you query for results of different actions - you name it different statuses.

So, ditch...

select * INTO Temp_ CONTACTCALLDETv1

from CONTACTCALLDETv1

where 1=0

Then check the new table columns, find the one of tinyint type and find which one of the sources of the data for this...

Put your code into system procedure on master database and execute it like this:

IF EXISTS(SELECT * FROM sysdatabases where name = 'PersonProfile')

EXEC PersonProfile.dbo.sp_MyGrantPermissionProc

If it does not work like...

Yes, how you build any query depends on desired outcome.

But that obviously was not true:

Lynn Pettis (9/9/2009)

---

I think it is a wash...

No, you should leave criteria on "FROM" table in WHERE:

WHERE c.contest_id = 2

Only criteria on LEFT JOIN table go into ON.

SELECT c.contest_attempts_allowed,

count(ca.ca_status_cd)

FROM contest c LEFT OUTER JOIN contest_activity ca

ON c.contest_id = ca.contest_id AND ca.p_id = 1

WHERE c.contest_id = 2

GROUP BY contest_attempts_allowed

http://labs.google.com/papers/bigtable.html

Marcin Gol [SQL Server MVP] (9/7/2009)

---

Sergiy (9/7/2009)

---

Marcin Gol [SQL Server MVP] (9/7/2009)

---

Sergiy - the paragraph you mentioned change nothing. hash is a hash - and for a given string should...

Marcin Gol [SQL Server MVP] (9/7/2009)

---

Sergiy - the paragrah you mentioned change nothing. hash is a hash - and for a given string should always return the same value. did...