pwalter83 (6/23/2014)

---

If the query you "need to use" doesn't work...

pwalter83 (6/19/2014)

---

Sachin Nandanwar (6/19/2014)

---

Something like this

SELECT SUM(YourSum) FROM

(

SELECT SUM(CASE WHEN SOA_TYPE = 'Agent' THEN USD_AMOUNT ELSE 0 END) +

SUM(CASE WHEN SOA_TYPE = 'Freight' THEN USD_AMOUNT ELSE 0 END) +...

Are we good so far?

DECLARE @fromDate DATE = 'Apr 01 2008'

DECLARE @tODate DATE = 'Apr 30, 2014'

DECLARE @NumberOfRecords INT = 6

DECLARE @period VARCHAR(10) = 'monthly' -- (This can...

Good. You have some guesses - which is nice.

Or:

UPDATE t1 SET

P = T.NewP

FROM table_1 t1

CROSS APPLY (

SELECT NewP = ISNULL(MAX(p),0)+1

FROM table_1 t2

WHERE t1.link = t2.link

) t

What can you tell us about the distribution of values...

pwalter83 (6/20/2014)

---

Sachin Nandanwar (6/20/2014)

---

But you seem to having one already in your query

(SELECT SUM(CASE WHEN SOA_TYPE IN ('Agent','Freight','Cost') or AC = '16208'THEN USD_AMOUNT ELSE 0 END) YourSum

FROM...

KnowledgeSeeker (6/20/2014)

---

Sorry if the requirement is not clearly mentioned(English is not my first language). In the example I gave the dates the user passed are June 05, 2010 and June...

KnowledgeSeeker (6/20/2014)

---

No. The requirement is quite clear. If the user wants to find last 5 week's data from the table and he has the upper range for date say, June...

KnowledgeSeeker (6/20/2014)

---

I have a table with large data. The structure along with the sample data of the table is as follows:

CREATE TABLE #SampleData

(

BaseYear INT,

TransYear INT,

ClientName VARCHAR(50),

DepID INT,

Revenue, INT,

TransactionDate DATETIME

)

INSERT...

If Bitbucket's explanation doesn't exactly meet your requirements, then simply ask what you need to know. Rudeness is unnecessary and unprofessional.

Eugene Elutin (6/19/2014)

---

have you ever tried asking on interview what kind of results the following statement will produce:

SELECT...

You're welcome - but the time was taken a while ago to demonstrate a point to a colleague...

Eugene Elutin (6/19/2014)

---

...

-- Query 4

SELECT c.*, o.*, ol.*

FROM #Customers c

LEFT JOIN #Orders o

INNER JOIN #Orderlines ol

ON ol.OrderID = o.OrderID

...

This might help:

“You have a query which joins two tables, say Customers and Orders. It’s an outer join because you want all customers whether or not they’ve ever placed an...

This might get you started:

SELECT --DISTINCT

t.transactionID, b.TransDate, b.TransType, b.TransDesc1, b.TransDesc2, b.TransDesc3, b.TransDesc4, b.TransDesc5,

(b.Debit + b.Credit) as Amount,

ISNULL(r.OrthoID, 0) as OrthoID,

ISNULL(t.PatientID, 0) as PatientID,

t.ledgerAmount,

t.LedgerType,

(b.Debit + b.Credit) -...