Thanks for your replies, i use the Script send by jeff and they work very fine.

Also, i understand now better the concept about using DELETE with INNER JOIN

Luis Santos

Hello Kathy

i´am running SQL Server locally not on remote instance.

I try also to configure SQL server to allow remote connection but i have always the same error.

I think the problem...

Hello Kathy

I think the problem is not on SQL server 2008, but is on my Os Windows 7 , because like i said , throught Managment Studio or throught ODBC...

Hello Kathy

Yes, if i loggin throught SQL managment Studio, everythings work fine.

Actually, your OS is Windows 7 X86 ??

Hello

Thanks Paul and Ian , know i could understand better how can make several joins to derived tables.

Good weekend

Luis Santos

Hello again Ian

I try your script but they return an error :

Msg 208, Level 16, State 1, Line 1

Invalid object name 'valowbincid'.

I change to the following and now they work...

Hello Ian

Could you please build this join to help me, because i don´t know the syntax of the join, join on 2 derived table or not.

Thanks

Luis Santos

Hello Bob

Thanks for your script they work OK.

I need to explore better the "CROSS APPLY" and there use.

Many thanks

Luis Santos

Hello Bob

Sorry, i forget to send the script to create the table FO and FN, now i will send to you the scirp

Many thanks

Luis Santos

TABLE FO

CREATE TABLE [dbo].[fo] (

...

Hello BOB

Thanks for your reply.

I prepare this scripts to recreate tables FO and FN with the data on them .

Note : i have use only one article "DESIGN" that...

Hello Maxim

Yes, is what i want, i will try your TSQL.

Many thanks for your reply

Luis Santos

Hello

The UNION operator dosn´t solve my problem because i need 2 specific columns, like i said.

Also, the second post reply don´t work.

I need to have the following :

no ...

Hello Mohit

Thanks for your reply,

on point

2.2 - No you can't. If the database has been attached to 2008 it cannot be attached back to 2005.

I think that...

Hello Dan

Thanks for your reply, i will test with my sql server 2005 to see what i can build and how it work.

Many thanks

Luis Santos

Hello comunity

I want to know if i can install Report Builder 2.0 RTM on my machine OS Vista SP1, but u have SQL Server 2005 SP2 STD Edition.

This software...