Open Forum

Is anybody aware of or built a SQL function (or code or stored proc) that reads the company's FlexKey definition and applies the proper formatting to the SubAcct?  Thanks!

Joe

------------------------------
Joe Miller
Director of Systems Architecture
Harrison, Walker & Harper
Paris TX
------------------------------

If you look under past conference materials from the San Diego conference in 2016, there's an example in the SQL script from my SQL 401 presentation.

------------------------------
Jonathan Van Houtte
Architect
XLstatements, LLC
Clifton Park NY
------------------------------

Original Message:
Sent: Mar 03, 2022 06:51 PM
From: Joe Miller
Subject: SQL to Format Sub based on FlexKey Defs

Is anybody aware of or built a SQL function (or code or stored proc) that reads the company's FlexKey definition and applies the proper formatting to the SubAcct?  Thanks!

Joe

------------------------------
Joe Miller
Director of Systems Architecture
Harrison, Walker & Harper
Paris TX
------------------------------

It appears my membership lapsed.  So I just upped it and now I wait until access is granted to the library...  <insert Jeopardy theme here>

Thanks Jonathan!

------------------------------
Joe Miller
Director of Systems Architecture
Harrison, Walker & Harper
Paris TX
------------------------------

Original Message:
Sent: Mar 03, 2022 07:01 PM
From: Jonathan Van Houtte
Subject: SQL to Format Sub based on FlexKey Defs

If you look under past conference materials from the San Diego conference in 2016, there's an example in the SQL script from my SQL 401 presentation.

------------------------------
Jonathan Van Houtte
Architect
XLstatements, LLC
Clifton Park NY

Original Message:
Sent: Mar 03, 2022 06:51 PM
From: Joe Miller
Subject: SQL to Format Sub based on FlexKey Defs

Is anybody aware of or built a SQL function (or code or stored proc) that reads the company's FlexKey definition and applies the proper formatting to the SubAcct?  Thanks!

Joe

------------------------------
Joe Miller
Director of Systems Architecture
Harrison, Walker & Harper
Paris TX
------------------------------

@Jonathan Van Houtte,

So membership has been renewed, but I'm not seeing anything when I browse past conference materials.  Would you be able to put your hands on the collateral and either post here or email it to me?  I'd be much appreciative!​  Thanks in advance!!

Joe

------------------------------
Joe Miller
Director of Systems Architecture
Harrison, Walker & Harper
Paris TX
------------------------------

Original Message:
Sent: Mar 03, 2022 07:01 PM
From: Jonathan Van Houtte
Subject: SQL to Format Sub based on FlexKey Defs

If you look under past conference materials from the San Diego conference in 2016, there's an example in the SQL script from my SQL 401 presentation.

------------------------------
Jonathan Van Houtte
Architect
XLstatements, LLC
Clifton Park NY

Original Message:
Sent: Mar 03, 2022 06:51 PM
From: Joe Miller
Subject: SQL to Format Sub based on FlexKey Defs

Is anybody aware of or built a SQL function (or code or stored proc) that reads the company's FlexKey definition and applies the proper formatting to the SubAcct?  Thanks!

Joe

------------------------------
Joe Miller
Director of Systems Architecture
Harrison, Walker & Harper
Paris TX
------------------------------

That's strange, as I can access all of it.

I've attached the script as a text file.

------------------------------
Jonathan Van Houtte
Architect
XLstatements, LLC
Clifton Park NY
------------------------------

Original Message:
Sent: Mar 04, 2022 08:44 AM
From: Joe Miller
Subject: SQL to Format Sub based on FlexKey Defs

@Jonathan Van Houtte,

So membership has been renewed, but I'm not seeing anything when I browse past conference materials.  Would you be able to put your hands on the collateral and either post here or email it to me?  I'd be much appreciative!​  Thanks in advance!!

Joe

------------------------------
Joe Miller
Director of Systems Architecture
Harrison, Walker & Harper
Paris TX

Original Message:
Sent: Mar 03, 2022 07:01 PM
From: Jonathan Van Houtte
Subject: SQL to Format Sub based on FlexKey Defs

If you look under past conference materials from the San Diego conference in 2016, there's an example in the SQL script from my SQL 401 presentation.

------------------------------
Jonathan Van Houtte
Architect
XLstatements, LLC
Clifton Park NY

Original Message:
Sent: Mar 03, 2022 06:51 PM
From: Joe Miller
Subject: SQL to Format Sub based on FlexKey Defs

Is anybody aware of or built a SQL function (or code or stored proc) that reads the company's FlexKey definition and applies the proper formatting to the SubAcct?  Thanks!

Joe

------------------------------
Joe Miller
Director of Systems Architecture
Harrison, Walker & Harper
Paris TX
------------------------------