Viewing 15 posts - 1,111 through 1,125 (of 1,245 total)
As John pointed out earlier, this really is a display function and may best be handled in the from end app or in reporting software.
If you'd like to take that...
July 7, 2015 at 3:25 pm
Just so you know... The DelimitedSplit8K that Gail referenced is a super fast string splitting function written by Jeff Moden. You can find the code for it here... Tally OH!...
July 2, 2015 at 5:12 pm
sratemo (7/2/2015)
Your solution looks solid but the query wouldn't execute past:
"MAX(adg.AdminDateGroup) OVER (PARTITION BY adg.PatientID ORDER BY adg.AdmissionDate) AS AdminDateGroup".
error - Incorrect syntax near 'order'.
Tried going...
July 2, 2015 at 11:43 am
OLSONEJ (7/1/2015)
Wouldn't you know that since the ROWS was giving me a red line I removed that part but it still did not like it 🙂
The word "ROWS" or "ROWS...
July 1, 2015 at 2:44 pm
Sean Lange (7/1/2015)
OLSONEJ (7/1/2015)
My editor is not liking the Rows or the order by part. I am trying to run this as query.
The query that was posted will not...
July 1, 2015 at 2:07 pm
You can try this as well...
IF OBJECT_ID('tempdb..#temp') IS NOT NULL
DROP TABLE #temp;
CREATE TABLE #temp (
ID INT NOT NULL,
[Date] DATE NOT NULL
);
INSERT #temp (ID, [Date]) VALUES
(1, '2000-05-03'),
(1, '2001-06-10'),
(1, '2014-04-02'),
(1,...
July 1, 2015 at 11:44 am
shpida (6/30/2015)
where would I get a few sample free form text rows, between about 50-100 text rows? possibly as people arguing about a game or something like that?
I'm not...
June 30, 2015 at 6:13 pm
Out of curiosity, what is stage_viasatsubscription? A base table or a view? Why would it have 95,0000+ rows for any singe viasatsubscriptionid?
June 30, 2015 at 5:06 pm
I definitely misspoke when I said key lookups are bad as a blanket statement. So, please accept my apology for that.
That said, they are one of the operators that I...
June 30, 2015 at 2:28 pm
Tac11 (6/30/2015)
select object_name(id) as tablename, name, indid from sysindexes
where object_name(id) = 'SalesOrderDetail'
It give me:
SalesOrderDetail---------ix_SalesOrderIdDetailId ------1 (clustered index)
I didn't understand why execution plan suggesting...
June 30, 2015 at 1:47 pm
First... Let me say that I agree 100% with Lowel's & ZZartin's comments. I think what you're attempting is a bad idea...
That said, none of us work where you work...
June 30, 2015 at 11:59 am
GilaMonster (6/30/2015)
Tac11 (6/30/2015)
Now I get on execution plan with 'key lookup', 'nested loop' operator, which I think are bad.
No they're not. There are no bad operators, if there were they...
June 30, 2015 at 11:19 am
What if we were to add "(1, '2006-10-05')," to the data set?
That would produce the following fiscal years for ID #1...
ID ...
June 30, 2015 at 10:53 am
Tac11 (6/30/2015)
Great!!! Hat's off to you.
Glad to help. 🙂
June 30, 2015 at 9:20 am
Nothing in the code jumps out as being the cause of the problem. What is the actual data type of salesdate?
June 30, 2015 at 9:01 am
Viewing 15 posts - 1,111 through 1,125 (of 1,245 total)