Viewing 15 posts - 1,936 through 1,950 (of 4,087 total)
You can do this in T-SQL, but it gets complicated very quickly. I would recommend that you use a reporting tool such as SSRS to produce these kinds of reports.
January 30, 2017 at 11:29 am
Unless I'm missing something, it's very simple.
SELECT *
FROM #T
WHERE PrescriptionID < DuplicatePrescriptionID
Drew
January 30, 2017 at 11:11 am
Please use the SQL Code tags when posting SQL Code. SQL Code is much easier to read when proper indentation is used, and the SQL Code tags preserve that indentation....
January 26, 2017 at 4:20 pm
Here is a solution using LAG.
BEGIN TRY
SELECT *
INTO #mytable
FROM (
VALUES
(1, CAST('2/26/2015 5:58' AS DATETIME), 'test1', 'test1',...
January 26, 2017 at 1:33 pm
ROW_NUMBER(), RANK(), and DENSE_RANK() produce a monotonically increasing series within a partition with respect to the ORDER BY expressions. That is, if your sort by partition expressions and then the...
January 26, 2017 at 1:21 pm
In t-sql 2012, each of the sqls listed separately below work fine. However I
would...
January 26, 2017 at 11:38 am
kdbarrett 88655 - Thursday, January 26, 2017 9:29 AMSo it's not an "error"; the file processes, it just doesn't get a match.
You...
January 26, 2017 at 11:06 am
When posting sample data and expected results, they must MATCH. Your sample data contains two trade names: 'Alhidd Cold Store' and 'Store', and your expected results contain five names which...
January 25, 2017 at 3:47 pm
Viewing 15 posts - 1,936 through 1,950 (of 4,087 total)