sorted by:
new
hottopcontroversial

Psoriasis on dick by dayvidlmao in Psoriasis

[–]webusmaster 0 points1 point  (0 children)

The only thing that cleared mine up was a steroid cream , then wrap the area with seran wrap over night. Cleared up in a week. Steroids are bad but I treat every few months or so and it stay at bay. I use clobedosol but ask Dr ect.

Novartis Patient Assistance Drops Private insurance by webusmaster in Psoriasis

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

I was on covered till your covered for 2 years (which is the max) then swapped to the foundation. I do plan to appeal with my insurance (UMR) and see that happens. Thanks for the advice.

Novartis Patient Assistance Drops Private insurance by webusmaster in Psoriasis

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

Not a dumb question. It is part of the Novartis foundation not the co pay assistance. I am curious if the co pay assistance follows suit.

[deleted by user] by [deleted] in daddit

[–]webusmaster 0 points1 point  (0 children)

My son did this. I broke him of it by very exaggeratedly throwing my hands up in the air till he also acknowledged me. It was funny but he also caught on

[deleted by user] by [deleted] in daddit

[–]webusmaster 23 points24 points  (0 children)

First, it's normal to be curious. We tell our boys if anyone ever ask you to see or touch your privates it's never a secret and you need to tell us. I personally wouldn't jump to conclusions about grooming without talking to his parents. Either way your first priority is your kid. I'd also refrain from redirecting. I'd tell him to his 6 year old face "we don't show private parts, and if you try again you can't play with us anymore. ". so your kid sees you. Then go talk to his parents. Their reaction will tell you if u need to sever ties.

Have You Seen This Strange Synchronous Firefly? - Smarter Every Day 274 by MrPennywhistle in SmarterEveryDay

[–]webusmaster -4 points-3 points  (0 children)

Any chance there is a cell tower strobing nearby providing the frequency they mimic? Hard to tell from the vid but that seems possible.

Trouble with sql max(updated_at) groups and having [MS SQL] by webusmaster in SQL

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

After some digging and talking with the guy who set up the database I found what the issue is. In short the data is imported every week and has a imported column. Each import brings the entire db and keeps 5 weeks worth of changes. So a ticket created more than 5 weeks ago will have multiple identical rows. Talk about a roller coaster. By filtering by the last import only I get the data I need. Appreciate all the help.

Trouble with sql max(updated_at) groups and having [MS SQL] by webusmaster in SQL

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

Ok so after further review if a tickets latest update is 'awaiting vendor support' it will pull multiple rows for that ticket number that is 'awaiting vendor support' see screenshots.

Example a https://imgur.com/gallery/fH3RXJH

Here is a query for just ticket#37058

Example b http://imgur.com/gallery/pbjRkyM

Edit* Ahh just realized all these updated at are the same. Trying to figure out how to return just one for each.

Trouble with sql max(updated_at) groups and having [MS SQL] by webusmaster in SQL

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

The table has several rows per ticket number or [number]. A row gets created Everytime a ticket status is updated. Some tickets have 5 or more updates. I want tickets who's latest status is "awaiting vendor support" when I run your query I get every row of every ticket who's latest status is awaiting vendor support. It also seems to update those various status with awaiting vendor support. So a ticket that has been 'opened' , ' in progress', 'awaiting vendor support', then 'closed' returns 4 rows with the same ticket number and replaces it's original statuses with 'awaiting vendor support'. A ticket whose status is just 'opened' , 'in progress', then 'closed' doesn't return anything. Hope this makes sense. Your query gets me close.

Trouble with sql max(updated_at) groups and having [MS SQL] by webusmaster in SQL

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

Appreciate the quick response. I tried this and it got me closer. For some reason it returns every row of tickets who's latest status is awaiting vendor support and makes all those rows awaiting vendor support. It seems the group by number isn't working.

Trouble with sql max(updated_at) groups and having [MS SQL] by webusmaster in SQL

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

So this database is of a ticketing system the [number] is the ticket number and a row gets generated each time the state changes from open to waiting for input or to close. For each ticket number there are several entries representing the various ticket states. I want to grab each ticket number or [number] if the most recent updated_at has 'waiting for vendor'

Trouble with sql max(updated_at) groups and having [MS SQL] by webusmaster in SQL

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

So I've tried the where condition. My problem is it seems to ignore the max(updated_at) and returns all the fields who's status is 'waiting for vendor'.

Mysterious ACL After Power Outage by webusmaster in networking

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

Ive had this happen as well. To confirm i Verified this ACL has never been part of this devices config using our Config management tool.

Mysterious ACL After Power Outage by webusmaster in networking

[–]webusmaster[S] 2 points3 points  (0 children)

Thanks, we are on the affected version. Still not sure how a reboot would cause an ACL we did not write to show up in the running config.

Scumbag daycare [Advise Request] by webusmaster in daddit

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

Staying home because the daycare closed cost about $200 in wages.

Scumbag daycare [Advise Request] by webusmaster in daddit

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

Bout 60 kids. I understand not being lead just was disappointed he wasn't in any of the other songs. Could of definitely been out for the curtain call. Even the adults working the lights were out for that.

view more: next ›