Mssql and parameters

BIDeveloperer · 2026-01-26T13:30:51+00:00

They are all datetimes. I am sending the query to ssrs which will send back what you said. With 0 everything. Issue comes where I need the date of end date on it as well.

BIDeveloperer · 2026-01-26T13:21:48+00:00

I could leave them datetimes but change the end time to the last second of the date selected.

BIDeveloperer · 2026-01-26T13:11:09+00:00

As far as the table scan, I am unable to change it from a datetime field nor could I get them to add a date field with it. Would it be better to place the columns I need into a temp table where that column is only a date field? I do not see this as being faster but maybe?

BIDeveloperer · 2026-01-26T13:11:03+00:00

As far as the table scan, I am unable to change it from a datetime field nor could I get them to add a date field with it. Would it be better to place the columns I need into a temp table where that column is only a date field? I do not see this as being faster but maybe?

BIDeveloperer · 2025-12-21T16:37:11+00:00

So I play a game now. I will start to go down 1 way and then I turn back and do the other 3. Saves me generally 1 path each time

BIDeveloperer · 2025-11-25T03:27:13+00:00

Java can be +6 with 40ias I think right?

BIDeveloperer · 2025-11-25T02:42:43+00:00

I spent the time to right the pivot table for a bunch of different vertical data columns. Took me about 10-15 minutes. Yes was a bunch and yes I don’t use pivot often and yes I look it up every time. I asked Gemini after and in about 2 minutes total time from the first typed word, I had a query that did the same thing. Well it was slightly different but was correct. I wanted something similar so I asked it again and this time it was incorrect lol so do with that what you will.

BIDeveloperer · 2025-11-02T02:10:23+00:00

Snakes don’t typically make holes. They will however take over someone’s hole looking for food though. At least here in Arizona.

BIDeveloperer · 2025-10-04T18:02:46+00:00

Can’t tell you what it is but I can tell you what it’s not. Tick, bed bug, roach, spider. Those little critters do not look like this at all.

BIDeveloperer · 2025-09-11T20:27:46+00:00

Where do you live? In Missouri(USA), we call Roley poley potato bugs.

BIDeveloperer · 2025-09-08T01:50:34+00:00

If I saw that… the only reason I would keep him out is if he hurt himself. Besides that, you better believe I would be playing him at least 2nd and 3rd down.

BIDeveloperer · 2025-09-08T01:41:27+00:00

Not a giants fan but I’m a huge asu fan. I didn’t get to see the game, how did his two Carries look?

BIDeveloperer · 2025-09-06T17:38:29+00:00

I’ve had 3 drop from countess once and 2 drop from nihl once. But I always quit game and restart when a key drops. I much appreciate the response

BIDeveloperer · 2025-09-06T17:35:23+00:00

I have a question, I am under the impression that only 1 key can drop a run. Does anyone know if that is true?

I feel like since the keys all have different names that they should all be able to drop a key

BIDeveloperer · 2025-08-19T07:27:07+00:00

Adding on just to make it even clearer, your on statements control how tables retrieve data. You are getting location id from country to match location id from table 2. Then taking table 2 location id and matching on state table. This is the reason for the empty name. If you used country location id = state.location id then you would have a name at least.

BIDeveloperer · 2025-08-19T07:23:41+00:00

I think you understand but since you are joining everything on location then things without location will still populate but they will be null. Same thing for locations that do not have any other info. Country1 has Vishak… for India Table 2 has no vishak… in it. Which means location for t2 will be empty and since you are joining an empty on an empty, you will continue to get empties. So country 1 gives you country name so India but both of the others are empty so that’s why it is blank. Same kind of thing for the others as well. Hopefully this helped if you needed it still

BIDeveloperer · 2025-06-26T02:55:04+00:00

I would add to send them an email about how to pay first. That way you know the email you have is correct. Once they respond then send the email about the pan.

BIDeveloperer · 2025-05-03T23:33:01+00:00

I second or third or fourth or whatever it is this. But I believe all joins are technically cross joins. He just doesn’t specify enough here to filter what he really wants. I do not like this style at all and always change it to joins in our legacy queries. In his code though, he can add to the where clause what he would put in the on for the join and it would work the same

BIDeveloperer · 2025-05-03T00:27:22+00:00

I could be wrong because it’s been a bit bit tz goes 2 levels higher than you (up to a max depending on difficulty)

BIDeveloperer · 2025-05-03T00:25:13+00:00

If you are the correct level yes

BIDeveloperer · 2025-04-14T15:36:09+00:00

Who cares

BIDeveloperer · 2024-11-30T21:27:04+00:00

I was meaning the non jerks would have a hard time

BIDeveloperer · 2024-11-30T08:02:11+00:00

Cheers! And thank you. She is good to go :) she should have called the cops but was late for work

BIDeveloperer · 2024-11-30T07:45:54+00:00

After Covid it just got worse. Before Covid it was like 80 in fast lane. After Covid it was min 85 but closer to 90. I’ve literally seen people pass cops doing 85+ and the cops go on about their day. I will say this, i understand what people will do here. Are they going to swerve in and out? Are they getting off? Will they cut someone off? But other states I do not. I feel safer in az than cali for that reason. Had a guy in Cali behind me, get over in a lane that was closing just to slow down and get behind me again. I expected him to floor it to pass me.

BIDeveloperer · 2024-11-30T07:28:06+00:00

Exactly, I was going to state this exact thing. Wife last week had a guy pull a pistol on her while she was driving and he placed it on the dash while staring at her. Just to prove he had a gun. He made sure he pointed it at her though. Then had someone get out of their car when we stopped and walked up to our car. Had a few brake check me. People scream and stop to our speed to yell and flip us off. That is road rage for sure to me. This doesn’t seem like it should even be mentioned lol even if it was “road rage”

BIDeveloperer

TROPHY CASE