Viewing 15 posts - 1,081 through 1,095 (of 4,087 total)
There's no need for a dynamic query here, since you are limited in the number of address lines you can have. I also replaced your PIVOT with a CROSSTAB, because it's...
August 1, 2018 at 12:06 pm
August 1, 2018 at 8:23 am
There are 11 possible relationships between two intervals, requiring at least 22 rows to represent completely. You have provided less than a quarter of the minimum to adequately test anything.
July 31, 2018 at 3:32 pm
Yes, do an "UNPIVOT" first. I'm using CROSS APPLY to do the "UNPIVOT".
SELECT...
July 31, 2018 at 3:23 pm
July 31, 2018 at 3:09 pm
July 31, 2018 at 2:24 pm
Just filter out records with a NULL before doing your crosstab. And do you really have strings that contain the word NULL rather than NULL values?
July 31, 2018 at 1:41 pm
I have taken over a departured colleague's work, one of the script she left...
July 31, 2018 at 12:32 pm
Please post sample data and expected results. Follow the first link in my signature for details.
NOTE: Views cannot use dynamic SQL.
Drew
July 31, 2018 at 11:15 am
You asked this same exact question last month.
Drew
July 31, 2018 at 9:19 am
sanket.wagh7689 - Tuesday, July 31, 2018 1:39 AMI have attached the expected output.
Most people won't open an Excel file posted by a...
July 31, 2018 at 9:14 am
first few...
July 31, 2018 at 7:25 am
SELECT
.T.Part
,[COMPOSITE_PART]
,[ELIGIBILITY]
,[EFFECTIVE_FROM]
,[HTS_NUMBER]
,[CREATED_DATE]
,[HTS_DESCRIPTION]
,[PREF_PROGRAM_CODE]
,[COUNTRY_ORIGIN]
,[PTNR_SITE_ID]
FROM...
July 30, 2018 at 3:34 pm
Check out this blog on Working with Precedence Constraints, specifically the section on Defining Workflow by Expressions.
Also, the conditions are mutually exclusive, so you only need...
July 30, 2018 at 1:36 pm
Viewing 15 posts - 1,081 through 1,095 (of 4,087 total)