Viewing 15 posts - 31 through 45 (of 110 total)
Hi Steve,
Would this just need to be creating the measure group in SSDT? If you're creating a warehouse and then populating it with data, before creating a new cube in...
April 11, 2014 at 7:32 am
Hi,
HanShi is totally right.. After reading that article you'll end up with a query like the below:
DECLARE @Sample TABLE
(
Id INT,
Value VARCHAR(200)
)
INSERT INTO @Sample (Id,Value) VALUES (1,'aaa,bbb'),(2,'ccc,ddd'),(3,'aab')
SELECT s.Id, item.Item
FROM @Sample s
CROSS...
March 14, 2014 at 9:15 am
Agreed Koen.. I looked over the topics and it's mostly stuff that I do day to day as a BI developer..
March 5, 2014 at 6:40 am
Hi,
I'm looking at doing the same, have a look at this article for some reading pointers:
http://byobi.com/blog/2013/04/passed-70-466-and-70-467-exams-study-guides/
Cheers,
Jim.
March 5, 2014 at 6:03 am
Seconded Eirikur. SQL Sentry's plan explorer is a great tool. You can export your plans by following the steps in this article and then open them with plan explorer. Obviously...
February 20, 2014 at 5:12 am
kalyan.ch (1/21/2014)
I agree.The normalised table design is what am looking for.
Here's a start for one of the tables. You'd need to do the same for the rest of the tables...
January 21, 2014 at 8:45 am
Sean Lange (1/21/2014)
I would import this into a staging table and then parse it out into properly normalized tables.
Agreed. Looks like for each distinct row type in the spreadsheet you'd...
January 21, 2014 at 8:36 am
So you want to be able to load data straight out of Excel and into the tables?
January 21, 2014 at 3:28 am
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!
January 17, 2014 at 7:04 am
Hi Lynn,
Each day we're going to run an SSRS report to pull out all sales after the 1st of April. So no matter what GETDATE() returns we need to be...
January 17, 2014 at 7:03 am
Koen Verbeeck (1/17/2014)
Since you are using IIF I can safely assume the code is for SQL 2012 or later 🙂
DECLARE @Date DATE = '20130217'
SELECT IIF(MONTH(@Date) <= 3, DATEFROMPARTS(YEAR(@Date)-1,4,1),DATEFROMPARTS(YEAR(@Date),4,1));
Yep, it's 2012,...
January 17, 2014 at 3:58 am
Hi,
Hopefully the below solves your problem. Without any dummy data this took me about half an hour to put together. To make things easier in future can you put together...
January 13, 2014 at 10:42 am
Exceptionally well written! Explains use case and reasons for choosing the technology in what seems to be a very easy to follow way.
Great article!
January 13, 2014 at 10:09 am
Hi there,
Why can't you use a MERGE procedure? So load your delta data into your staging table and then use a merge stored procedure to add the delta value to...
January 10, 2014 at 8:28 am
Here's a script that will return the ID closest to 75% and 95% through the table when searching by an ordered key between 1 and 4000. This can be used...
December 5, 2013 at 9:52 am
Viewing 15 posts - 31 through 45 (of 110 total)