Youth leagues should all have a rule that if parents act out, their kids' team is penalized. I remember being a teenager and having a couple get into a fist...

ouch. https://www.sqlservercentral.com/forums/topic/help-i-did-a-drop-and-create-blank-records-on-a-production-database

Think this person may be out of luck, but if anyone has any bright ideas, they could use them.

I don't think you can modify the @timestamp variable in the subscription like that, but even if you could, why would you want to? What if two reports executed within...

If the horizontal axis is the same time component and you're just looking at different series in your data, then yeah, I suppose any stacked bar chart would be that....

I think it's odd to have them in four different buckets. You could define everyone under two years by just grouping all the people in the lower buckets together, no...

I like @Taps' solution, alternative is to add another check where you fix the 5th and 6th positions to be less than 12

AND PATINDEX('[^0-9][^0-9][^0-9][^0-9][0-1][^0-1][0-9][0-9][0-9][0-9][R][0-9][0-9]',@a)<=0

We can't see all the tables you're using here, so guessing, but at the end, you both check if a column is numeric and then try to convert it to...

Glad to hear it. FYI, if you can provide the data like you did, but scripted out like I did so it's just a copy/paste to get it into a...

IF OBJECT_ID('tempdb..#myTable') IS NOT NULL BEGIN DROP TABLE #myTable END
IF OBJECT_ID('tempdb..#newTable') IS NOT NULL BEGIN DROP TABLE #newTable END
CREATE TABLE #myTable ([Date] date,[start talk] datetime,[end talk] datetime)
INSERT...

Some people are of the opinion that if you have to go back and forth a few times in email then you are better off picking up the phone or...

Thanks, but other than the final Catch there is no error being specifically thrown, and we're only going there when an error occurs along the way.

Maybe he's just saying that if you have an index that is never used, that could be a symptom of performance improvements to be made, by creating one that is...

Good advice from "the warm-and-fuzzy DBA"

whatever your presentation layer is doing, submitting the form calls a stored procedure you will write which populates the lookup table with the information selected. Lookup table has foreign key...

I have to use explicit conversions because I want to embed a date in a string as output, or do comparisons on dates stored as text in a schema that...