Spitting

Jim1234 (5/25/2015)

---

Hi,

When I'm trying to connect to a tabular cube via Power Pivot in Excel 2010, I'm getting an error

"The following system error occurred: A connection attempt failed because the...

adam.mesny (5/25/2015)

---

I have received MySQL error 1160 'error writing communication packets'. I have a stored procedure that does this: step 1: compares the data from two tables and insert into...

Jason A. Long (5/25/2015)

---

If you're getting into windowed functions in SQL 2012, I'd encourage to to also included "Window Frames" in your study.

Windowed functions are an extremely powerful feature, and...

Quick single scan solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

WITH XSAMPLE(book, position) AS

(SELECT * FROM (VALUES

('A', 500)

,('B',-500)

,('C',-500)

) AS X(book,...

simon.harvey 41170 (5/25/2015)

---

Too true - I got the impression that even the SAAS costs...

TheSQLGuru (5/25/2015)

---

Nope, sorry. I don't like...

Very quick note, you are definitely on the right track here, the notes are all correct and accurate so far.

😎

Luis Cazares (5/25/2015)

---

This might be simpler to understand.

WITH CTE AS(

SELECT *, (ROW_NUMBER() OVER(PARTITION BY Country ORDER BY Id)+ 2) / 3 AS rowrank

...

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...

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...

Happy to help and thanks for the feedback.

The Stairway to XML[/url] is excellent...

WhiteLotus (5/24/2015)

---

My team said that even if We don’t set up the maximum memory setting in DEDICATED SQL server , SQL will adjust memory usage dynamically and always leave 1...

audiocool (5/24/2015)

---

Oh ya, you guys is always talking about RDP. What is the RDP you guys talking about ?

Is that Remote desktop connection ? If yes, we all login to...

I would be...