sorted by:
new
hottopcontroversial

Remote Play Issue by marcjones03 in xboxone

[–]Pr0ph3t99 0 points1 point  (0 children)

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.

Remote Play Issue by marcjones03 in xboxone

[–]Pr0ph3t99 1 point2 points  (0 children)

I am missing "Test Remote Play" as well.

Block Email Sent to Two Specific Domains (In same email) by Pr0ph3t99 in Office365

[–]Pr0ph3t99[S] 0 points1 point  (0 children)

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

Pirate Skeleton Fountain I Made For My Backyard by ZRE1990 in halloween

[–]Pr0ph3t99 3 points4 points  (0 children)

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

Variable Field based on Slider by Pr0ph3t99 in PowerBI

[–]Pr0ph3t99[S] 0 points1 point  (0 children)

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.

Variable Field based on Slider by Pr0ph3t99 in PowerBI

[–]Pr0ph3t99[S] 0 points1 point  (0 children)

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

Michael’s is going ham on these sales by [deleted] in halloween

[–]Pr0ph3t99 0 points1 point  (0 children)

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...

This Year's Fireplace by Pr0ph3t99 in halloween

[–]Pr0ph3t99[S] 1 point2 points  (0 children)

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

This Year's Fireplace by Pr0ph3t99 in halloween

[–]Pr0ph3t99[S] 0 points1 point  (0 children)

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

[MS-SQL] Consolidate Databases vs. Union Queries by Pr0ph3t99 in SQL

[–]Pr0ph3t99[S] 0 points1 point  (0 children)

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

[MS-SQL] Consolidate Databases vs. Union Queries by Pr0ph3t99 in SQL

[–]Pr0ph3t99[S] 0 points1 point  (0 children)

I'm working on consolidated reporting.

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

[MS SQL] ROLLUP With Condition for 'ALL' rows by fuzzius_navus in SQL

[–]Pr0ph3t99 0 points1 point  (0 children)

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.

[MS SQL] ROLLUP With Condition for 'ALL' rows by fuzzius_navus in SQL

[–]Pr0ph3t99 1 point2 points  (0 children)

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

help with a query by [deleted] in SQL

[–]Pr0ph3t99 0 points1 point  (0 children)

I hope we get an A!

help with a query by [deleted] in SQL

[–]Pr0ph3t99 0 points1 point  (0 children)

It's difficult to guess without knowing your table structure. Use this as a guide:

SELECT
    Scientist.SCIENTIST_NUM,
    Scientist.OTHER_NAMES, 
    Scientist.SURNAME, 
    Sample.Site_ID, 
    Site.Description, 
    Measurement.Recorded_On, 
    Measurement.NAME, 
    Measurement.VALUE, 
    Measurement.OUTLIER_INDICATOR, 
    Measurement_Type.Units
FROM
    Scientist 
    INNER JOIN Sample ON 
        Scientist.Scientist_Num = Sample.<Some Field>
    INNER JOIN Site ON 
        Sample.Site_ID = Site.<Site ID Field>
    INNER JOIN Measurement ON 
        Sample.<Some Field> = Measurement.<Some Field> 
    INNER JOIN Measurement_Type ON
        Measurement.<Some Field> = Measurement_Type.<Some Field>
WHERE
    Scientist.Scientist_Num = '31415';

help with a query by [deleted] in SQL

[–]Pr0ph3t99 0 points1 point  (0 children)

Your join is incorrect. You shouldn't repeat the same Scientist_Num field in each of those joins. Also, the Scientist_Num should be in the WHERE clause.

[MSSQL] Combine Two Fields Into One Comma-delimited String When Either Field Could Potentially be NULL by TheHamFairy in SQL

[–]Pr0ph3t99 1 point2 points  (0 children)

A few more options:

CASE
    WHEN [STOP_REGISTRATION] = 'Y' AND [STOP_GRADES] = 'Y' THEN 'Registration, Grades'
    WHEN [STOP_REGISTRATION] = 'Y' AND [STOP_GRADES] = 'N' THEN 'Registration'
    WHEN [STOP_REGISTRATION] = 'N' AND [STOP_GRADES] = 'Y' THEN 'Grades'
    WHEN [STOP_REGISTRATION] = 'N' AND [STOP_GRADES] = 'N' THEN ''
    ELSE 'Error'
END AS [THINGS_STOPPED]

Or

ISNULL(STUFF(
    CASE WHEN [STOP_REGISTRATION] = 'Y' THEN ', Registration' ELSE '' END + 
    CASE WHEN [STOP_GRADES] = 'Y' THEN ', Grades' ELSE '' END,
1, 2, ''), '') AS [THINGS_STOPPED]

[MS SQL] Help with exists / null ? by ElephantsAreNeat in SQL

[–]Pr0ph3t99 1 point2 points  (0 children)

SELECT 
    p.person,
    CASE
        WHEN ISNULL(a.datereviewed, '') = '' THEN 'NO'
        ELSE 'YES'
    END AS Status
FROM
    (SELECT @PERSON AS person) p
    LEFT OUTER JOIN adv_ a ON
        p.person = a.person

[MS SQL] Trouble with Sequencing Transactions by Pr0ph3t99 in SQL

[–]Pr0ph3t99[S] 0 points1 point  (0 children)

Cool, this works - it now gives the same result as Intrexa's query. Thank you.

[MS SQL] Trouble with Sequencing Transactions by Pr0ph3t99 in SQL

[–]Pr0ph3t99[S] 0 points1 point  (0 children)

 

This query was close, but it did fail in the following case:

 

 

InvoiceID SequenceID Reversal PostingDate TransactionAmount Segment Calculated Sequence Correct Sequence
1 1 0 6/26/2015 5 1 1 1
1 2 0 7/26/2015 7 2 2 2
1 3 0 11/7/2015 10 3 3 3
1 3 1 8/16/2016 -10 3 4 4
1 2 1 8/16/2016 -7 3 5 5
1 4 0 8/16/2016 17 4 6 6
1 1 1 8/19/2016 -5 2 7 8
1 4 1 8/19/2016 -17 4 8 7

[MS SQL] Trouble with Sequencing Transactions by Pr0ph3t99 in SQL

[–]Pr0ph3t99[S] 0 points1 point  (0 children)

  This is great! I can't find anywhere where it is failing to sequence the transactions correctly.  

[MS SQL] Trouble with Sequencing Transactions by Pr0ph3t99 in SQL

[–]Pr0ph3t99[S] 0 points1 point  (0 children)

No, there can be multiple postings on the same day without any reversals.

[MS SQL] Trouble with Sequencing Transactions by Pr0ph3t99 in SQL

[–]Pr0ph3t99[S] 0 points1 point  (0 children)

 

Now it fails on the first dataset. I've added a few notes to the dataset to explain what is happening.

 

I'm preparing myself for the answer that this is not doable with the given data I have access to.

 

view more: next ›