Something like this should do it:

CREATE TABLE #Tracks(

[DateTime] [datetime] NULL,

[Track_1] [bit] NULL,

...

Per Books Online, the Null thing in result sets is intentional. Probably to make it easier to visually differentiate Null from a zero-length string.

I think your best option is...

I don't think you can build the string in the OpenRowset command. Try building it as a string variable before, then use that.

nKognito (5/13/2008)

---

I do not have any bottlenecks right now. All that I want is to understand is there any simple way to improve SQL server performance and throughput by adding...

Yes, you can use Union All, or anything else that's normally valid in a view.

P.S.: If you really want to use that function, you'll need to put it in your From clause, using CROSS APPLY, instead of in your Select clause. Inline functions...

Don't use that particular function. Used correctly, it will get the job done, but there are better ways to do this.

Here's a sample that works much better:

select top 100001...

The classic, direct way to do this is use four-part names in your From clause for the remote database tables.

Example: Three servers, 1 with the view and the table dbo.Table1,...

There was recently an article on this site about how to do this kind of thing very efficiently.

http://www.sqlservercentral.com/articles/TSQL/62867/

(Your test data doesn't work as written, since you tried to insert the value 1 into your ID field twice, after defining it as the primary key.)

Yes, your tests are...

Per your original post:

I suggested...

Your right! (Of course.) I'm too used to functions in Where clauses giving index scans. Guess this is another of the exceptions.

Tom Garth (5/12/2008)

---

I actually was trying to say 'turn my poorly...

Excellent. Glad it worked out for you.

I haven't designed a query graphically in so many years that I'm afraid I really can't help you on this one. Sorry.