Viewing 15 posts - 1,141 through 1,155 (of 4,087 total)
And some people wonder why they never got a response: Vague Question: Complex Topic
Drew
July 13, 2018 at 12:31 pm
Yeah. My thoughts are that you've been around long enough to know that that's not the way things work around here.
Database design is too complex a topic for...
July 13, 2018 at 12:15 pm
SELECT SERIALNUMBER, [DOB] , [FULLNAME]
FROM CONTACT
CROSS APPLY( VALUES(CONVERT(VARCHAR
July 13, 2018 at 8:47 am
July 13, 2018 at 7:01 am
July 12, 2018 at 9:28 am
July 11, 2018 at 9:26 am
July 10, 2018 at 2:50 pm
Instead of having to enter the same formula multiple times, I used the CROSS APPLY to create a field that I could use instead.
I also changed your query...
July 10, 2018 at 2:46 pm
Diyas - Tuesday, July 10, 2018 2:10 PMpp source table -->select id,PPID,Name,Create_Date,Modified_Date, isactive from A.PP
pp_old destination table.--> select id,PPID,Name,Create_Date,Modified_Date, isactive from A.PP_old
With >...
July 10, 2018 at 2:27 pm
July 10, 2018 at 1:41 pm
July 10, 2018 at 12:58 pm
July 10, 2018 at 12:08 pm
So, what is the difference between:StartDate >= '2018-01-01' AND EndDate IS...
July 10, 2018 at 10:27 am
July 10, 2018 at 9:34 am
Also, it helps to know if you want to include hours where there is no data. That would require a different approach to fill in the hours missing data.
July 10, 2018 at 9:13 am
Viewing 15 posts - 1,141 through 1,155 (of 4,087 total)