You can't "fix" that with properties. You have to fix the underlying tables. Either make the source smaller...

I believe the article from Jeff Moden http://www.sqlservercentral.com/articles/T-SQL/71550/%5B/url%5D is exactly what you are looking for.

harri.reddy (8/29/2012)

---

guys,

i want to know when i place my cursor over , OLEDB destination, there is an error symbol.

and the message is "truncate may occur due to column ."

how can...

Actually I don't think your works Luis.

I added some more data and it doesn't do what the OP asked for originally.

;with MyRank (col1)

as

(

select 6 union all

select 5 union all

select 5...

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...