Viewing 15 posts - 1,336 through 1,350 (of 4,086 total)
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 22, 2018 at 7:38 am
WITH
Duplicates
AS
(
SELECT [Policy]
FROM Insurance
GROUP BY [Policy]
HAVING...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 22, 2018 at 7:17 am
There are a couple of ways that you can handle this depending on what you want to do with the results. Probably the most common is to use a CTE...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 19, 2018 at 2:58 pm
Assuming that you have no future dates, you only need to find the begin date and then filter based on that.
DECLARE @pStartDate SMALLDATETIME
SET @pStartDate =...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 19, 2018 at 1:31 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 19, 2018 at 12:35 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 19, 2018 at 11:57 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 19, 2018 at 10:19 am
Thank you for your quick response on the query and efforts. As shown in...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 19, 2018 at 8:48 am
It comes from the CROSS APPLY. I did not alter the underlying tables, if that's what you mean.
Make sure that you thoroughly understand this code before deploying it,...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 18, 2018 at 3:03 pm
This forum is primarily English. (Türkçe bilmiyoruz.) You'd get much more of a response if you can post in English.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 18, 2018 at 2:28 pm
This is close. Your expected results don't seem to match your description. Specifically rows 40-42 should be in the same group based on "Group continues as long as SkipPrintCompLine= ‘Y’",...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 18, 2018 at 2:14 pm
First, we need both sample data AND expected results. You've only provided half.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 18, 2018 at 12:53 pm
Most people here aren't going to open a zip file posted on the internet. I suggest that you resubmit your data as outlined in the first link in my signature. J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 18, 2018 at 9:51 am
Use a string splitter on both the table field and the parameter, and then use an equality comparison.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 16, 2018 at 3:03 pm
print CONVERT(VARCHAR(3), ASCII('≡')) +...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 16, 2018 at 2:21 pm
Viewing 15 posts - 1,336 through 1,350 (of 4,086 total)