Commonly, "SELECT *" is read as "SELECT ALL". Perhaps you've confused that?

Ricardumus (8/2/2010)

---

Hey Guys,

SQL newb here. Can someone please step me through exactly what this variable assignment is

doing? Specifically "ELSE DATEADD(DD,-DATEPART(DW,@STARTDATE)+1"

SELECT @SUNDAY = CONVERT(VARCHAR(10)

,(SELECT CASE WHEN DATENAME(DW,@STARTDATE)

=...

I looked a little deeper, and a look-up table wouldn't be as elegant as I thought. It could still be done, and it would be fast, but it might...

My guess is that the code posted above with be several degrees slower than the original code. CASE statements, while they can be a mess to read, are quite...

I'm interested in this too. I would love to use this for log files.

dateadd(wk, datediff(wk, 0, @ThisDate), 0)

This will convert a date into the first Monday of the week that contains it. Group on this date.

Check out Lynn Pettis' wonderful one-stop-shop for...

I think your best bet is VARBINARY. You'll need something like a user-defined function to convert to and from the datatype, but there really isn't a better datatype for...

This definitely looks like you could join it against a Tally table or Date table.

That is a really creative way of avoiding using a cursor, but is it really getting around any of the problems with cursors? The primary problems with cursors are...

Ducati: You can use the parameters in the queries themselves. The query should already be a SELECT statement of some kind. You'd want to add something like this:

WHERE...

ISNULL() does exactly that:

ISNULL([Field],0)

This returns 0 if [Field] is NULL, otherwise it will return [Field].

But I prefer COALESCE() because it is a little more flexible:

COALESCE([Field],0)

The above code does exactly the...

Henry's code is better. I didn't even think to use a join for some reason. Use his second query.

--J

bandgeek5454 (7/27/2010)

---

I am pretty new at SQL, so bear with me if this is an easy/stupid question. This is what I have for my query so far in simplified terms.

SELECT...

No problem. I did the same thing, and thought the BOL was crazy. I wanted to know what was up too, so I did a little digging and...

No worries. It may help you to look at the two tables. The one created from the Excel file should show dates, all of which have midnight as...