Viewing 15 posts - 16 through 30 (of 109 total)
Thanks Jeff,
You're very thorough.
This is very inciteful, and duly noted.
Thanks
March 7, 2022 at 9:52 am
Hi Phil,
The following did the job perfectly well
update #tmpTable
set LAST_MODIFICATION_DT = format(LAST_MOD_DATE, '0000"-"00"-"00" "') + format(LAST_MOD_TIME, '00":"00":"00')
March 6, 2022 at 4:42 pm
Hi Phil,
Thanks for getting in touch.
I was hoping this could simply be achieved by doing a simple concatenation of the two fields and placing the results in the LAST_MODIFICATION_DT column.
This...
March 6, 2022 at 1:42 pm
Community,
I should mention that the LAST_MODIFICATION_DT will be a datetime2 field as opposed the what you see as VARCHAR(255)
March 6, 2022 at 1:31 pm
Hi Phil,
You have once again come through.
Thanks man
February 3, 2022 at 9:31 pm
Hi Phil,
That would be great.
You can forget about the TABLE_CATALOG
The ordinal_position represents the place a column appears in a table, which we can forget as I'm trying to work with...
February 3, 2022 at 6:31 pm
Hi Phil,
I have the tables and columns that I would like to extract, see attached. Ideally, I would like the tables to extracted as individual CSVs.
This request might need someone...
February 3, 2022 at 4:12 pm
Ratpak
Do you want the data flattened (in which case you'll get lots of duplicates at higher levels)? Do you want to return multiple results sets of more normalized data?
Are...
February 3, 2022 at 3:34 pm
ratbak
Sorry for the delayed response
What do you want to return and how? Do you want the data flattened (in which case you'll get lots of duplicates at higher levels)? Do...
February 3, 2022 at 3:27 pm
Once again, I'm being a numbty - I think you make me nervous hahahahahah
Anyway, I see you've just selected Name and Description for my benefit, as it's not in the...
February 3, 2022 at 2:03 pm
Hey Phil,
Thanks for reaching out.
My apologies for not be clear.
I copied and pasted your modified code in my dbForge SQL application and I got the following results:
This...
February 3, 2022 at 1:58 pm
Thanks Scott, much appreciated. Saved me a lot of time and effort
October 29, 2021 at 7:41 pm
Any thoughts from anyone else regarding the error from this query provided by Kevin?
October 7, 2021 at 1:25 pm
Viewing 15 posts - 16 through 30 (of 109 total)