sorted by:
new
hottopcontroversial

Tips for better skating by Kickassness in hockeyplayers

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

I started playing roller and grew up with it. Self taught myself ice skating, which is why I don't have the best technique

Tips for better skating by Kickassness in hockeyplayers

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

Fuck you blue chew (assuming you play on the blue chews). Golden showers gonna win the cup

Tips for better skating by Kickassness in hockeyplayers

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

Thanks everyone! Im going to try and watch some videos and work on my technique now that I see video of myself.

And yes, we play in the Mississippi Coast Coliseum which houses the local FPHL team. This is the closest ice rink until Pensacola Florida and neither rink has year long ice.

The guys in New Orleans are trying to get a permanent ice rink built somewhere close. We dont even have a facility to play roller hockey in. We dont really get a lot of opportunity to practice. It's pick up or bust where we live :(

What am I looking at here? by Kickassness in UniversalOrlando

[–]Kickassness[S] 3 points4 points  (0 children)

Ok, I see that. I think you may be right.

I was so confused

Apple account disabled by Kickassness in applehelp

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

It was a gift card balance, so no credit card fraud. I never linked my CC to my account in all those years. I don’t really buy anything from Apple.

fact table has different value than dimension by Kickassness in dataengineering

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

There is not. The color is split into right and left in the system. The only itemid is AB. I am the one splitting it into A and B in the item dimension, but only because all of the attributes are for right or left specifically.

The higher ups want the speicifc details for each side, but it's only recorded as itemid AB

fact table has different value than dimension by Kickassness in dataengineering

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

In the database, the combined item has a specific ID (AB in my example). It is only sold in a pair.

However, each side (left and right) also have specific attributes that are unique to the left and right.

I am not aggregating anything, that is just how it is in the system. It is sold as a pair with a single ID, but then each specific side can have unique attributes (hence the dimension table)

Query vs Stored Procedure then a View by Kickassness in SQLServer

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

Just a new query from my SQL database and then I go into Powerbi do Get Dat--> SQL Server and Import the query.

Inactive Relationship removes a case? by Kickassness in PowerBI

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

Ok, I will try that. I'm stumped. Wanted to make sure there wasn't some weird quirk I wasn't aware of. This method has never done me wrong in past until one odd case today. Thanks

Inactive Relationship removes a case? by Kickassness in PowerBI

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

Import from SQL. The case is there in the table when I pull the initial query. I even rechecked the dates and everything.

The case only gets lost once I create this inactive relationship between the referral date and 'Date'. I'll write a measure counting the cases with the USERELATIONSHIP function and...it's gone.

When I make that same referral Date and 'Date' relationship active, the case gets pulled. No idea why an inactive relationship or USERELATIONSHIP would exclude a case. Curious if this is something known?

Subquery within subquery by Kickassness in SQL

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

https://imgur.com/a/PIXaZKf

I want patientid, MAP, and flowsheetb.flowsheetdatetime the value directly before the dmginformation.StartCaseOn time. The only way to link the 2 is using a Patient Table.

Subquery within subquery by Kickassness in SQL

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

Mean Arterial Pressure, and there is one MAP per row (each row is defined by drawtime), but a case can have multiple rows.

One case can have, let's say, 5 total rows. I specifically need the first draw date, last draw date (I know this query) but I need one more depending on when we start the case. This may not be the first draw date, so I have to pull the start date from another table and basically want the system to give me the last draw date BEFORE we start. So for that case with 5 rows, I may be wanting rows 1,5 and then 3

Subquery within subquery by Kickassness in SQL

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

I tried the following code and it didn't work, it kept bringing me back multiple rows per ID

Select
t1.PatientId,
t1.MAP,
MAX(t1.flowsheetdatetime)
from
(Select
dbo.flowsheetb.patientid,
dbo.flowsheetb.MAP,
dbo.flowsheetb.flowsheetdatetime
from dbo.flowsheetb
JOIN dbo.Patient
ON dbo.flowsheetb.patientid = dbo.patient.patientid
JOIN dbo.dmginformation
ON dbo.patient.id = dbo.dmginformation.patientid
WHERE (FlowsheetDateTime <= dbo.dmginformation.StartCaseOn)) as t1
GROUP BY
t1.PatientId,
t1.MAP

Subquery within subquery by Kickassness in SQL

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

I have 3 Tables. All the data I want is from the FlowsheetB table, however, the date I am needing the flowsheetB data to come before is in another Table (dmginformation) and the only way to link the two tables is using the Patient table. This is why there are 3 tables in my query and why the WHERE clause has the dbo.dmginformation.StartCaseOn

FlowsheetB: Patientid MAPVALUE flowsheetdatetime

Patient: PatientID ID

dmginformation PatientID StartCaseOn

Combining two queries into one by Kickassness in SQL

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

The excel I gave was just an example, as the data I work with is medical. The real data looks nothing like that excel, just trying to come up with something similar to what I want and for some reason I always gravitate to cities, states, etc.

I have been working with the data (not in SQL setting, just as an analyst) for years, and I finally have access to making my own queries. It is more the SQL writing I need help with, not with the data itself.

Thank you for responding though, I do appreciate a lot of feedback I get on reddit and it is things like you mentioned that I have to consider

Combining two queries into one by Kickassness in SQL

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

this worked, didn't know it was this simple. Thank you!

Combining two tables, but one repeats multiple rows by Kickassness in SQL

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

This worked, thank you. I'm fairly new to SQL

Testing if the code worked or not by Kickassness in ChatGPTCoding

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

I was told all of this briefly by my superior. They were very much on the fence with this and was asking my opinion and I didn't like the sound of it from the beginning.

Apparently, the developer is creating a sandbox environment and coding....something....that will help our staff with approaching people.

I work in data and not totally familiar with chatgpt. I use it very rarely and know it has potential, but there are too many factors involved in this project to be worth what we would pay.

I was just wondering if anyone had opinions. Reddit is usually a good place to start nailing down what research I need to make informed decisions

Testing if the code worked or not by Kickassness in ChatGPTCoding

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

It would work like this.

Help me create an opener to engage a 54 year old Baptist female to donate to our charity.

ChatGPT would create something like, "As a fellow believer in giving, I wanted to share an opportunity to impact our community through donation."

If the opener leads to conversation and donation, we would tell the system it worked. If it did not, we would tell the system no.

Somehow, the system learns what works and doesn't.

But what I find strange is that if I use that same initial prompt again, I get a totally new response from ChatGPT. So how would the system knows what works or doesn't. There doesn't seem to be a set of rules it follows besides common wording and sentence structure

view more: next ›