You should be able to use the ranking functions to get what you are looking for. Here is a sample.

Declare @t Table(i int)

Insert Into @t

Select 1

Union All

Select 1

Union All

Select...

If you go to the command prompt and type "set processor_architecture" it will tell you what you are running on, but if it is 32 bit you should install x86.

It sounds like your application my be passing a GUID. If that is the case, just cast it to a uniqueidentifier in SQL and it will remove the curly...

Something like this.

--Sample Data

Declare @Tbl Table (RoomID int)

Insert INTO @Tbl

Select 101

Union All

Select 102

Union All

Select 201

Union All

Select 202

Union All

Select 203

--Sample Query

SELECT

Distinct

RoomList = substring((SELECT ( ', '...

My knowledge increased ten fold after participating in the forums. It is a great way to see how other people accomplish the same thing. Also, if you post...

The query is asking for rows less than the current date. Every time you restore the database and run the query the date range is bigger which is returning...

Here are some upgrade considerations.

First of all run the SQL 2005 Upgrade Advisor to make sure there are no compatability issues.

http://www.microsoft.com/downloads/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en

Restore the database to the new server.

Change the...

But wait there's more...

These are a little less measureable, but if you give an example of when you did each one, you have met your goal.

Performance Goals

1. Customer Focus...

Here are a few things that may help...

Watch x webcasts a quarter/month.

Attend x community events such as user groups.

Take a test toward a certian certification. (you don't have to pass,...

2005 Express should install. Look at the supported OS's on the download page.

http://www.microsoft.com/downloads/details.aspx?FamilyID=220549b5-0b07-4448-8848-dcc397514b41&DisplayLang=en

You can install Developer Edtion.

http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx

This is from books online. It is still available in 2005, but it looks like it is not in 2008.

sp_runwebtask is retained for backward compatibility. New Web pages are...

I was expecting at least a 10 point Turkey question on Thanksgiving. 😀

Steven Webster (11/26/2008)

---

I'd certainly agree that a registry hack is not the way forward. Unfortunately though where I work an auditors word is always taken ahead of mine! Interesting point...

Steven Webster (11/26/2008)

---

Great article Ken. Much appreciated.

Can I ask your views on the following - I recently had auditors in and one of their recommendations was to increase the maximum...