Straight from Books Online: (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/fulltxt9/html/76767b20-ef55-49ce-8dc4-e77cb8ff618a.htm)

Incremental timestamp-Based Population

Incremental...

Are you rebuilding the entire catalog every night? Is it possible for you use the Change Tracking AUTO feature or do Incremental Population?

I too had the same requirement in one of our application but I didn't find any useful scripts at that time. So, I decided to write my own function...

Go to Books Online > Type "outer joins"

You know we are here to help you when you are stuck with an issue that you are not able to resolve, information...

Barry,

Well, I know it can easily extended to the next or higher level by adding another REPLACE of 9 commas or even 11 commas, but I just wanted to let...

RBarryYoung (4/4/2009)

---

Uh, no. ...

Another way that comes to my mind is to conditionally direct the control flow to multiple file tasks according to the name of the file.

For e.g., create 10+...

Thanks Phil for supporting the only solution, till now.

Instead...

INSERT dbo.SomeTable

EXECUTE dynamic_pivot.....

David (4/3/2009)

---

Hi Ramesh,

Slightly different question this time. Using the following:

CREATE TABLE [dbo].[Test](

[name] [varchar](10) NOT NULL,

[jan] [int] NOT NULL,

[feb] [int] NOT NULL,

[mar] [int] NOT NULL,

[year] [int] NOT NULL)

INSERT INTO [dbo].[Test] (name,...

Vijaya Kadiyala (4/3/2009)

---

Hi

Is this a good way of having all the possible values

FOR periodheader IN( [JAN A HEADER], [FEB A HEADER], [MAR A HEADER],

...

If you've books online installed on your local machine, just copy & paste that link to see the relevant...

Using Package Configurations...(see BOL link: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/9b939edb-4e17-48e5-8428-855beb10049c.htm)

The error indicates the the formed query either does not have a table or column with the specified alias.

Can you post the exact query text that has been executed by...