Hello Lotz,

You can use Group By with Count(*) > 1 condition

Here is a script

SELECT

Number, Firstname, Lastname, Email

from dbo.Person

WHERE

Number BETWEEN '10000' AND '11000' or

Number BETWEEN '13000' AND '14000' or

Number BETWEEN...

The sql code within the cursor backups the db

The cursor is running for every db in the server

So concentrate in the cursor code, except fetch, etc codes replacing the cursor...

Hi subbu,

In official documents it is stated that an upgrade from CTP versions to RTM versions is not supported.

I know there are ways of doing these especially in Windows OS,...

Hello

The below query reads XML into row data then updates and converts back to XML

declare @xml XML = '

<root>

<lang>....</lang>

<testRoot>

<test>

...

Hello CrazyMan,

In sql article you can find How to Create Partition Function on SQL Server 2008 as well as How to Create Partition Scheme

Using these partition function and scheme, the...

Hi CrazyMan,

You can also partition a sql table.

You can place each partition to different files.

Hi Paul,

Actually your previous solution does not even require padding.

That is a better solution I guess for this example.

Hello,

You can use row_number and count with partition by specification.

In the below example I used sql pad leading zeros function during id and seq.number concatenation

with cte as (

select

id,

amount,

rn =...

Sometimes happens to me too, but I believe it is better to mention the correct solution more than once

Of course if it is really correct solution

Hello,

I guess what your are looking for is t-sql dense_rank() function

select

dense_rank() over (order by cat),

...

I've been using SSRS since it was beta and I'm very satisfied with it.

You can customize the reports easily.

Thanks Jeff,

I checked the BOL and I found :

The amount of logging for SELECT...INTO depends on the recovery model in effect for the database. Under the simple recovery model or...

You can also backup transaction log and reduce the size by deleting after 100000 rows for example, then continue with an other 100000 delete, etc.

Yes, that is an important topic.

If you could truncate than there will be no problem. But since you want to keep some of the records in the table, then DELETE...

If you have foreign keys, constraints etc it will take a longer time to delete records from sql table.

Also it will be better I guess to disable indexes (delete indexes)...