Or you could start over at 'a'.

declare @MyChar char(1) = 'z'

select NextLetter = case @MyChar when 'z' then 'a' else char(ascii(@MyChar) + 1) end

Or you could add collation to make...

Luis Cazares (8/29/2012)

---

I tested my last solution and won't give the exact results.

Try this instead:

;with MyRank (col1)

as

(

select 6 union all

select 5 union all

select 4 union all

select 3 union all

select 2...

Luis Cazares (8/29/2012)

---

Another option:

;with MyRank (col1)

as

(

select 5 union all

select 4 union all

select 3 union all

select 2 union all

select 1 union all

select 1 union all

select 1

)

SELECT TOP 5 col1

FROM...

Sounds to me like a lot of smoke blowing is going on there. 😛

Kumar SQL (8/29/2012)

---

I have a table like this-

Sno Text

1 Batch 58701, Sub -000 .

2 ...

This is pretty simple using Row_Number. Please notice how I posted sample data to make this a lot easier for anybody else. You should do something similar in your future...

kamasat (8/29/2012)

---

Hi Sean Lange,

Thank you for your reply.

In my client place, to take backup of the database, in SQL server, there is an option 'Generate Scripts' which is not allowed...

Great question Wayne.

kamasat (8/28/2012)

---

Hi,

I tried using the stored procedure to connect to the external server bu am unable to connect by entering the correct server name, user name and password. I don't...

mak101 (8/28/2012)

---

GilaMonster (8/28/2012)

---

I recommend you do not run the Profiler GUI against a busy production server. It's far more overhead than a server side trace.

Set up a server side trace,...

mak101 (8/28/2012)

---

I need to store trace output to file. Can I store output to local machine and not on server? I do have admin rights to the sql server for...

As others have already stated, you need to provide more details. What...

david_a_wallace (8/28/2012)

---

Thanks for your help, I'll keep on with this method of making numeric autonumber IDs instead of using things like people's names.

The reason the ContainerTypeID is in the contact...

Sean Lange (8/28/2012)

---

You can also expand the table in SSMS. You can click and drag the "Columns" folder to a query window and you will have comma separated list of...

You can also expand the table in SSMS. You can click and drag the "Columns" folder to a query window and you will have comma separated list of all the...