Viewing 15 posts - 226 through 240 (of 607 total)
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 6, 2019 at 1:18 pm
Think this person may be out of luck, but if anyone has any bright ideas, they could use them.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 6, 2019 at 1:12 pm
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 5, 2019 at 9:24 pm
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....
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 5, 2019 at 9:21 pm
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 31, 2019 at 1:16 pm
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
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 31, 2019 at 1:13 pm
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 31, 2019 at 1:05 pm
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 31, 2019 at 12:06 pm
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...-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 30, 2019 at 8:36 pm
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 30, 2019 at 6:34 pm
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.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 29, 2019 at 12:34 pm
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 28, 2019 at 8:45 pm
Good advice from "the warm-and-fuzzy DBA"
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 28, 2019 at 2:28 pm
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 21, 2019 at 9:51 pm
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 21, 2019 at 2:38 pm
Viewing 15 posts - 226 through 240 (of 607 total)