No announcements
Found 2756375 threads
-
0 VotesIs there a way to create dynamic variable names?
I'd like to be able to create a set of variable names IF condition x==true say the variable's base name is ...Answered | 7 Replies | 679 Views | Created by -B-M- - Friday, January 15, 2016 5:38 PM | Last reply by David Lowndes - Monday, January 18, 2016 3:42 PM
-
1 Votes
Creating Variable names/identifier dynamically
The only way you wouldn't would be if you were using an interpreted language (like JavaScript) in which declaring variables is optional.Answered | 13 Replies | 36399 Views | Created by raw.well - Friday, September 9, 2011 1:38 AM | Last reply by Tiago A. Rocha - Monday, May 28, 2018 11:35 AM -
0 Votes
create variable name dynamically
I don't think it's possible and I don't think it's a good idea to try to create such generic grid code if it results in such T-SQL code.Answered | 9 Replies | 8041 Views | Created by pota0311 - Sunday, August 8, 2010 2:13 PM | Last reply by pota0311 - Sunday, August 8, 2010 7:16 PM -
0 Votes
Dynamically create variable names in TSQL
If you're using SQL Server 2005 and up, simply google on "Dynamic Pivot example".Answered | 9 Replies | 11144 Views | Created by jmillman3 - Tuesday, January 5, 2010 6:49 PM | Last reply by Yasser Zamani - Mr. Help - Tuesday, January 5, 2010 8:56 PM -
0 Votes
Is there any way to dynamically create a table variable without static field declarations?
As it turns out, we've decided, for now anyway, to forget about temp tables/variables and go with creating a single query string and using Exec.Answered | 12 Replies | 946 Views | Created by B. Chernick - Wednesday, May 4, 2016 7:41 PM | Last reply by B. Chernick - Monday, May 9, 2016 2:49 PM -
2 Votes
C# Dynamic Variable Naming
So when you call the same function, or same event occurs again(in you case when you click button 2nd time) all the variables are totally new. variable (tRow1) (in 2nd time) ...Answered | 6 Replies | 6862 Views | Created by jagarz - Monday, March 7, 2011 4:46 PM | Last reply by jagarz - Tuesday, March 8, 2011 3:20 PM -
1 Votes
how to do dynamic variable names in function?
Thanx for the point about dynamic SQL.Answered | 15 Replies | 4813 Views | Created by j-m.s - Tuesday, August 25, 2009 7:59 PM | Last reply by Brian Tkatch - Thursday, August 27, 2009 1:17 PM -
0 Votes
Pass Database name dynamically in to a variable using SSIS
i have same situation and looking for answer and found that you can create your sql in variable and the select source type as variable , then select that variable.Answered | 4 Replies | 7958 Views | Created by sql9 - Wednesday, February 24, 2010 4:50 PM | Last reply by BiDev_Raj - Thursday, January 21, 2016 7:14 PM -
4 Votes
Assign a name to flat file of a dynamic way
URL: http://decipherinfosys.wordpress.com/2008/07/23/ssis-exporting-data-to-a-text-file-using-a-package/ In this package date is every file it create ...Answered | 4 Replies | 3126 Views | Created by dhuerta - Thursday, September 22, 2011 3:06 PM | Last reply by Achilles33 - Friday, September 23, 2011 12:28 PM -
2 Votes
using table name variable in create function
> Can you show me the way to solve my problem?Answered | 4 Replies | 5452 Views | Created by Hanny Gaoxing - Thursday, September 30, 2010 4:45 AM | Last reply by Kalman Toth - Thursday, September 30, 2010 9:29 PM -
0 Votes
how to create dynamic workbook+sheet name+ssis
Do you mean, everytime when you run the package data should be exported in new sheet provided in Variable?Answered | 1 Replies | 1601 Views | Created by harikiran2010 - Thursday, April 9, 2015 12:33 PM | Last reply by Vaibhav.Chaudhari - Thursday, April 9, 2015 12:52 PM -
0 Votes
Changing Database Name Dynamically Using Code\Variables
How would I use it the best way if I want to execute the statements that this SQL generates for me?Answered | 9 Replies | 2108 Views | Created by MaxShapiro - Monday, June 23, 2014 9:26 PM | Last reply by Erland Sommarskog - Tuesday, June 24, 2014 10:22 PM -
0 Votes
Is there any way for a variable name to start with a number?
VS needs to know if the string is a literal number or a variable etc so if its start with a number then it assumes it is a number.Answered | 4 Replies | 833 Views | Created by sqlguy - Friday, November 6, 2020 10:19 PM | Last reply by sqlguy - Saturday, November 7, 2020 2:23 PM -
0 Votes
Variable Name for Creating Instance of a Class
So it doesn't make sense to match the variable name with some runtime value.Answered | 14 Replies | 590 Views | Created by philhaldane - Friday, May 4, 2018 11:16 AM | Last reply by philhaldane - Friday, May 11, 2018 1:23 PM -
1 Votes
Using an environment variable to create a directory dynamically
"Create Environment Variable" create environment variable on the system level.Answered | 6 Replies | 1089 Views | Created by Ballari Maitra - Wednesday, July 30, 2014 4:56 PM | Last reply by Ballari Maitra - Tuesday, August 5, 2014 1:37 PM -
0 Votes
create table with dynamic table name.
Change your declarations from DECLARE @table1 nvarchar(500) to DECLARE @table1 SYSNAME (and same for other variables).Answered | 5 Replies | 1025 Views | Created by diablomark - Tuesday, May 13, 2014 1:10 AM | Last reply by diablomark - Tuesday, May 13, 2014 3:09 PM -
0 Votes
Create dynamic variable
You never use the tmp variable.Answered | 2 Replies | 1500 Views | Created by vahidbakhtiary - Thursday, December 1, 2011 8:42 AM | Last reply by vahidbakhtiary - Saturday, December 3, 2011 7:36 AM -
0 Votes
[SOLVED] VBScript: Dynamically Created, Sequentially Numbered Variables
' Retrieve variables For i=0 to UBound(arrList) ' Returns Variable Name ...Answered | 9 Replies | 13856 Views | Created by JuliusPIV - Thursday, September 26, 2013 3:11 PM | Last reply by monklabel78 - Friday, November 20, 2015 4:23 AM -
3 Votes
Create an array and assign it a name from a variable
Keep in mind that you create a new variable with a specific name by typing: Dim f433() As String This has to be ...Answered | 4 Replies | 737 Views | Created by skamanfrank - Monday, October 7, 2013 2:42 PM | Last reply by Reed Kimble - Thursday, October 10, 2013 3:16 PM -
0 Votes
Using a Variable as a Table Name
It's been in place this way for far to long to just change it overnight, so I am stuck adapting to the current environment with 'bandaids' to keep the antiquated ways ...Answered | 10 Replies | 2759 Views | Created by IndigoMontoya - Tuesday, April 2, 2013 7:14 PM | Last reply by IndigoMontoya - Wednesday, April 3, 2013 6:38 PM - Items 1 to 20 of 2756375 Next ›
No announcements
