Vil lige henlede interesserede på denne blog hvor der er et ret nyttigt SQL-script til at generere en kontinuerlig liste af datoer. Med andre ord en periodetabel. 1 with mycte as 2 ( 3 select cast(’1900-01-01′ as datetime) DateValue 4 union all 5 select DateValue + 1 6 from mycte 7 where DateValue + 1 [...]
Arkiver
- januar 2012 (1)
- juni 2011 (2)
- maj 2011 (3)
- april 2011 (2)
- marts 2011 (4)
- februar 2011 (2)
- januar 2011 (5)
- oktober 2010 (2)
- september 2010 (1)
- august 2010 (1)
- maj 2010 (2)
- januar 2010 (1)
- december 2009 (1)
- oktober 2009 (2)
- september 2009 (1)
- april 2009 (2)
- januar 2009 (1)
- december 2008 (1)
- november 2008 (2)
- august 2008 (1)
- juli 2008 (4)
- marts 2008 (1)
- februar 2008 (1)
- januar 2008 (4)
- december 2007 (5)
- november 2007 (5)
- oktober 2007 (13)
- april 2007 (1)
- marts 2007 (1)
- februar 2007 (3)
- januar 2007 (13)
- december 2006 (7)
- november 2006 (2)
- oktober 2006 (7)
- september 2006 (5)
- august 2006 (4)
Kategorier
- Blandet (41)
- Familien (1)
- Kaffe (9)
- Musik (5)
- Programmering (50)
- Rollespil (6)
- The Who (3)
- Uncategorized (1)
| m | ti | o | to | f | l | s |
|---|---|---|---|---|---|---|
| « jan | ||||||
| 1 | 2 | 3 | ||||
| 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 11 | 12 | 13 | 14 | 15 | 16 | 17 |
| 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| 25 | 26 | 27 | 28 | 29 | 30 | |
Tags
.Net
3rd. ed.
Business Intelligence
Bønner
C#
Certificering
computer
D&D
DateTime
Espresso
Fejl
Format
Humor
Kaffe
Kværn
kølesystem
MCP
MDX
NFL
Pittsburgh Steelers
Plader
politik
Pro Bowl
Reg Barber
Rollespil
Roskilde Festival
Sketch
SQL
SQL Server
SQL Server 2005
SQL Server 2008
SSAS
SSIS
SSIS 2008
SSRS
Support
T-SQL
The Who
Tom Brady
vandkøling
Vinyl
Visual Studio
VS2008
VS2010
vvs
Blogroll
- Charlie Maitland
- Christoffer Webb
- Denny Lee
- Don Box
- Eugene Asahara
- Hitachi Consulting
- Jamie Thomson
- Lorents Nord-Varhaug
- Marco Russo
- Mark Garner
- Mike Taulty
- Mike Woodring
- Mosha Pasumansky
- MSDN Forum: SSAS
- Paul Randal
- Rico Mariani
- SQL Team.com
- Teo Lachev
- Tips n Tricks SQL Server QPT
- Will Riley
- Worse Than Failure
Blog Stats
- 6,919 hits
- @Technitrain That would be do-able. I have created the individual methods, each with a specific signature matching the num of vars #SSASHELP 3 hours ago
- @Technitrain I needed to create a "lookup" method for the underlying datamart. The reports have diff. number of search parameters. #SSASHELP 3 hours ago
- @Technitrain I have a solution running, not pretty though. I need to pass variables from SSRS and search attributes on dimensions, hence 1/2 3 hours ago
- @Technitrain Not quite what I'm after... I was kinda hoping I could call a custom method with params, see bit.ly/KFIjyQ #SSASHELP 3 hours ago
- @Technitrain msdn says: "A valid Multidimensional Expressions (MDX) expression that returns a set.", can that pass as a string? #SSASHELP 3 hours ago
Blog på WordPress.com. Theme: Spring Loaded by the449.
