Luis Cazares (7/12/2012)

---

In my experience, Smash would need a slightly different approach if he needs the total due for each contact, because Chris' query will only return the total from...

GSquared (7/12/2012)

---

Jeff Moden (7/10/2012)

---

@Gus,

Ok... I've been looking at this thread for a bit for "Sam's view definition" and I'm not finding any "SAM" that posted. Did you mean "Chris'...

UPDATE c SET

TotalDue = s.Freight + s.SubTotal + s.TaxAmt

FROM #Contact c

INNER JOIN #Sales s ON s.ContactID = c.ContactID

Well done Mark 🙂

Hello and welcome to ssc. Please have a read of the best practices / forum etiquette article here[/url].

This looks straightforward - if you can post some easily-consumable data as suggested...

The constant 'UK' in the command string will need extra quotes:

CASE siteId WHEN 91 THEN '''UK''' END

There are two flavours of CASE statement, simple and searched. This is a searched...

jerome.morris (7/11/2012)

---

There is lots of selects in this so I am not 100% where to put the date part. I also want to use Variables form from C# app.

(Docket_Date...

jerome.morris (7/11/2012)

---

I found out the Row grouping was incorrect in my report so its working now. I will eventually select Docket_Date also but will try a figure out where to...

Or like this:

;WITH Numbers AS (SELECT * FROM (VALUES (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)) d(n))

SELECT CHAR(a.n+64) + CAST(b.n AS VARCHAR(2))

FROM Numbers a CROSS JOIN Numbers b

WHERE a.n < 27

jerome.morris (7/11/2012)

---

When I execute this in SQL the results are perfect and in the correct order, I use a stored procedure and then drag to my DataSet designer in VS2010...

Jay, don't be afraid to ask - so long as you're willing to put in some effort, which you certainly have done so far, then folks will chip in to...

Like this?

; WITH OrderedData AS...

Jay, using the sample data you posted yesterday, your query above generates the following result:

Docket_CategoryDocketsPct_To_Total

Mechanical 440 ...

It's the client limit, not the server, as Anthony pointed...

krishnaprasad14 (7/11/2012)

---

Hi Thank you for your replay. I was done this. I can execute if I change query results to text o file but geting an error when I choose...