Stefan,

My primary objective is to copy all of my CDs in a lossless format to the hard drive. Of course, I can save drive space by ripping just the...

I think I'm sticking with lossless audio - at least at first. Then I might try the other formats.

As for the XBOX, I see where you can RIP CDs...

You can use and INNER JOIN on the tables, and join on at least the TransactionID and TransactionType fields - maybe more of them. Then include your filters in...

ChrisM@home (4/13/2011)

---

mtillman-921105 (4/13/2011)

---

mtillman-921105 (4/13/2011)

---

Gila Monsters - the critters, not Gail, have a strange defense. Rather than a venom per se, their mouths are so full of bacteria and basically...

Craig, you're probably right! Then it was my fault, not the documentary's. I should have looked it up before relying on...

mtillman-921105 (4/13/2011)

---

Gila Monsters - the critters, not Gail, have a strange defense. Rather than a venom per se, their mouths are so full of bacteria and basically nasty that...

Like Craig said, this is not optimal.

But to use IFs, you could replace the Select statement with:

IF @Start_time = 'Daily'

SET @Offset = NULL

IF @Start_time = 'Weekly'

SET @Offset = -7

IF @Start_time...

alen teplitsky (4/13/2011)

---

how are you connecting to your home stereo? PC straight to receiver?

for $200 to $300 or so you can buy a set of wifi/bluetooth speakers and just...

Brandie Tarvin (4/13/2011)

I agree with Jack. I do know Jacksonville has several contractors who do that to people, though, and that the Better Business Bureau hereabouts is almost useless in...

Gila Monsters - the critters, not Gail, have a strange defense. Rather than a venum per se, their mouths are so full of bacteria and basicsally nasty that their...

'Hope I didn't "Gila Monster" anyone off by talking about Hi-Fi and DACs and such. 🙂 Surely someone has a system they've set up that sounds good!

Wow, that's a huge series of CASE statements. Unless you are sure that this is the only time you will have to contend with this code, I would...

Terrific question. For some reason dates are not my best topic.

Excel is your friend here unless you're dealing with a huge amount of data.

Pull it into Excel first. Format the fields appropriately. The you can either...

Thanks again Grant, I will have to dig into this further when I have time. I'd like to understand why parameter sniffing wasn't an issue before, but it...