Viewing 15 posts - 3,091 through 3,105 (of 11,678 total)
j.b.shteyn (5/13/2014)
...Thank you to everyone for your comments and suggestions!
Congrats!
May 13, 2014 at 1:58 pm
Nevyn (5/13/2014)
Steve Jones - SSC Editor (5/13/2014)
May 13, 2014 at 10:35 am
Thomas Abraham (5/13/2014)
Gary Varga (5/13/2014)
1) Graduates with Computer Science degrees have little understanding of applying what they have been taught in the real world.
2)...
May 13, 2014 at 10:26 am
How many rows do you expect?
May 13, 2014 at 10:22 am
aaron.reese (5/13/2014)
unless you crate ##temptables which are global and can be shared by different connections.
It doesn't matter if the connection that creates the temp tables is disconnected before any other...
May 13, 2014 at 7:47 am
It's the Database!!! (5/13/2014)
They might release it in November with SQL 2012 SP2.
Any resource on that?
May 13, 2014 at 7:46 am
david.irvine 7489 (5/13/2014)
Koen Verbeeck (5/5/2014)
Hany Helmy (5/3/2014)
Thomas Abraham (5/2/2014)
paul.knibbs (5/2/2014)
Bhaskar.Shetty (5/1/2014)
The good one and part of our Daily routine
Is it? I can't recall a situation where I've actually used this...
May 13, 2014 at 5:52 am
Google won't kill you.
Anyway:
Developing with Analysis Management Objects (AMO)
An example:
Managing SQL Analysis Service Objects with SSIS and AMO[/url]
Regarding package configurations:
SSAS Connection String Dynamically[/url]
What you could do is create a child...
May 13, 2014 at 3:43 am
After some googling it seems indeed SSIS has an issue with dynamic SSAS connection (how stupid).
The alternatives are using AMO in a script task or using package configurations.
May 13, 2014 at 3:34 am
Can you post an example of such a connection string?
If you would copy paste them yourself in the connection manager and you run the package, does it work?
May 13, 2014 at 3:18 am
Can you post the exact error?
May 13, 2014 at 3:02 am
Stewart "Arturius" Campbell (5/13/2014)
Koen Verbeeck (5/13/2014)
Thanks for the question, made me do some research.Has anyone used file tables in production yet?
I replaced the old IBM Doc Store application using FileTable.
About...
May 13, 2014 at 2:32 am
Gary Varga (5/13/2014)
Koen Verbeeck (5/13/2014)
The basics of SQL of...
May 13, 2014 at 12:54 am
You should be able to view the SQL statement in profiler. Or at least find a stored procedure.
May 13, 2014 at 12:53 am
SELECT MeterID, ReadingDay = CONVERT(DATE,ReadingDate), ReadingHour = HOUR(ReadingDate), SUM(Reading)
FROM
(
SELECT r.MeterId, r.ReadingDate, r.Reading
FROM MeterReading r, MeterDetail d, Building b
where r.MeterId = d.MeterId
and d.BuildingId = b.BuildingId
and b.BuildingName like '%182%'
and r.ReadingDate between '2014-01-01'and...
May 13, 2014 at 12:30 am
Viewing 15 posts - 3,091 through 3,105 (of 11,678 total)