Hello,

Here is the answer:

drop table tables

drop table columns

create table tables (table_id int, tableName varchar(128))

create table columns (table_id int, columnname varchar(128), columntypedef varchar(128))

insert into tables

select 1, 'table1'

union

select 2, 'table2'

union

select...

Hello Eirikur,

Thank you so very much for taking the time to help me.

I am creating a small web portal that allows the user to register. Then upon registration, will be...

Hello Jeff,

Thank you so much for your guidance.

I will post the CREATE script for the sp and function and any data.

Thank you again!

Matt

Hello Luis,

I will do this.

Thank you so very much.

Sincerely,

Matt

Hello Luis,

I can't thank you enough for all your help.

I ran into some errors with the code you helped me with, but having seen your advice, it makes sense.

I am...

Hello Mad Admin,

I think I am getting closer with your help. Here is what I have:

DECLARE @RigsVolTableParam varchar (10)

DECLARE @RigsVolRowParam float

DECLARE @RigsInputActionParam varchar (20)

DECLARE @VolumeParam numeric (17,2)

DECLARE @RegStartQtrParam varchar...

Hello Luis,

I am most appreciative of your time and attention.

I am going to try out your suggestion. I will post back.

Thank you so much!

Matt

Hello Mad Admin,

Let me try this suggestion.

Thank you so very much for your time and assistance.

Most sincerely,

Matt

Hell Alan,

Thank you so very much for taking the time to help me.

I am going to try this now.

Most sincerely,

Matt

ufnGetPerYear_1 function definition:

USE [SAPBW_DataWarehouse_R3]

GO

/****** Object: UserDefinedFunction [DWH].[ufnGetPerYear_1] Script Date: 17/12/2015 21:06:41 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER FUNCTION [DWH].[ufnGetPerYear_1]

(@CnV numeric(17,4), @StrQtr int, @StrYr int, @EndQtr int, @EndYr...

Hello,

Ok, I resolved it.

I found lines in the Script Task C# script that held the table name and row name for each individually processed column.

I stored these as they...