You use IDENTITY which is a physical storage locator and not relational. You need to go back, throw this crap and get a real key. In the meantime, it...

OK, i do it

One question about

Will that code (that use Tran) LOCK that tables until finish, ..

So until end or commit transaction, will no one put any record on this...

I don't understand you. What do you mean ..

Hello, I don't want to disable FK

Here' the DDL

TABLE1=====================================

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Forums.Categories.Threads](

[DomainId] [int] NOT NULL,

[ForumId] [int] NOT NULL,

[CategoryId] [int] NOT NULL,

[CreatorId] [int] NULL,

[ThreadId] [int] IDENTITY(1,1) NOT NULL,

[Deleted]...

Thanks, but the problems for FullText is that actually every day the table has more than 2 thousands of new records (every day).

It difficult to mantain

Yeah, i will consider.

But a question.

Using Full-text, may not decrease performance ¿?

You think that with full-text the queries will be more faster ?

As mentioned in http://www.simple-talk.com/sql/learn-sql...

in order to perform full text searching on a table you need to:

1) ..

2) Create a full text catalog in which to store full text...

Thanks rbarryyoung

Just the key!

Just using % between words !

Thanks

i RESOLVE USING

CAST ( REPLACE( CAST (@nDecimalWithCommaAsDecimalSeparator AS NVARCHAR),',','.') AS DECIMAL(16,4)

SO

SELECT (CAST ( REPLACE( CAST ('123,45' AS NVARCHAR),',','.') AS DECIMAL(16,4))

WILL RETURN

123.45

Beacuse performance If any knows beest way to...

THANKS I Resolve IT !!, ..

The CTE are on a SP (example SP_CTEOfClassifications)

I WRITE THE FOLLOWING CODE

FIRST I CREATE A TABLE

CREATE table TEMP_Classifications(all columns that retrieve the SP_CTEOfClassifications)

SECOND: USING INSERT...

I will try, but its a very difficult Beacuse the Select Statement includes CTE

Thanks but

I'm said that i cannot create or modify TABLES (not databases) for an existing database that i attach from a file (that come from another server).

OLD_SERVER: "MyDatabase" Ok all

NEW_SERVER:...

Thanks to all.

Finally i found the solutions, on a thirds urls that i found.

Thanks to GrassHopper and the other one. The GrassH Url's serves me a trick to found more...

Thanks, I will check on nexts hours ..

But as far as i search last 4 hours some related on inet, the PIVOT / UNPIVOT related sources was seems difficult to...