Viewing 15 posts - 1 through 15 (of 15 total)
Further Explanation: The problem is that cde_value is a reference column so values in that column can be anything. The cde_variable determines what the cde_value means. For...
January 21, 2016 at 10:20 am
--===== If the test table already exists, drop it
IF OBJECT_ID('TempDB..#Student','U') IS NOT NULL
DROP TABLE #Student
--===== Create...
January 21, 2016 at 10:06 am
I apologize for posting on both forums but after posting on this forum -SQL Server 2008 General, it seemed more fitting a question for the T-SQL forum. On a...
January 21, 2016 at 9:40 am
That was perfect! Thank you.
August 18, 2014 at 1:27 pm
Thanks Chris and everyone for your responses. I have implemented a for each loop with a dummy script task to be able to set a constraint to check for...
October 6, 2012 at 11:43 am
What makes the 2 foreach loop faster in processing that the other way?
September 26, 2012 at 7:35 am
The file actually contains the same information. The excel file is manual entries. So the information will go into the same table.
September 26, 2012 at 7:34 am
I think the issue that I'm having is how to use multiple sets of parameters. For example in C# i would have an array and say foreach "set of firstname,...
September 10, 2012 at 6:53 am
Ok I wanted to post this so anyone else with this problem can be helped. What I did was take a bit of logic from Phil and Lowell. ...
May 24, 2010 at 11:33 am
I have added the checking, but if the String is null and I make it's value "" will it be the width of the column defined in the database or...
May 17, 2010 at 1:16 pm
This is what I am using so far. I hoped to add code that says if this array(i) is = to DBNUll then add the number of needed...
May 17, 2010 at 9:30 am
The widths are fixed but each field has a different width I do not know as I am looping through which field will be null. It could be...
May 17, 2010 at 9:08 am
This is awesome code! Thanks Lowell. I am trying to get the understanding as to how the caption gives the length of the field. Thanks
May 17, 2010 at 8:11 am
Yes if it came in as a string filled with the number of spaces to match the fixed width for the field that would be fine. Thanks Phil
May 17, 2010 at 8:09 am
Thanks for your response. The script task does do everything and it does know the lengths of the fields except when the DB returns DBNull as a value. ...
May 15, 2010 at 7:12 am
Viewing 15 posts - 1 through 15 (of 15 total)