Click here to Skip to main content
15,867,308 members
Home / Discussions / Database
   

Database

 
NewsMessage Closed Pin
5-Oct-07 7:51
SQL Gurus5-Oct-07 7:51 
GeneralRe: SQL Server Community Launched Pin
Dave Kreskowiak5-Oct-07 10:40
mveDave Kreskowiak5-Oct-07 10:40 
GeneralRe: SQL Server Community Launched Pin
Christian Graus5-Oct-07 23:55
protectorChristian Graus5-Oct-07 23:55 
GeneralRe: SQL Server Community Launched Pin
Dave Kreskowiak6-Oct-07 2:48
mveDave Kreskowiak6-Oct-07 2:48 
GeneralRe: SQL Server Community Launched Pin
Pete O'Hanlon7-Oct-07 11:12
subeditorPete O'Hanlon7-Oct-07 11:12 
GeneralRe: SQL Server Community Launched Pin
Paul Conrad7-Oct-07 11:07
professionalPaul Conrad7-Oct-07 11:07 
QuestionAssigning the value from a QueryDef object... Pin
new_phoenix5-Oct-07 6:21
new_phoenix5-Oct-07 6:21 
Questionneed to use CrossJoin, and find differnece in Columns Pin
The Don Man5-Oct-07 6:13
The Don Man5-Oct-07 6:13 
I am using a CrossJion for Present the values for a few selected columns base on there [Post Date] Dimension, I also need to present the difference between these columns from [Post Date] to [Post Date].Lag(1): Any suggestions??

Code

SELECT DISTINCT({CrossJoin({[Post Date].[^@BINAV_Param_Date_priormonth@^] , [Post Date].[^@BINAV_Param_Date_priormonth@^].Lag(1)},{[Measures].[Current Balance],[Measures].[Weighted AVG Interest Rate],[Measures].[Average Balance]})
}) ON COLUMNS,
NON EMPTY DISTINCT ({[Product].[Time Deposit]}) ON ROWS



Thank You,
Don

QuestionDescription for various tables elements Pin
Brendan Vogt5-Oct-07 6:09
Brendan Vogt5-Oct-07 6:09 
AnswerRe: Description for various tables elements Pin
Jwalant Natvarlal Soneji7-Oct-07 21:36
Jwalant Natvarlal Soneji7-Oct-07 21:36 
QuestionStored Procedures Pin
kibromg5-Oct-07 4:12
kibromg5-Oct-07 4:12 
AnswerRe: Stored Procedures Pin
Michael Potter5-Oct-07 4:39
Michael Potter5-Oct-07 4:39 
GeneralRe: Stored Procedures Pin
kibromg5-Oct-07 4:53
kibromg5-Oct-07 4:53 
GeneralRe: Stored Procedures Pin
Michael Potter5-Oct-07 5:36
Michael Potter5-Oct-07 5:36 
GeneralRe: Stored Procedures Pin
kibromg5-Oct-07 6:05
kibromg5-Oct-07 6:05 
GeneralRe: Stored Procedures Pin
Michael Potter5-Oct-07 8:50
Michael Potter5-Oct-07 8:50 
GeneralRe: Stored Procedures Pin
GuyThiebaut5-Oct-07 9:07
professionalGuyThiebaut5-Oct-07 9:07 
QuestionTool to generate data Pin
matthias s.5-Oct-07 3:16
matthias s.5-Oct-07 3:16 
QuestionTO STORE IMAGES FROM FOLDER TO DATA BASE Pin
kishoregani5-Oct-07 2:39
kishoregani5-Oct-07 2:39 
AnswerRe: TO STORE IMAGES FROM FOLDER TO DATA BASE Pin
Christian Graus5-Oct-07 2:52
protectorChristian Graus5-Oct-07 2:52 
AnswerRe: TO STORE IMAGES FROM FOLDER TO DATA BASE Pin
Vasudevan Deepak Kumar5-Oct-07 3:39
Vasudevan Deepak Kumar5-Oct-07 3:39 
AnswerRe: TO STORE IMAGES FROM FOLDER TO DATA BASE Pin
Paul Conrad7-Oct-07 11:09
professionalPaul Conrad7-Oct-07 11:09 
QuestionUpdating one Dataset from another Dataset. Pin
Hemant.Kamalakar5-Oct-07 2:11
Hemant.Kamalakar5-Oct-07 2:11 
AnswerRe: Updating one Dataset from another Dataset. Pin
Kschuler5-Oct-07 6:18
Kschuler5-Oct-07 6:18 
GeneralRe: Updating one Dataset from another Dataset. Pin
Hemant.Kamalakar5-Oct-07 19:30
Hemant.Kamalakar5-Oct-07 19:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.