Thank you all for your assistance.

I am going to tryout the method that Sean has highlighted first as the code needs to be called via dynamicSQL (due to determining...

Don't worry if you don't understand Sean,patrickmcginnis59 highlighted the issue yesterday and

Stewart "Arturius" Campbell (6/19/2012) hinted that it may be posssible to get the information using a join...hopefully someone...

What I am trying achieve is the same functionality as the following statement without calling the SplitLocalRef() function, split out the [OTHER_COLS] delimited list from TableA into individual columns on...

I've plumbed the DelimitedSplitN4Kfunction in and can see how efficient it is but I don't understand how to use the output in an INSERT without calling it multiple times as...

Thought it would be confusing to ppl. I am trying to achieve is a piece of code that generates results like

INSERT INTO TableB ([COL_1],[COL_2],[COL_3],[COL_4],[COL_5]) SELECT [COL_1],[COL_2],[COL_3], ufnsplit([OTHER_COLS], 1), ufnsplit([OTHER_COLS], 2)...

Check the collation sequence of the database and tables CS/CI

The application can be run in a test mode to check the results are as required before running in production mode where the results are processed by the SSRS and...

Thanks to everyone. Looks like the consensus of view vs table, is 'it depends' 🙂 and we are going to have to trace where the bottleneck is rather than simply...

Mark Fitzgerald-331224 (4/18/2012)

---

What exactly is the process here? The users are selecting tables at random ( from a combo box?) apart from the Primary table, this is then joined...

There are indexes on all the columns used in the JOINs but not on all the columns that could be in the WHERE clause (otherwise we would have indexes...

Thanks, all the joins are table to table, the only view involved is the temporary view that pulls together all the table joins so that the SSRS can simple read...

You need to load the IBM Client Access OLE DB provider before you can establish a connection. It is part of the iSeries Access for Windows product.

I thought UAC applied to Vista and 2008 Server?

On my Win 2003 system I'm running as a network administrator (and also have the same profile as local administrator).

In...

I installed SP2 along with all Windows Update hotfixes. I can't see anything in the readme concerning Win 2003 or permissions although there is some details on UAC on Vista.

Is...

Gift Peddie,

Can you offer some more advice on Visual Studio and the processes involved in getting the data into SQL with Lam-Alef and correct sequencing?

I have VS 2005 up...