I've ground up a hard drive with a power-grinder (grinding wheel, whatever), and I've melted one down with a welding torch. Was fun both times, but you do have...

It used to be "penny for...

sql:variable and sql:column can return values, but not paths. To use it that way, you need to build a dynamic SQL statement that puts the literal path in the...

Revenant (11/21/2011)

---

DECLARE @temp TABLE ( name VARCHAR(20), total INT );

INSERT INTO @temp

SELECT Name, SUM(Consumption)

FROM tablename

GROUP BY Name;

DECLARE @maxValue INT = ( SELECT MAX(total) FROM @temp );

SELECT...

Here's a solution that doesn't use a Calendar table:

CREATE PROC dbo.DeleteMe

(@WeekDay INT,

@FromDate DATE,

@ToDate DATE)

AS

...

Revenant (11/21/2011)

---

bomborde (11/21/2011)

---

. . . I must do this without a select inside a from.

. . .

Can anyone do this without a 'view' or 'join' or 'order by'? . ....

Second the motion on using a calendar table. They're tremendously useful, and will be MUCH faster than the kind of function you built.

bomborde (11/21/2011)

---

I still want to learn on my own as always try to do. I searched for efficiency tests about the order by, max(), and so on. but nothing. Since...

It must be DBA season somewhere. That's four admitted interview questions just today on the forums. And those are just the ones who fessed up.

Honestly, I'd use Top 1 With Ties, use an appropriate Order By on the Sum() function, and let the interviewer know that you got some help online to make sure...

This page has definitions: http://msdn.microsoft.com/en-us/library/ms139914.aspx

Do you have specific questions, or are you just trying to figure out which one is which?

Not without an Order By, but a simple Sum() and Order By would do it. Do that all the time.

Is it a homework/test/interview type question, where artificial constraints like...

Ninja's_RGR'us (11/21/2011)

---

GSquared (11/21/2011)

---

Cargo Cult programming. ...

Cargo Cult programming. Gotta love...

Jack Corbett (11/21/2011)

---

Hey, for those not on Twitter (why aren't you). My dad passed away early this morning. Not unexpected. I blogged about it, http://t.co/hCjjRnRh if you...