Viewing 15 posts - 3,871 through 3,885 (of 11,678 total)
You can use GROUPING or GROUPING_ID to check if a row is a detail row or a total.
January 22, 2014 at 12:17 am
sql_ques (1/21/2014)
NULLNULLNULLNULL 646AprilNULLNULLNULL60
AprilAgricultural NULLNULL1
AprilAgricultural LIVENULL1
AprilAgricultural LIVEWeb1
AprilDatabaseNULLNULL1
AprilDatabaseLIVENULL1
And how exactly would you like to go from this result set to the other? They have almost nothing in common.
January 21, 2014 at 7:44 am
It would be helpful if you showed us what this query returns and what your desired result is.
January 21, 2014 at 4:18 am
What if you run the wizard as administrator?
January 21, 2014 at 2:19 am
There are two options:
* just add extra columns to store the different catagories. Easiest solution by far, but the least flexible.
* snowflake to a category dimension and add a bridge...
January 21, 2014 at 1:02 am
SQL_Surfer (1/20/2014)
January 20, 2014 at 3:01 pm
Jeff Moden (1/19/2014)
For me, you just added more reasons to the list of reasons why I don't like SSIS. 😉
That statement is not justified at all.
Why don't you like SSIS...
January 20, 2014 at 1:50 pm
sneumersky (1/20/2014)
Hopefully, the initial forum poster got the answers he/she was seeking, and my apologies to Koen for adding my $.02 when I probably did not need to 🙂
No problem...
January 20, 2014 at 1:47 pm
nonghead-webspam (1/17/2014)
January 19, 2014 at 5:52 am
blasto_max (1/17/2014)
Koen Verbeeck (1/17/2014)
Each time a connection manager is used by an SSIS component, a new connection is created.
If you...
January 19, 2014 at 5:51 am
The information messages are normal, that's just the native client version number being upgraded in the connection strings.
The errors mean you have a protection level with a password, set it...
January 19, 2014 at 5:49 am
JimbobsQL (1/17/2014)
Koen Verbeeck (1/17/2014)
There are probably other methods, as usual.This one was the first I could come up with.
Cracking effort, much better than my first attempt!
I already had your query...
January 17, 2014 at 7:30 am
Viewing 15 posts - 3,871 through 3,885 (of 11,678 total)