Forum Replies Created
Viewing 15 posts - 16 through 30 (of 443 total)
-
Reply To: Date Calendar - Current Qtr
Ah, but that won't work if the current quarter is Quarter 1 (due to the year comparison)
Looking into alternatives...
-
Reply To: Date Calendar - Current Qtr
Something like this?
CASE WHEN
DATEPART(QUARTER,c.DateKey) = DATEPART(QUARTER,@TodaysDate)
AND
... -
Reply To: insert trigger - help
Firstly I'd suggest reading this: https://www.brentozar.com/archive/2019/05/the-silent-bug-i-find-in-most-triggers/ , as you seem to have fallen into the trap that Brent describes.
-
RE: How Check string of Boolean expression is return true or false
See here for an explanation of the differences between '==' and 'is' in python.
There is nothing similar in SQL
-
RE: Computed Column Specification formula
w.bartelink - Wednesday, October 31, 2018 9:27 AMJohn Mitchell-245523 - Wednesday, October 31, 2018 9:22 AMRE: SQL Server 2017, 2012 Express Edition Insert Select Performance Issue with very less data.
sgmunson - Friday, October 12, 2018 7:15 AMRE: Date formatting in a text string.
DesNorton - Thursday, September 6, 2018 3:48 AMRE: Date formatting in a text string.
bolla.shravani - Wednesday, September 5, 2018 12:55 AMHi,
Did you notice this was a 6 year old thread?RE: remove Identity from a column
Orlando Colamatteo - Friday, July 27, 2018 10:21 PMRE: remove Identity from a column
HI,
FYI, in case you hadn't noticed, you are replying to a 7 year old post 🙂RE: how can I get uniqueidentifier value as return after insert a record
NB. This is an 8 year old post 🙂
RE: How to search for Tabs from "Find" in SSMS v17.5
d_george - Friday, May 4, 2018 8:02 AMThanks, I did not have an Editor window open when I clicked Edit earlier.
RE: How to search for Tabs from "Find" in SSMS v17.5
d_george - Friday, May 4, 2018 6:38 AMRE: How to search for Tabs from "Find" in SSMS v17.5
To see what you've actually got in the editor, turn on visible whitespace chars with 'Edit => Advanced => View Whitespace '
Viewing 15 posts - 16 through 30 (of 443 total)