Even if you select form a single table, select * would need all the columns returned, so SQL Server will need to scan through the whole table. If you need...

Ok, and here is a solution without a temptable :), just a CTE expression. Although I'm sure there is a more efficient way to do this 🙂

WITH ...

Hmm, interesting problem, did not want to spend much time on it, so here is a solution using a temporary table:

GO

WITH cte

...

The solution actually came from JohnG, and I've learned something too 🙂

Glad your issue is solved

- Andras

...

You are incorrect Andras. Another poster has already put up code that works in SQL 2005. There is a mechanism for 2000 as well although it is certainly...

rkjayaraj (6/20/2008)

---

I have a SQL Server table with nvarchar type column which has not null constraint. I am inserting empty string ("") from Java to the table column. When I...

JohnG (6/19/2008)

---

Also knowing Oracle, I do wish that there was a ROWID equivalent in SQL Server. I'm also aware that it is used in "finding duplicate" queries.

In SQL Server...

Good point, I should have read...

You will need to rebuild the table, i.e. you cannot just use an alter...

Andras Belokosztolszki (6/18/2008)

---

What about something like:

SELECT Student_Id,

YEAR(Date),

COUNT(*) AS numberOfAbsences

FROM studentTable

GROUP...

What about something like:

SELECT Student_Id,

YEAR(Date),

COUNT(*) AS numberOfAbsences

FROM studentTable

GROUP BY Student_Id,...

In...

There is no rowid that...

Both of these are largish topics, so I'd suggest you look at Books...

bkrishnasamy (6/18/2008)

---

Hi,

we are using window's authentication in my server. I want to know, who (hostname or machine id) is updated and compiled any sp's recently . Plz help me...