DKN2101 (4/24/2013)

---

- I want to show every day, even if there isn't a row for it.

- Don't have much experience with CTE ... the syntax should be something like...

OK. #1 and #2 and almost the same thing. Let's start with #1 (Total Cents for each day in the month of March 2013. Revenue is measured with the "cents"...

DKN2101 (4/24/2013)

---

I have a table called DollarTransactions in a database, which records purchases. The table has the following fields, which you can see by clicking the link to a screenshot:...

carsten.crystaldive (4/24/2013)

---

Cheers for the reply ...

There's two problems here with this solution ... 1.) The Breakdown-Table contains the constants, I'd need these Computed Columns on my Wages Entry table as...

The best approach would be to normalize your base table. 😀

To get the results you are looking for you need to use a cross tab. You can find two great...

Here is the original query after formatting:

SELECT --bi.cobdate,

fact.batchid

,fact.mastergroup

,fact.counterparty

,fact.counterpartyname

,fact.parentcounterpartyname AS ParentCounterparty --If No Parent, then show the original CP as Parent

,fact.portfoliolevelcd AS AggregationScheme

,fact.portfolionodevalue AggregationNode

,ptycc.anzccr AS CCR

,ptycc.securityindicator AS SI

,fact.limittimeband

,fact.limitstartdt AS [Start_Date]

,fact.limitenddt AS...

ArjunaReddy (4/24/2013)

---

Hi,

Please help me out with the below query.

We are calculating Exposure column (Hilighted in the query) based on current date and my requirement now is to add a new...

What you need here is a computed persisted column on your breakdown table, possibly three (1 for ACA, Confined and Dives). Then you would need to create a constraint on...

Mansfield (4/23/2013)

---

Text, ntext and image are special data types that does not support the normal string operators.

If you want to concatenate, you'll need to cast each field into varchar or...

Get some sleep!!!

Once you are rested what would be a big help is to post some sample data along with what you expect to happen. You will be able to...

No worries about being new around here...we all were once. 😛

So what you want to do is to have the Breakdown.Amount_ACA be a remaining based on WagesEntryNew?

In other words a...

Well we are all just guessing here because we...

Hi and welcome to the forums. Did your post have a question or just to share a solution? If it was a question, the question seems to be missing. If...

Maybe something like this?

WHERE cast(c.CTS_LAST_SAVED_DATE as DATE) = cast(GETDATE() as DATE) and cast(a.APP_LAST_SAVED_DATE as DATE) = cast(GETDATE() as DATE) or CAST(c.CTS_LAST_SAVED_DATE as DATE) = cast(GETDATE() as DATE)

At first glance that...

Hi and welcome to the forums. It is very difficult to determine what you are trying to do here. The "columns" are all very short abbreviations that make sense to...