Viewing 15 posts - 1 through 15 (of 191 total)
When I run Scott's code, I get this error msg?
Msg 156, Level 15, State 1, Line 6
Incorrect syntax near the keyword 'RowCount'.
Msg 156, Level 15, State 1, Line 8
February 24, 2020 at 6:28 pm
This is a sample of the data:
--===== If the test table already exists, drop it IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL ...
February 24, 2020 at 4:18 pm
Jonathan, This works great! thanks!
February 16, 2020 at 1:41 am
I think it works better with the pivot because I am joining it to create a new table...
Into POInfo From MeritusMmPO as PO Left Join MeritusMmPOLines as...
February 14, 2020 at 9:42 pm
This is the input data:
This is what I would like it to look like:
February 14, 2020 at 8:58 pm
I have a separate related issue now.
The data looks like this
When I run this code:
Select SourceID, PurchaseOrderID, ...
February 14, 2020 at 8:46 pm
I found my own answer! I had an issue with the ID column. Fixed that and issue resolved.
February 11, 2020 at 12:35 pm
What format are the dates in? datetime (12/29/2019 00:00:00)
How would you know which columns to interrogate? I don't, I'm thinking any column that contains a "/" in it as a...
February 3, 2020 at 9:25 pm
Jeff, that would be the best case scenario, but we get many clients that give to us as is and don't want to do more. It is in excel and...
January 31, 2020 at 2:09 pm
looks like I have some data too large to convert to numeric because I am getting this error:
Invoice = coalesce(cast(cast(try_cast([Vendor invoice] As float) As numeric(38,0)) As varchar(50)), [Vendor invoice]),
January 30, 2020 at 11:48 pm
The issue is, it doesn't work.
I get this error:
Arithmetic overflow error converting float to data type numeric.
When I try this line below:
Case When [Vendor invoice] Like '%E+%' Then Cast(Convert(numeric(24,0), Cast([Vendor...
January 30, 2020 at 7:58 pm
Phil, those are excluded from conversion...I'm just showing what is in the data. The only ones that would be converted would be the numbers with E+ in it. This also...
January 30, 2020 at 7:29 pm
The original column is a varchar type. I want to convert the scientific number to a number without scientific notation (i.e. 38784939843) and I want the value to remain in...
January 30, 2020 at 6:18 pm
SQLian and Thom, Thank you! both. I wish i could set both to the answer but it only lets me set 1 of them. I've learned something from both of...
November 29, 2019 at 2:01 pm
Thanks for getting me 99% therre, but I'm not getting the list of the field names, just 1 field name appears in the list on the insert and select side. ...
November 29, 2019 at 3:15 am