What does meta-philosophy have to say about the (presumably) philosophical work of non professional philosophers? This variable value can be based on target year. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. Very often when working with BTEQ script you will face requirement to use dynamic variables or parameters. Macros can contain DDL statements, but that should be the last statement in Macro. We make use of First and third party cookies to improve our user experience. Please note, if you are used to writing a select statement as your last statement in your stored proc, you will have to create a cursor. Projective representations of the Lorentz group can't occur in QFT! In this post we will see different methods in which you can pass parameters to BTEQ script. Next, we assign the value to the Output parameter. Thanks for contributing an answer to Stack Overflow! SELECT concat(@demoEducba1,@demoEducba2). DECLARE @demoEducba1 AS VARCHAR(100)='Happy Learning! It's pretty common to load variables into a CTE and reference the CTE in your SELECT statement: You can just cross join that CTE into your other tables (or derived tables) and make the same reference much like the Volatile table answer above, but without the bloat of actual storage. . It names each parameter followed by its data type., You cannot declare variables in a typical SQL Statement that you are running directly from your code editor. Literals, expressions, the result of a query, and special register values can be assigned to variables. For many SQL Server or Oracle developers, you may encounter some inconveniences when writing SQL queries. Cookies are small text files that can be used by websites to make a user's experience more efficient. Integral with cosine in the denominator and undefined boundaries. In SQL Server or Oracle you can define it very easily. Can you please explain how doesn't it work? A stored procedure, a database object executed on the Teradata Database, is a combination of SQL statements and control and condition handling statements that provide an interface to the Teradata Database. By clicking Post Your Answer, you agree to our terms of service, privacy policy and cookie policy. Run code between 64 and 123, you will create the stored procedure in your database. The lifetime of the local variables begins once they are declared and ends with either the end of the stored procedure if those variables are used in the stored procedure or at the end of the batch in case if they are used in the batch execution. The name must have a single @ as the first character. All the other variables will be changed (back 2 year, 2017, back 4 year 2015). The following example executes the Macro names Get_Emp; When the following command is executed, it retrieves all records from employee table. We can declare as many local variables that we require in SQL and specify their datatypes and initialize and assign values to those variables using DECLARE, SET, and SELECT statements as demonstrated in the above examples. Launching the CI/CD and R Collectives and community editing features for TSQL Declare a variable in tsql without defining columns explicitly. You can't create variables in a typical Teradata sql script. Adding a widget is the same as declaring a variable. Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. Before executing the stored procedure declare a variable for the UDT and insert some values. Good Morning My Friend! The teradata in touch with time when fired on a stored procedure codes. Which is correct example for variable declaration? Row 3-11, create a variable table, which I will use later. rev2023.3.1.43269. Is it possible to just use the following syntax on Teradata? DECLARE @demoEducba AS VARCHAR(100)='Happy Learning!' Instead, the selected column or columns must be used within the procedure. 2016-2018. Enjoy unlimited access on 5500+ Hand Picked Quality Video Courses. This is not possible in plain SQL without using PL/SQL construct in Teradata. However if you are calling BTEQ code in shell script you can easily use shell variables in BTEQ SQL queries. My ASP Classic application are fetching over 10.000 rows via a triple inner join. Data type and variable name. By Raj Teradata The easiest method to pass parameters to BTEQ script is to call it within a shell script. How did Dominion legally obtain text messages from Fox News hosts? By the way, I did better than them in school. SET @wishes = 'Hey! Following is the generic syntax of the CALL statement. Instead create a volatile table and store the value of your "variable" in the table. Why do you need to initialize a variable? Even though the path is a String, 'the variable must be a Variant because For Each.Next 'routines only work with Variants and Objects. Therefore, this approach works. Hadoop, Data Science, Statistics & others, DECLARE { @Name_Of_Variable Data_Type [ = Initial_Value ] }. You cannot declare variables in a typical SQL Statement that you are running directly from your code editor. One way to achieve this with date stored as some variable in stored procedures on Teradata is: DECLARE v_SQL_Text VARCHAR (32000); DECLARE v_Somedate Date; SELECT Current_Date INTO :v_Somedate; SET v_SQL_Text = 'SELECT TOP 10 * FROM SOMETABLE WHERE SOMEDATE = ' || v_Somedate || ';' CALL DBC.SysExecSQL (v_SQL_Text); Share Improve this answer We can assign the values to the variables declared in SQL with the help of two methods that are given below: 1. Teradata is a Massively Parallel Processing (MPP) Data Warehousing technology. Stored Procedures are created using CREATE PROCEDURE statement. It is a pain. Learn more. The SELECT statement can be used to assign the values to the variables in SQL as well as retrieving the value of those variables. Are there conventions to indicate a new item in a list? Learn SQL on EDUCBA with payal. as shown below. Browse other questions tagged, Where developers & technologists share private knowledge with coworkers, Reach developers & technologists worldwide. Asking for help, clarification, or responding to other answers. Sorry, Hillary. Save my name, email, and website in this browser for the next time I comment. The following example creates a stored procedure named InsertSalary to accept the values and insert into Salary Table. We'll assume you're ok with this, but you can opt-out if you wish. By using this website, you agree with our Cookies Policy. UNION Users only need EXEC privilege to execute the Macro. That concept, you can treat people the information about when flight, including its warrant list, ring a logical unit. How to react to a students panic attack in an oral exam? LWC open source Javascript framework in more. Publish articles via Kontext Column. The website cannot function properly without these cookies. am assuming that u r trying to submita stored procedure. Let us see one example of how we can use the SELECT statement to assign and retrieve the values of the variables that are declared in SQL. Variable declarations in a Teradata Stored Procedure are always local to the surrounding compound statement (BEGINEND) and to all the compound statements located within the surrounding BEGINEND. Let us take a look at an example, you will see what I mean. SQL commands stored in Teradata variables can be executed using. We can declare multiple local variables and use them in SQL by declaring each of them individually using DECLARE statement for each of them or using a single DECLARE statement and declaring all the variables in the same statement by separating the declaration of each variable with a comma. We make use of First and third party cookies to improve our user experience. The definition of Macros is stored in Data Dictionary. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS. SELECT @wishes AS 'Good Wishes'. One of the table is somewhat similar to the following example: DECLARE @t TABLE ( id INT, DATA NVARCHAR(30) ); INSERT INTO @t Solution 1: Out of (slightly morbid) curiosity I tried to come up with a means of transforming the exact input data you have provided. So I can create a shell script and pass the values as parameter. Duress at instant speed in response to Counterspell, Parent based Selectable Entries Condition. How would that work? Declare VARCHAR(x) with x as a parameter? At what point of what we watch as the MCU movies the branching started? This is a nice solution because it will work on any RDBMS that supports CTEs (so everything except for mysql --UPDATED-- mysql 8.0+ now supports CTEs!). We can assign the values to the variables using the SET statement with the help of the following syntax. Oftentimes, we cannot change the world, we will adapt ourselves to interact with the world. To learn more, see our tips on writing great answers. Is there an equivalent of declaring a variable similar to this Sql Server (TSQL) code in teradata's sql dialect? It turned out in Teradata you will need to create a temp variable table, then cross join that to the table/tables which you want to use variables. Macros are executed using EXEC command. How do you declare a variable in Teradata? You can call the stored procedure and then call the RESULT_SCAN function and pass it the statement ID generated for the stored procedure. The intention is to display ads that are relevant and engaging for the individual user and thereby more valuable for publishers and third party advertisers. Date types are highly formatted and very complicated. In Case statement, we defined conditions. Notify me of follow-up comments by email. Here we discuss the introduction, example and assigning values to the variables, respectively. For example: DECLARE @site_value INT = 10; This variable declaration example would declare a variable called @site_value that is an INT datatype. DECLARE @wishes varchar(100) If you provide us with more details, maybe we can show you a workaround. Further, we can declare the name and data type of the variable that we want to use in the batch or stored procedure. RV coach and starter batteries connect negative to chassis; how does energy from either batteries' + terminal know which battery to flow back to? Normally a SELECT results in rows being returned to the user. Run Row 126-127, you pass in target year 2018 and you will get student from prior 4 year since 2014 (4 students). Where Name_Of_Variable is the variable name that we wish to assign, note that according to the syntax of the variable declaration and usage in SQL. No from statement needed. SELECT @wishes AS 'Good Wishes'. DATE is the datatype used for storing date values in a table. SQL commands stored in Teradata variables can be executed using EXECUTE IMMEDIATE command. Launching the CI/CD and R Collectives and community editing features for Teradata declaring dates at start of the script, Teradata Sql assistant not running SELECT statements, check if volatile table exists in teradata, Select a variable to output from within stored procedure in Teradata. I have a legacy product that I have to maintain. Thanks. Let us consider one example of declaring the variables in SQL. The following example calls the stored procedure InsertSalary and inserts records to Salary Table. How do you DECLARE an int variable in SQL? Why is there a memory leak in this C++ program and how to solve it, given the constraints? After this, it is going through each line, calculating some stuff and putting data in a multidimen Solution 1: Lets analyse this whilst also bearing mind the SQL has an ORDER BY Clause:- do until rs.eof response.flush counter = counter + 1 ' A LOT of calculations and putting in array. If you dont include this, the 2nd time you run the stored proc, it will complain so and so table exists. To declare (create) a variable, you will specify the type, leave at least one space, then the name for the variable and end the line with a semicolon ( ; ). Its so important to do this that Java either initializes a variable for you, or it indicates an error has occurred, telling you to initialize a variable. Good Morning My Friend! For numeric variables, a precision and scale are also assigned. Specifying the initial value to the variable is the optional thing. Using the SET statement. Look at the following example; We declared a variable @ProductID and specified value 1 for it. How does Teradata solve the similar situation? Thank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. The open-source game engine youve been waiting for: Godot (Ep. Row 78-96, I copied the previous script to stored proc. is something similar possible on TeraData. How do you DECLARE and set a variable in SQL? You need EXEC privilege to execute the Macros. Macro is a set of SQL statements which are stored and executed by calling the Macro name. You can extend the queries to joins and etc. A stored procedure contains a set of SQL statements and procedural statements. DB2 LUW also does not require any variable declaration to pass back to the calling. In the where clause, I limited enrollment date between prior2yearbegin and targetyearend, i.e. 542), How Intuit democratizes AI development across teams through reusability, We've added a "Necessary cookies only" option to the cookie consent popup. Variables are very useful when you need to change part of code while keeping most of the code intact. Data from below table will be used to create cursor query and cursor will be used to create INSERT statements on the run. Not the answer you're looking for? Use "pre" tags with your current output to preserve spacing and line breaks.. I've seen SMS messages take 24 hours to deliver. CREATE PROCEDURE ( [parameter 1 data type, parameter 2 data type..] ). I consent to the use of following cookies: Necessary cookies help make a website usable by enabling basic functions like page navigation and access to secure areas of the website. If you have been using Oracle or SQL Server, creating variables and stored procedures is like a breeze. You have a target year, let us say 2018 (back 2 year, 2016, back 4 year 2014), then next year, this number will become 2019. Okay, I added some text to add clarification of where each of the mentioned solutions. We can make the use of the Declare statement to declare the local variables in SQL and then optionally initialize those variables to a certain initial value. Sometimes, you will see people write cross join different ways like the following but without join conditions. Why was the nose gear of Concorde located so far aft? You may also have a look at the following articles to learn more . Let's quickly see an example to understand this. Note that when we do not specify the initial value to the variable, the variables value is by default assigned to NULL. It turned out in Teradata you will need to create a temp variable table, then cross join that to the table/tables which you want to use variables. Teradata - Stored Procedure Previous Page Next Page A stored procedure contains a set of SQL statements and procedural statements. Why must a product of symmetric random variables be symmetric? In TSql I can define a variable like so: DECLARE @Threshold AS int; SET @Threshold = 5; I can then use it like so: ,COALESCE ( CASE WHEN X >= @Threshold THEN A ELSE NULL END ,CASE WHEN Y >= @Threshold THEN B ELSE NULL END ) AS Bla is something similar possible on TeraData tsql teradata Share Improve this question Follow By clicking Post Your Answer, you agree to our terms of service, privacy policy and cookie policy. Using Variables TOAD supports all kinds of SQL, from all kinds of applications. The term stored procedure refers to a stored procedure you write with SQL statements. How can I recognize one? When you are told in Teradata, you cannot use a variable in Teradata script (you can declare a variable in stored proc though), you might be shocked, especially when you want to implement something flexible. Very often when working with BTEQ script you will face requirement to use dynamic variables or parameters. Promoting, selling, recruiting, coursework and thesis posting is forbidden. June 22, 2007 in IT There is no direct answer to this question as this concept is present and used only in Stored Procedures and Macros in Teradata. Further, the declared variables are referred to as the local variables. Assigning a system-supplied or user-defined data type and a length. Teradata stored procedure is created from the following commands: BTEQ utility using the COMPILE command.Following is the syntax of the CREATE PROCEDURE statement. Learn more. What are two requirements for declaring a variable? Public keyword is used to declare Class variables and class methods. By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. Now let us insert some data into this volatile table. Assume you have a report in which some queries need to go back 2 year, other queries need to go back 4 year. TPT (Teradata Parallel Transporter) is a client suit that support multiple instances of . Users don't need separate privileges on the database objects used inside the Macro. As we did for UINON example, we can use the same trick for local variables. I have below BTEQ script: Now you can see I have hardcoded SQL query in the BTEQ. It's free. The Current_Date part can be replaced with any scalar query. Following is the generic syntax of the CREATE PROCEDURE statement. Book about a good dark lord, think "not Sauron". You can very easily pass shell variables to BTEQ script. Once a condition is satisfied, its corresponding value is returned. SELECT @wishes = 'Hey! Teradata is a parallel 'shared-nothing' database management system. Making statements based on opinion; back them up with references or personal experience. Browse other questions tagged, Where developers & technologists share private knowledge with coworkers, Reach developers & technologists worldwide. In SQL Server or Oracle you can define it very easily. So, I dont need that. This is very common for BI reporting. SELECT @demoEducba. Was Galileo expecting to see so many stars? Enjoy unlimited access on 5500+ Hand Picked Quality Video Courses. in SQL Assistant, for BTEQ you can use shell scripts to plug a variable in. What capacitance values do you recommend for decoupling capacitors in battery-powered circuits? Find centralized, trusted content and collaborate around the technologies you use most. Good Morning My Friend! Using A Variable In MySQL Select Statment In A Where Clause Februari 26, 2023 I would like to know if it's possible to find a value in a select statement and use it in a where clause like: SELECT col1, MAX (col2) - COUNT (DISTINCT col3) as variable FROM table Solution 1: You could try subquery syntax, also called nested select. Good Morning My Friend! It isn't a rights issue. If one of the SQL statements in Macro fails, then all the statements are rolled back. Help me understand the context behind the "It's okay to be white" question in a recent Rasmussen Poll, and what if anything might these results show? ALL RIGHTS RESERVED. The next procedure defines var1 as a local variable and assigns an initial value using a DEFAULT and then substitutes the value into the WHERE clause of a DELETE: This example is only a building block approach to writing stored procedures. Well, it kind of depends on what the OP means by variables, or is actually trying to do. Is lock-free synchronization always superior to synchronization using locks? Good Morning My Friend! Then use those variables in your statement. Within a Macro, these parameters are referenced with ; (semicolon). Ill neatpick a bit here but an I/O is an I/O. Connect and share knowledge within a single location that is structured and easy to search. Some examples of using stored procedures to match complex updates. For example: int age; float weight; char gender; In these examples, age, weight and gender are variables which are declared as integer data type, floating data type and character data type respectively. For all other types of cookies we need your permission. Theoretically Correct vs Practical Notation. Also, how the local variables can be reassigned to the values and manipulated further according to requirements along with the syntax and implementation with the help of certain examples. SQL data types, SQLLEN values, and SQLTYPE values that the precompiler uses for host variables in COBOL programs. Row 13-20, I inserted some begin and end date. How did StorageTek STC 4305 use backing HDDs? Advantages What capacitance values do you recommend for decoupling capacitors in battery-powered circuits? Loading Application. Microsoft sql server version of this situation causes an array declared in dict. Concur_updatable is a view for python offers a coplast hostname as if and screenshots available. If you run this now, you will see the variable table was populated. Declaring a Transact-SQL Variable The DECLARE statement initializes a Transact-SQL variable by: Assigning a name. Rename .gz files according to names in separate txt-file. Only 1 row, so if you cross join it with other tables, it will add the variable columns to the table without causing dup. Row 1, use default database, here I block database name to protect privacy. This website uses cookies to improve your experience. We can make the use of the SET statement in SQL to assign the values to the variable irrespective of whether the variable has an initial value or previous value assigned to . Teradata stored procedure is created from the following commands: BTEQ utility using the COMPILE command.Following is the syntax of the CREATE PROCEDURE statement. The syntax for defining one or more variables is: DECLARE [ DEFAULT ] ; The variable name list may contain one or more variable names. We declare an integer variable x in the outer and inner compound statements. Following is the generic syntax of CREATE MACRO command. Table 1. Clash between mismath's \C and babel with russian. *Tek-Tips's functionality depends on members receiving e-mail. If you find difficulty to write other queries in Teradata, feel free to raise it here in the comment area. Here are the actual variable declaration rules: Coplast hostname as if and screenshots available random variables be symmetric, from all kinds of applications values that precompiler! Making statements based on opinion ; back them up with references or experience... The name and data type and a length can call the RESULT_SCAN function pass. We 'll assume you have been using Oracle or SQL Server, creating variables and Class.! Introduction, example and assigning values to the Output parameter, and website in this browser for the UDT insert! In dict structured and easy to join and it 's free a Transact-SQL variable by: assigning a or! By: assigning a name thank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will this! Random variables be symmetric inconveniences when writing SQL queries some values can see I have a legacy product that have! & technologists worldwide was the nose gear of Concorde located so far aft between 's. Reach developers & technologists worldwide there an equivalent of declaring a variable for the stored procedure is created from following. Stored proc, it retrieves all records from employee table statements based on opinion ; them! Insert into Salary table dont include this, but that should be the statement! Macro, these parameters are referenced with ; ( semicolon ) teradata declare variable and easy to search party. I teradata declare variable some begin and end date code editor a volatile table store... And share knowledge within a Macro, these parameters are referenced with ; ( semicolon ) Teradata 's dialect. Receiving e-mail a name satisfied, its corresponding value is returned using locks UINON. Is an I/O is an I/O the previous script to stored proc Learning! with scalar... Quickly see an example to understand this @ ProductID and specified value 1 for it in BTEQ queries... Great answers a Condition is satisfied, its corresponding value is by default assigned to variables is a. It very easily representations of the mentioned solutions will complain so and so table exists optional thing a name adapt. Superior to synchronization using locks it kind of depends on members receiving e-mail adding a widget the. Is by default assigned to NULL the datatype used for storing date values in typical! I have below BTEQ script you will face requirement to use in outer! Stored proc, it will complain so and so table exists Selectable Entries Condition a look at the but... And then call the RESULT_SCAN function and pass the values to the variable, result... Or is actually trying to do if one of the create procedure statement: now you can very.! Sql data types, SQLLEN values, and SQLTYPE values that the precompiler uses for host variables BTEQ! Names Get_Emp ; when the following example creates a stored procedure and then the... Code editor create Macro command them in school you 're ok with this but. And community editing features for TSQL declare a variable in to just use the same declaring... The local variables means by variables, a precision and scale are assigned! A single location that is structured and easy to join and it 's free and inner compound statements be?... According to names in separate txt-file SQL statement that you are calling BTEQ code in Teradata variables can be using. Variables to BTEQ script change part of code while keeping most of the mentioned solutions enrollment date prior2yearbegin! Support multiple instances of value to the calling be the last statement in Macro that you calling! Collectives and community editing features for TSQL declare a variable similar to this RSS,. System-Supplied or user-defined data type.. ] ) also does not require any declaration. On members receiving e-mail demoEducba1 teradata declare variable VARCHAR ( 100 ) ='Happy Learning! for storing date values a... Following but without join conditions host variables in a typical Teradata SQL script the optional thing group ca n't in..., other queries need to go back 2 year, 2017, back 4 year 2015 ) is! It within a Macro, these parameters are referenced with ; ( semicolon.. Legally obtain text messages from Fox News hosts into this volatile table scalar query the SELECT statement can executed! And inner compound statements articles to learn more prior2yearbegin and targetyearend, i.e synchronization using locks ;! That you are running directly from your code editor UINON example, we the... Inside the Macro name and how to react to a students panic attack in an oral exam writing. Row 3-11, create a shell script following is the same trick for local variables MPP... Am assuming that u R trying to submita stored procedure teradata declare variable InsertSalary to accept the values to the variable,... Columns must be used to declare Class variables and Class methods with more,., you will see different methods in which some queries need to go 4! Specifying the initial value to the variables in SQL Server version of this situation causes an array declared dict! By using this website, you will see what I mean to solve it, given the constraints 2017 back... Was the nose gear of Concorde located so far aft variable is the same as declaring a.!, Reach developers & technologists share private knowledge with coworkers, Reach developers technologists... Variables be symmetric the statements are rolled back between mismath 's \C and babel with russian based! Have to maintain which are stored and executed by calling the Macro SQLLEN values and! If one of the mentioned solutions TOAD supports all kinds of applications at instant speed in to. So I can create a variable for the next time I comment SQL Server Oracle. Internet 's largest technical computer professional community.It 's easy to search there an equivalent declaring. A students panic attack in an oral exam application are fetching over 10.000 via... Row 78-96, I copied the previous script to stored proc, kind... Teradata is a client suit that support multiple instances of declaring the variables, a precision and scale also... Server version of this situation causes an array declared in dict share knowledge within a shell script year 2017. See the variable table was populated a user 's experience more efficient, expressions, the result of a,! Sql statements ; we declared a variable in TSQL without defining columns explicitly example of the... Within a Macro, these parameters are referenced with ; ( semicolon ) time you run now. In shell script SQL, from teradata declare variable kinds of SQL statements in Macro when need! Of SQL statements and procedural statements match complex updates names in separate txt-file (... Definition of macros is stored in Teradata, feel free to raise it here in the and. Stored proc, it will complain so and so table exists and targetyearend,.! Parameter 2 data type, parameter 2 data type.. ] ) values that the precompiler uses for host in... Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action to! Information about when flight, including its warrant list, ring a logical unit of. Coursework and thesis posting is forbidden name and data type of the variable is the optional thing run this,. 123, you agree to our terms of service, privacy policy and cookie policy sometimes you. Developers, you will face requirement to use in the BTEQ the previous script to stored.., i.e for host variables in BTEQ SQL queries typical Teradata SQL.. Ddl statements, but that should be the last statement in Macro you provide us with more,... Variable that we want to use dynamic variables or parameters does meta-philosophy have to say about the presumably! Run this teradata declare variable, you agree with our cookies policy some queries need to part. Teradata in touch with time when fired on a stored procedure you write with SQL statements in Macro fails then! Batch or stored procedure is created from the following commands: BTEQ utility using the set statement with world. See I have below BTEQ script is to call it within a single @ as the MCU movies the started! X in the outer and inner compound statements, or is actually trying to do ( 2., email, and SQLTYPE values that the precompiler uses for host variables in a table if. With any scalar query the technologies you use most not specify the initial value to the variables value is.. Given the constraints retrieves all records from employee table and assigning values to the variable that we want to dynamic... This volatile table and store the value of those variables what does meta-philosophy have to say the. With coworkers, Reach developers & technologists share private knowledge with coworkers, Reach developers & technologists worldwide the value. Macro fails, then all the other variables will be used to create cursor query cursor! In an oral exam microsoft SQL Server or Oracle developers, you may some! The value of those variables selling, recruiting, coursework and thesis is. Useful when you need to go back 2 year, 2017, back 4.... A user 's experience more efficient stored proc union Users only need EXEC privilege to execute the Macro Get_Emp. Create Macro command often when working with BTEQ script variables to BTEQ script you can not variables. From inappropriate posts.The Tek-Tips staff will check this out and take appropriate action specify the initial value the. On Teradata shell scripts to plug a variable in SQL inconveniences when SQL. Thank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take action. For many SQL Server version of this situation causes an array declared in dict face. Declare Class variables and stored procedures is like a breeze row 78-96, I did than. Type and a length can create a variable around the technologies you use most execute the Macro code 64...