Here is a User Defined Function that can be called to perform this functionality wherever and whenever needed. Best of luck!

-- ************************************************************************************

-- Create Function

-- ************************************************************************************

CREATE FUNCTION tsgudf_FormatPadLeft

 (@StringToPad VARCHAR (255)...

Recall from the orginal post: When the table is sorted by Company, CostCenter, Account and Subsidiary a positional heirarchy is created.

Am I correctly assuming that becuase there is no physically...

Is there any easy way to convert NO model to a Nested Sets Model?

Interesting... Thanks for the helpfull ideas!!!

I have just bought Joe Cleko's Trees and Hierarchies in SQL for Smarties (ISBN 1-55860-920-2)

and Joe Celko's SQL for Smarties: Advanced SQL Programming 2nd...

Solved with the following:

  AND (CASE

    WHEN @EmployeeNumber IS NULL THEN F060116.YAAN8

    WHEN @EmployeeNumber = 0 THEN F060116.YAAN8

    ELSE @EmployeeNumber

   END = F060116.YAAN8)

THANKS FORUM for all the efforts.

I had to change the @AddressNumber to 1 in order for the CASE statement in the WHERE clause to work using Antares636 proposed modifications. Previously...

Made mod to add 'as AddressNumber' to end of CASE... same error received. Any other thoughts?

VERY ELEGANT Solution Chris!

Two thoughts:

1) Problem when entering a from date of '20000201' - instead of only not including Month1 of 2000 the proc does not include Month1 of...

Thank you for the clarification!

So, in concluding, will the following will work as described?

On the AddressTable

INSTEAD OF UPDATE <conditionally intercept and change business rule invalid UPDATES to INSERTS>

UPDATE <trigger to...

SQL Server Books Online Topic "Specifying First and Last Triggers" indicates...

"INSTEAD OF triggers cannot be specified as first or last triggers. INSTEAD OF triggers are fired before updates are...

Web Sites to visit:

http://www.intelligententerprise.com has very good information centers for Data Warehousing, Business Intelligence, Data Integration, and Analytic Applications.

http://www.dw-institute.com (The Data Warehouse Institute)

Books:

Data Warehouse Design Solutions...

Thanks DavidT.

Your solution has pointed out one minor problem in my Data Description.

The Sick, Vac, and SickVac codes are NOT in the physical table (I only used...

Thanks for the guideance however I have reviewed those solutions and the topic referenced assumed the name is delimited with spaces and as such does not provide enough of a...

I like Joe Johnson's information. This approach means making a modification to you code implementation to check for and handle any names that may include the apostrophe, intercept them and...