Scott

I don't know how the port selection is made, but I do know that you can fix the port if you go into SQL Server Configuration Manager.

John

preetha.sathyamoorthy (6/2/2008)

---

Hi John,

I tried your query. It's giving the correct output. The output is starting with 0 only, If the id is starting with 1. If it is starting with...

Rajan John (6/2/2008)

---

try some form of this -

select a.id - 1 from table_name a where not exists( select b.id from table_name b where a.id = b.id + 1)

the first...

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/29248949-325b-4063-9f55-5a445fb35c6e.htm

Yeah, so did I. I see what happened now.

John

Sorry, I don't understand. What CAST to nvarchar(800)? Is there a typo in the question?

John

msbasssinger (5/28/2008)

---

What is it that the proponents of AGCC want? More government intrusion into telling me what I can drive, how it has to be built, how I use...

Yes, use OUTER JOINs instead of INNER JOINs where appropriate.

John

msbasssinger (5/28/2008)

---

[font="Tahoma"]First, it is not the overwhelming majority of the scientific community. When you narrow it down to scientists with expertise in closely related fields, they are quite divided....

Wouldn't be the first time. Remember the new Ice Age (global cooling)? Science is not a democracy. Scientists discover things daily that change what they thought was...

msbasssinger (5/28/2008)

---

[font="Tahoma"]A free people are always free to investigate the facts, which is why so many Americans know the whole anthropogenic global climate change issue is a hoax and a...

Probably the best way would be to create a "numbers" or "tally" table. Search this site for how to do that and examples of what it can be used...

Joseph

No, the same limits don't apply to SQL 2005. Have a look on the Microsft website to see what the limits are. Have you checked that you have...

Mmmm... we're really looking for table DDL in the form of CREATE TABLE statements and sample data in the form of INSERT statements. But anyway, looking at the snippet...

Joseph

You're right about what the /3GB switch does, but if your application can't use all the memory available to it then it won't. SQL 2000 Standard can only use...