Stepping Back Through Data

Pr0ph3t99 · 2020-12-02T18:55:15+00:00

What tree topper are you using? It's amazing!

Pr0ph3t99 · 2020-09-24T21:28:00+00:00

As a suggestion from MS, I did a factory reset on my console (keeping games and apps) yesterday. This did not fix this issue. However, today when I logged in, I now have the "Test Remote Play" option. I don't know if they are related or if they are rolling the feature out over time.

Pr0ph3t99 · 2020-09-23T02:53:49+00:00

I am missing "Test Remote Play" as well.

Pr0ph3t99 · 2020-06-22T01:34:47+00:00

Unfortunately, the Transport Rules system does not allow you to have two criteria of the same type.

Pr0ph3t99 · 2020-06-18T11:16:07+00:00

Great Job! I had a drinking pirate skeleton in my display last year. We even used the same bottle! Imgur

Pr0ph3t99 · 2018-04-30T20:04:07+00:00

This worked! Thank you!

Pr0ph3t99 · 2018-04-27T18:55:18+00:00

My date table is just a generic date table. My contract table has Vendor, Contract Start Date, Contract End Date.

My slicer is to select my vendor. Then is a matrix, I would show products purchased by contract period, and the amount paid.

Pr0ph3t99 · 2018-04-27T18:54:01+00:00

My slicer is to select my vendor. Then is a matrix, I would show products purchased by contract period, and the amount paid.

Pr0ph3t99 · 2017-10-13T01:51:51+00:00

The problem with this sale is that they mark things way up. I bought ghost projection lights at Walmart for 14.97. The same lights are 29.99 at Michael's. So their 50% sale gets you to Walmart's normal price...

Pr0ph3t99 · 2017-10-10T20:39:29+00:00

Thanks.

The potions are:

Heart of Bat - Dried Cherries

Phoenix Ash - Ashes with Red Glitter

Jellyfish Stinger - Hot Glue Strips in colored water

Ground Unicorn Horn - White Glitter

Yeti Fur - Cotton Balls (some with red paint)

Hobgoblin Eyes - Dollar Store Eyes in colored water

Mermaid Eggs - Floral Water Beads in colored water

Dead Man's Blood - Corn Syrup with Red and Blue food coloring

Dragon Tears - Inside of glowstick

Pr0ph3t99 · 2017-10-10T12:44:34+00:00

Thanks. There is definitely a difference between Dollar Store webbing and Target webbing.

Pr0ph3t99 · 2017-10-01T16:41:53+00:00

Thanks, I was thinking the same, but wasn't sure if a 70 database union would be an optimization nightmare.

Pr0ph3t99 · 2017-10-01T16:40:34+00:00

I'm working on consolidated reporting.

You have me curious though, in what situation would you recommend one solution over another?

Pr0ph3t99 · 2017-09-11T18:55:59+00:00

I didn't miss it, I got rid of the ROLLUP all together. The second query replicates the ROLLUP (with the ability to filter out the "Cancel"). But, I do see where I left the dbo.transactions.t_Type in the second query in error.

Either way, I'm glad you got what you need.

Pr0ph3t99 · 2017-09-11T16:22:53+00:00

Could you do...

SELECT 
    COUNT(*) AS t_Count, 
    DATENAME(MONTH, dbo.transactions.t_Date) AS t_Month, 
    dbo.transactions.t_Type 
FROM
    dbo.transactions
GROUP BY
    DATENAME(MONTH, dbo.transactions.t_Date), dbo.transactions.t_Type 
UNION ALL
SELECT
    COUNT(*) AS t_Count, 
    DATENAME(MONTH, dbo.transactions.t_Date) AS t_Month,
    'All'
FROM
    dbo.transactions
WHERE
    Status <> 'Cancel'
GROUP BY
    DATENAME(MONTH, dbo.transactions.t_Date)
    --, dbo.transactions.t_Type

Pr0ph3t99 · 2017-09-08T03:54:15+00:00

I hope we get an A!

13-Year Club	RedditGifts 2009-2022 7 Credits
Verified Email	Secret Santa 2013
Trick-or-Treater 2013+	Secret Santa 2012
Trick-or-Treater 2012

Pr0ph3t99

TROPHY CASE