Viewing 15 posts - 1 through 15 (of 120 total)
That worked perfectly! Thank you so much!!!
Jordon
May 20, 2020 at 1:33 pm
Thanks so much. I'm feeding this data into a line chart, so if each user doesn't have a record for each month, then they won't show up on the line...
May 20, 2020 at 6:23 am
Thank you both so much for your help! I'm now able to break out this json string!!!
Jordon
May 15, 2020 at 5:04 pm
February 1, 2017 at 7:15 pm
Thank you both for your help! Worked perfectly!!!
Jordon
May 20, 2015 at 1:41 pm
Eirikur Eiriksson (5/20/2015)
Just realized that the target data type must be DATETIMEOFFSET, otherwise it will throw errors in any conversion😎
USE tempdb;GO
SET NOCOUNT ON;
DECLARE @MY_TIME VARCHAR(100) = '2015-01-16T16:06:14.577-06:00';
SELECT CONVERT(DATETIMEOFFSET,@MY_TIME,127)
That didn't throw...
May 20, 2015 at 1:34 pm
I did. In one of my queries above, I have specified 127 and I still got an error.
May 20, 2015 at 1:25 pm
Thank you both so much! I greatly appreciate your help!!!
November 5, 2014 at 7:54 am
Okay, here is a more real life example of what I'm trying to accomplish. Here is my query:
SELECT C.BASEDPTH, C.OWN, C.SEGLEN, C.SURFWID, C.UNITID, S.DESCRIPT, C.STKEY
FROM ASSETMANAGEMENT_STREET.COMPSEG C
INNER JOIN ASSETMANAGEMENT_STREET.STREET...
November 4, 2014 at 10:30 pm
Sorry, I was on my phone when I posted that. This is what the table and data looks like:
[ID],[Description],[Ownership],[Total]
'1','Fred','Full','100'
'2','George','Full','100'
'3','George','Part','50',
'4','Bob','Full','100'
So, when I query this data, I want to pull all...
November 4, 2014 at 6:38 pm
Thank you all for your help. I'm now good to go!
Thanks,
Jordon
March 31, 2014 at 9:49 pm
Eirikur Eiriksson (3/31/2014)
This is a case of premature exclusion, nothing to worry about 😀
Dang, I hate when that happens 🙂
I'll check this out and let you know if I run...
March 31, 2014 at 1:50 am
Eirikur Eiriksson (3/30/2014)
Could you supply a DDL with a sample records and the expected results?
I'm not on my DB server right now; however, it's a simple setup. I have...
March 30, 2014 at 11:27 pm
Quick note, be careful not to use reserved keywords in this manner, that is the alias for INSPECTION being IS.
SELECT INS.INSPNO, CNT.FIRSTNAME, CNT.LASTNAME
FROM INSPECTION INS
INNER JOIN INSPECTIONCONTACT CNT
ON INS.INSPNO =...
March 30, 2014 at 11:03 pm
Viewing 15 posts - 1 through 15 (of 120 total)