Roger L Reid (11/3/2010)

---

Sure - didn't know it at the time because it wasn't important - we weren't running MS servers at all. But I know the history....

It's on the menu bar in SSMS.

True. I made some assumptions about use that may not be valid.

You're the third person to accuse me of that.

The first was...

You can do a couple of different things to accomplish this.

The best would be to make a table that has your values in it, and join to that table in...

RPSql (11/3/2010)

---

Select * from a table with one billion rows failing with following error (SQL 2005 SP3 HF11)

An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException'...

select case when MyColumn = 'Header' then 1 when MyColumn = 'Other' then 2 else 3 end as Seq,...

SeanLange (11/3/2010)

---

As it sits there is no order by anywhere in this so there is no guarantee about what order it will be returned in.

On another point, this looks like...

If the database won't change...

Here's as far as I got in the time I've had so far.

Try this out, see if it helps with the first query's performance. I'll see if I can...

You're welcome.

Put simply, those are placeholders. The "Script As" button has no clue what actual values you want, so it just puts something there that can help you fill in...

I'd have to see the rest of the query to be able to help much.

As an aside, take a look at uses of a Numbers or Tally table to split...

Create a sub-table for students, include a column for "Project Suffix" which will include the "a", "b", "c". For ones that don't need that, put a zero-length string or...

They're called "Input Parameters". You could have one like this:

create procedure dbo.IDsByDOB

(@DateOfBirth_in datetime)

as

select ID, DateOfBirth

from dbo.MyTable

where DateOfBirth = @DateOfBirth_in;

Then, of course, the application has to be built to run...