Viewing 15 posts - 421 through 435 (of 8,731 total)
July 13, 2018 at 1:02 pm
Here's a sample on how to do it, but it needs to be done using cross tabs instead of PIVOT to avoid performance issues.
SELECT eas.emp_name,
...
July 13, 2018 at 10:36 am
July 12, 2018 at 3:10 pm
Why are you grouping by VendorPrefix?
July 12, 2018 at 1:57 pm
It should be noted, that there's no way to guarantee the order of the rows and therefor the correct assignment of the pairs. At least with the data shown on...
July 11, 2018 at 1:52 pm
sgmunson - Wednesday, July 11, 2018 9:45 AMGiven that the source data contains an ordering mechanism, using ROW_NUMBER() isn't actually needed here:
I...
July 11, 2018 at 9:57 am
July 9, 2018 at 10:49 am
The easiest way is to create a new CTE.
WITH S AS (
SELECT DISTINCT
m.item_id AS 'Old'
, m2.item_id AS 'Sub'
July 5, 2018 at 12:13 pm
vsamantha35 - Thursday, July 5, 2018 9:59 AMIts the same parameters. still ssms was not showing up this errors.
It's not about the...
July 5, 2018 at 10:04 am
Louis, one thing I didnt understand , you mentioned
"The simplest thing that comes...
July 5, 2018 at 8:50 am
July 5, 2018 at 8:35 am
Hi All,
Need some tips to troubleshoot below issue. we are seeing below error...
July 5, 2018 at 7:09 am
This helped me a lot to better understand locking in SQL Server. Maybe it can solve some of your questions.
Locking in Microsoft SQL Server (Table of Content)...
July 3, 2018 at 1:33 pm
Have you tried using EXCEPT?
July 2, 2018 at 6:29 am
Viewing 15 posts - 421 through 435 (of 8,731 total)