Viewing 15 posts - 4,351 through 4,365 (of 8,754 total)
Another quick solution
😎
SELECT
MIN(T.hierarchyid) AS [hierarchyid]
,T.hierarchyval
FROM #test T
GROUP BY T.hierarchyval;
The two solutions posted are close in performance or rather lack there of,...
October 16, 2015 at 11:04 pm
GilaMonster (10/15/2015)
Oh, and the bloody desktop booted clean to windows on the first try tonight and is behaving itself...
Did you just upgrade to Windows 10?
😎
October 16, 2015 at 12:37 am
My suggestion is somewhat different to the previous ones
😎
1) Safety measures first, Backup the database with verify etc.
2) Create a new file group, add a new data file to it...
October 16, 2015 at 12:28 am
Further on Luis's post, the NULL represents unknown or missing, in the realm of financial transactions that concept is somewhat irrelevant, unknown payment is equivalent of a 0 payment, if...
October 15, 2015 at 1:16 pm
GilaMonster (10/15/2015)
BL0B_EATER (10/15/2015)
October 15, 2015 at 12:22 pm
There is nothing wrong with this DDL, works perfectly. Just a hunch, have you run DBCC CHECKDB on that database recently? Also is this script generated from the table set...
October 15, 2015 at 12:52 am
christophe.bernard 47659 (10/14/2015)
thanks for your time that's exactly what i want ..and now that's work ..
I don't know why the property of this object is...
October 14, 2015 at 3:59 am
g.britton (10/13/2015)
Shouldn't your example output be:1 0 Apple
4 2 Apple
8 3 Apple
Guess it's "before and including"
😎
October 13, 2015 at 1:50 pm
jeffrey.sharp (10/13/2015)
Product_ID identity 1,1
Product_Purchased varchar(25)
1 Apple
2 Pear
3 Banana
4 Apple
5 ...
October 13, 2015 at 1:49 pm
arrjay (10/13/2015)
Hi there - For SQL Standard edition, would I need multiple licenses if I created multiple named instances on the same physical or virtual server?Thanks, Russell.
Quick answer is that...
October 13, 2015 at 1:29 pm
Quick thought, change the data type from datetime to datetime2, the value is out of range for the former.
😎
October 13, 2015 at 9:51 am
Quick question, have you considered turning on compression on those tables and indices, most likely more effective and almost no risk involved.
😎
October 13, 2015 at 1:48 am
ChrisM@Work (10/12/2015)
October 12, 2015 at 12:27 pm
eklavu (10/12/2015)
I'am having an issue fetching Chinese characters in a XML data type. It return questions mark (?).
Would you be able to advise me? TIA.
Below is the sample script.
DECLARE...
October 12, 2015 at 12:20 pm
Viewing 15 posts - 4,351 through 4,365 (of 8,754 total)