In the days before the company upgraded the network to 100Mbits the system engineer installed a second network card(100Mbits) on my Pc and another card (100Mbits) on the my SQL...

Look for the ThinSlicer example on the web!

Hopefully its relevant

BOL 2000

SET ANSI_PADDING

Controls the way the column stores values shorter than the defined size of the column, and the way the column stores values that have trailing blanks...

I was thinking about getting away from the 8000 limit by not using XML. Suppose it will cause to much of a rewrite/mods?

OK, so round tripping will be a problem.

Can the data be converted to a ADO recordset of some sort, after which it can loaded in a SQL temp table, processed,...

AS Antares686 was saying "Query optimiser is stumbling somewhere." I thought it may just tickle it to generate a "better" / different plan. Agree in principal with your statement "ascending...

1) Migrate all the where clauses into the ON part of the statement if possible. Move the m.(MOAT) to be the first table in the FROM and make the...

Hope this is of some help:

SELECT FDT_NAme, F_Description,

(Select Case t.FDT_NAme When 'UA_PHONE' Then a.UA_PHONE

...

I think your explanation is clear enough but agree with previous post. If you can post the script to create and populate 3 to five records in both tables it...

Agree, seems like shooting oneself in the foot. What about the AT command? Can access it through xp_cmdshell.

Try this

Select ('SELECT a.* FROM OPENROWSET(''SQLOLEDB'', ''Trusted_connection=yes;Server='

+ @@Servername

+''', ''SELECT...

Export data as rows and then use a pivot table in Excel.

Example

SQL data rows

Prod1, qty2

Prod2 qty2

After pivot

Prod1 Prod2

Qty1 Qty2

If possible, can you supply the steps and table / index scripts.

Would like to try and reproduce the problem?

Thanks

Are you after async processing.

Fire a command and check periodically if finished. Done in dblib. While server runs monster sp the app was initializing the controls and then wait for...

Nice problem!

Needs to check maxlevels(endless loop)!

Set NoCount on

-- Drop Table TestII

GO

Create Table TestII(catId INT IDENTITY,catParentId INT,catName nvarchar(50))

go

insert TestII Values (0,'Root1')

insert TestII Values (0,'Root2')

insert TestII Values (1,'SubRoot1.1')

insert TestII...