SQLAuthority News – Article 1100 and Community Service

8 Comments. Leave new

• 

  jacob sebastian

  September 22, 2009 8:07 am

  Congratulations Pinal for achieving the “1100th post milestone”. Looking forward to see 1500th post on 18-07-2010 and 2000th Post on 30-11-2011 :-)

  (readers, ask me how I got those dates! :-))

  Reply
• 

  jacob sebastian

  September 22, 2009 10:15 am

  hint: I used a TSQL built-in function to get those dates
  :-)

  Reply
• 

  Tejas Shah

  September 22, 2009 10:24 am

  Congratulations Pinalbhai to achieve this milestone.

  What is the formula to calculate those dates?

  I tried but didn’t get idea behind it.

  Tejas

  Reply
• 

  Ritesh Shah

  September 22, 2009 2:18 pm

  Hi Pinal,

  Congratulations from hear!!!!! you are doing really great. keep doing great work and keep inspiring people like me :)

  thanks for all your direct and indirect support and many thanks for being always available for all technical and non-technical issues.

  Thanks,

  Ritesh Shah

  Reply
• 

  Vijay Anand Kannan

  September 23, 2009 9:46 pm

  Jacob,

  How you got those date?. If i go by 1500 Article Calculation, it matches for 2000th Article.

  But if i go current date, it does not matches.

  Select DateAdd(Day,400,GetDate()),DateAdd(Day,900,GetDate())

  Select DateAdd(Day,500,’07/18/2010′)

  Just for the Interest.

  Let me know

  Thanks

  Vijay Anand Kannan

  Reply
• 

  Zafar Iqbal

  September 24, 2009 11:48 am

  Hi Pinal,

  Congratulations for getting a huge achiement.

  Reply
• 

  Hardik

  December 21, 2009 1:30 pm

  Hello Pinal,

  I need to create wild query with following condition.

  Give all records where Name does not contain ‘Sto’ any where in data.

  I can get the correct result if I use query like this:
  –Correct query
  select * from Production.Location where Name not like ‘%Sto%’

  But I cannot use “not like” because some architectural constraints.

  So I am trying to use following kind of query:
  select * from Production.Location where Name like ‘%[^S][^t][^o]%’

  But this is not providing the correct result.

  Could you help me correcting this query?

  (Note: I have used “AdventureWorks” database in above query)

  Thanks,
  Hardik

  Reply