Viewing 15 posts - 5,191 through 5,205 (of 8,761 total)
Very quick note, you are definitely on the right track here, the notes are all correct and accurate so far.
😎
May 25, 2015 at 2:13 pm
Luis Cazares (5/25/2015)
WITH CTE AS(
SELECT *, (ROW_NUMBER() OVER(PARTITION BY Country ORDER BY Id)+ 2) / 3 AS rowrank
...
May 25, 2015 at 2:01 pm
_simon_ (5/25/2015)
Ughhhh... An explanation, yes please 🙂
The DENSE_RANK provides an one based incremental value for each country in an alphabetical order, the ROW_NUMBER / 3 adds the value of one...
May 25, 2015 at 1:46 pm
Quick and simple solution, should be enough to get you passed this hurdle, let me know if you need any explanations.
😎
USE tempdb;
GO
SET NOCOUNT ON;
if object_id('tempdb.dbo.#Countries') is not null drop table...
May 25, 2015 at 8:03 am
Jampandu (5/24/2015)
Thank you very much sir, I'm able to write the sql script for other elements 🙂
Happy to help and thanks for the feedback.
May 24, 2015 at 11:58 pm
WhiteLotus (5/24/2015)
May 24, 2015 at 10:14 pm
audiocool (5/24/2015)
Is that Remote desktop connection ? If yes, we all login to...
May 24, 2015 at 9:43 pm
Luis Cazares (5/24/2015)
Would someone be interested on helping me to proofread an article that I'm planning to submit to SQLServerCentral? It's about while loops not being evil. 😀
I would be...
May 24, 2015 at 9:16 pm
Jeff Moden (5/24/2015)
May 24, 2015 at 8:50 pm
Jampandu (5/24/2015)
I am new to xml and confusing on preparation of a query to get the data from xml which has xmlns in first few lines.
Here I am...
May 24, 2015 at 7:07 am
mili.nikolic (5/24/2015)
May 24, 2015 at 5:02 am
mburbea (5/23/2015)
I bring up the lack of randomness as it works in the favor of delimitedsplit8k, as the optimizer can basically get to reuse its row plans.
Viewing the text...
May 23, 2015 at 3:01 pm
TheSQLGuru (5/23/2015)
This thread has become a laundry list of worst practices!! 🙂
That by itself presents an opportunity, care to do a write up?
😎
May 23, 2015 at 2:46 pm
ray_su (5/23/2015)
Eirikur Eiriksson (5/23/2015)
1. The application owner does not want to have the user enter or select a time zone.
This statement prompts the question of what the possibilities are to...
May 23, 2015 at 2:27 pm
Jacob Wilkins (5/23/2015)
.. with not testing in production, I'd be incredibly happy 🙂
+100
😎
May 23, 2015 at 1:58 pm
Viewing 15 posts - 5,191 through 5,205 (of 8,761 total)