newbieuser (5/10/2011)

---

I tried the sql using openquery but I'm not getting it right..

SELECT * from OPENQUERY(LS, 'SELECT * FROM U.ABO,

U.LED_ID,

U.PROJECT_NO,

T.WORDC,...

Never mind. I ended up going retro and using a couple of views (using case statement for the merge) and a stored procedure which I'll schedule in stead.

Works fine, and...

I looked for a way of modifying the original, but couldn't find it, so I'll just make it available here.

CREATE TABLE [db].[table1] (

[columnA] [numeric](18, 0) NOT NULL ,

[columnb] [ntext]...

Hi John - I could, but would that really be useful here? Useful enough to warrant creating a table full of fake data? Or do you think that the example...

The 'funny' thing is that although Query Designer doesn't parse it, it is allowed in a View.

So, what I tend to do as a work around, is one of these...