Viewing 15 posts - 31 through 45 (of 167 total)
I GOT IT, I figured it out, Thank you very much, I am very appreciative for your assistance.
February 13, 2020 at 6:59 pm
Awesome, Thank you I got a successful connection, now if you don't mind I am trying to bring the raw data into SQL, task>import data, what is a good way...
February 13, 2020 at 6:47 pm
So install it on the AS400 machine? I am running SQL from my local machine, as a development box until I show proof of concept, So I am trying to...
February 13, 2020 at 5:01 pm
I am getting the command from sysjobsteps (p.command), I am just trying to parse the command to get the specific ones I'm looking for, which some of them seem to...
February 25, 2019 at 1:14 pm
I am definitely sure, I am trying to get the jobs that call the stored procedures, here is how I am trying to get the job and the stored procedure(s)...
February 25, 2019 at 12:49 pm
And just to be clear I'm not using AdventureWorks, I am using my database. Accounts
February 25, 2019 at 11:39 am
I just had to change VARCHAR(25) to NVARCHAR(50) and it returned the full name,
,
July 27, 2017 at 9:19 am
Thank You for your assistance, with a little tweaking I think I can get the description new, It is only returning the first letter, "T", but if all else fails...
July 27, 2017 at 8:00 am
This works, other then Item Number being an INTEGER because there are Item Numbers that have Alpha characters in them.
July 27, 2017 at 7:41 am
I don't have the script for inserting into the final table yet, that is why I need this data to be like SELECT * FROM [TONYS_20170417],...
July 25, 2017 at 12:39 pm
So do I need to turn all blank fields to NULLS? Because it seems to work other than my fields have blanks and you inserted NULLS into the blank fields....
July 25, 2017 at 12:24 pm
That is what is in the file attached. Or are you meaning write the script to insert it into the table?
July 25, 2017 at 9:45 am
Viewing 15 posts - 31 through 45 (of 167 total)