nigel.

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...

May 23, 2019 at 8:38 am

#3646424
Reply To: Date Calendar - Current Qtr
Something like this?
```
CASE WHEN 
          DATEPART(QUARTER,c.DateKey) = DATEPART(QUARTER,@TodaysDate) 
      AND 
  ...
```
- This reply was modified 5 years, 7 months ago by nigel..
- This reply was modified 5 years, 7 months ago by nigel.. Reason: Better formatting
May 23, 2019 at 7:48 am

#3646412
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.
- This reply was modified 5 years, 7 months ago by nigel..
May 21, 2019 at 2:51 pm

#3645740
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

January 3, 2019 at 4:52 am

#2017835
RE: Computed Column Specification formula

w.bartelink - Wednesday, October 31, 2018 9:27 AM
John Mitchell-245523 - Wednesday, October 31, 2018 9:22 AM

October 31, 2018 at 9:35 am

#2011886
RE: DateAdd() - how to add 5 hours and 25 minutes to a date?

October 18, 2018 at 1:29 am

#2010183
RE: SQL Server 2017, 2012 Express Edition Insert Select Performance Issue with very less data.

sgmunson - Friday, October 12, 2018 7:15 AM
.... Doesn't everyone see that this person is a 100% fraud? Flim-flam artist? Con...

October 15, 2018 at 7:53 am

#2009611
RE: Date formatting in a text string.

DesNorton - Thursday, September 6, 2018 3:48 AM
nigel. - Thursday, September 6, 2018 2:31 AM

September 6, 2018 at 8:57 am

#2004724
RE: Date formatting in a text string.

bolla.shravani - Wednesday, September 5, 2018 12:55 AM
select format(convert(date,'2012-01-01'),'dd MMMM yyyy') as fulldate
Hi,
Did you notice this was a 6 year old thread?

September 6, 2018 at 2:31 am

#2004650
RE: remove Identity from a column

Orlando Colamatteo - Friday, July 27, 2018 10:21 PM
@Nigel, I noticed that too but they probably arrived here through a...

July 30, 2018 at 4:20 am

#1999428
RE: remove Identity from a column

HI,
FYI, in case you hadn't noticed, you are replying to a 7 year old post 🙂

July 27, 2018 at 2:26 am

#1999202
RE: how can I get uniqueidentifier value as return after insert a record

NB. This is an 8 year old post 🙂

July 5, 2018 at 4:06 am

#1996363
RE: How to search for Tabs from "Find" in SSMS v17.5

d_george - Friday, May 4, 2018 8:02 AM
Thanks, I did not have an Editor window open when I clicked Edit earlier.

May 4, 2018 at 8:09 am

#1989288
RE: How to search for Tabs from "Find" in SSMS v17.5

d_george - Friday, May 4, 2018 6:38 AM
I do not have an...

May 4, 2018 at 7:07 am

#1989263
RE: 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 '

May 1, 2018 at 1:53 am

#1988725

Viewing 15 posts - 16 through 30 (of 443 total)