sammuts (8/16/2011)

---

Hi,

In all my tables my first field is an Identity field which is set as my primary key. Is it a good practice to use this fied...

troe_atl (8/15/2011)

---

Hi everyone.

I have a store procedure that has a summary query that return 4 rows but only inserts 2 rows into my table. Please take a look at the...

Here's another method which is 3x faster than OVER()

SELECT a.PlayerId, a.PlayerName, a.overs, a.PlayerScore - ISNULL(b.PlayerScore, 0) AS Score

FROM #score a

CROSS APPLY(SELECT [LastRow] = MAX(overs) FROM #score WHERE PlayerName = a.PlayerName...

Prasanthi Reddy (8/16/2011)

---

This gives complete score in 1st over also in 2nd over. I want the score only in 2nd over.

i.e., difference between 2nd over and 1st over's score.

Also i...

SELECT a.*, b.*

FROM score a

INNER JOIN score b ON b.PlayerName = a.PlayerName AND b.overs = 2

WHERE a.overs = 1

@@ROWCOUNT will be the number of rows updated. Bear in mind that a row may be updated only once. Your findings indicate that for some rows of your target table,...

Is your rowcount equal to the result of this query?

SELECT COUNT(*)

FROM TargetTable_Staging tts

WHERE EXISTS (SELECT 1

FROM TargetTable t1

INNER JOIN Dyn_Company t2

ON t1.Company=t2.Name COLLATE SQL_Latin1_General_CP1_CI_AS...

Coincidence (Red Sonja was on UK terrestrial tv last night - I'd forgotton how cr@p it was - even more so after 300)

-- run this

SELECT COUNT(*)

from TargetTable_Staging tts

inner join (

select t1.id as PKid,t2.id as IndexId

FROM TargetTable t1 inner join Dyn_Company t2 (NOLOCK)

ON t1.Company=t2.Name COLLATE SQL_Latin1_General_CP1_CI_AS )t3 on tts.id=t3.PKid

-- and this

select...

Kiara (8/15/2011)

---

...Now I'm curious, though, so once I get back to the actual problem this is related to, I'll post a version of what actually works best in the environment...

SELECT

[DAY number 1] = 01/01/2004, -- result is integer 0

[DAY number 2] = 31/12/2004, -- result is integer 0

[Date 1] = CAST(01/01/2004 AS DATETIME), --...

Kiara (8/15/2011)

---

Have a look at the actual execution plans...

Yes, and if there's an index on channel_cd, then your version would of...

Put the TSQL into a stored procedure and call the sproc from the job.

Or like this, depending on your data:

SELECT r1.ProductID,

[total number of units to a pallet] = r1.[qty in units] * r2.[units in a case] * r3.[cases to a pallet]

FROM...