rbarryyoung (6/28/2008)

---

The real difference between these languages isn't the hair-splitting technical differences, nor is it the religious-based flame-wars over what are simply style differences and personal preferences.

No, the...

Jeff Moden (6/27/2008)

---

Matt Miller (6/27/2008)

---

I personally roll with a tally table with a 1M limit, but that's a personal choice.

Otherwise - it's very easy to come up with a numbers...

I personally roll with a tally table with a 1M limit, but that's a personal choice.

Otherwise - it's very easy to come up with a numbers table of pretty much...

SELECT a.ClassId, s.race,

SUM(case when a.Status='P' then 1 else 0 end) AS Present,

SUM(case when...

Try rebuilding the clustered index on that table. If need be, you might care to check that the fill factor on the clustered index isn't set to something too...

every row has the same time setting, so ANY of the rows could be returned in a

SELECT TOP 1...ORDER BY [DateTime]

There's no guarantee which row would be pulled.

Jeff Moden (6/27/2008)

---

Yuckon (6/27/2008)

---

Hi chaps

Thanks for your input but I think you are missing my point.

The code is made up,

The end user is not the best at writing efficient SQL...

What kind of function is it that's performing that many writes? The only thing it can be writing to is a table variable, which then spells trouble since they...

Panji_panjul (6/27/2008)

---

Hi experts,

How can i delete data without primary key or specific key , my imagine such as below

delete from table_xx where exists (

select a,b,c from...

Actual validation of the file contents and structure using a batch file is not going to be easy (I'm not going to say it's entirely not possible, but it's going...

zxn001 (6/27/2008)

---

I didnt know SQL could do that.

And you made me a believer, a very confused one, but still believing.

So now I'm really curious, WHY does the set loop work...

My gut would be - copy through batch file, but validate some other method (probably .NET console app to tap into some parsing muscle.)

If all you're looking to...

zxn001 (6/27/2008)

---

The set was much faster.

However, I must note that in order for the set to work, you must have the pre-existing data for it to compute, which whould require...

or schemabinding! 😛

And what is the compatibility level of the DB in question?