Joey Morgan (2/25/2014)

---

If she gets any rows, she will get a zero trhough the case statement; that's correct. But if there are no rows she will only get null, and...

Will we have to call you Gloster now? 🙂 Well done Perry.

Homework or competition? What have you tried so far?

SQLRNNR (2/14/2014)

---

Sean Lange (2/14/2014)

---

SQLRNNR (2/14/2014)

---

I have seen that kluge query method work much faster and I have seen it be slower. It all depends. It would be well...

Ask your designer about the performance implications of ISNULL around a join column - and research it yourself first if you're not already 100% sure.

Groundhog Day, Keith. He's seen this once or twice before 😉

Convert it to BIGINT.

Lowell (2/11/2014)

---

well i've only done one piece of it...adding the date;

i have a simple macro i use to dump typical copy/paste data and turn it into a CTE, so coming...

Both functions will result in a sort unless a) the data coming into the operator is sorted same as the order by of the function and b) the query processor...

Use the OUTPUT clause on an UPDATE statement. OUTPUT was introduced in SQL Server 2005.

Recursive CTE's aside (I've done a little work with them), I think you are still missing the point - they're a coding shortcut. If you cannot consider your CTE to...

Here's a little test harness. If you can't figure it out from here, let us know:

WITH

Today AS (SELECT Today = '20120228' UNION ALL SELECT '20120229' UNION ALL SELECT CAST(GETDATE()...

This is straightforward using DATEDIFF and DATEADD. what do you want to do with a date which is exactly a year ago (or two years, or three)? Today one year...

youresoshain (2/9/2014)

---

So i ended up going with a union query that syncs grouped by carbon_copy_id and one without and it seems to be doing the job.

Thanks guys for getting...

Not sure what you mean Peter - a CTE is just a macro, a view on the fly. Can you construct your idea into pseudocode, it might make it easier...