Click here to Skip to main content
15,885,754 members
Home / Discussions / Database
   

Database

 
GeneralRe: Select count on 2 DBF files Pin
jkirkerx27-Oct-14 12:23
professionaljkirkerx27-Oct-14 12:23 
QuestionRewrit a Scalar function to a table valued function Pin
Ambertje21-Oct-14 0:00
Ambertje21-Oct-14 0:00 
AnswerRe: Rewrit a Scalar function to a table valued function Pin
Mycroft Holmes21-Oct-14 0:25
professionalMycroft Holmes21-Oct-14 0:25 
GeneralRe: Rewrit a Scalar function to a table valued function Pin
Ambertje21-Oct-14 1:40
Ambertje21-Oct-14 1:40 
GeneralRe: Rewrit a Scalar function to a table valued function Pin
Richard Deeming21-Oct-14 2:00
mveRichard Deeming21-Oct-14 2:00 
GeneralRe: Rewrit a Scalar function to a table valued function Pin
Ambertje21-Oct-14 2:25
Ambertje21-Oct-14 2:25 
GeneralRe: Rewrit a Scalar function to a table valued function Pin
Mycroft Holmes21-Oct-14 12:52
professionalMycroft Holmes21-Oct-14 12:52 
SuggestionRe: Rewrit a Scalar function to a table valued function Pin
Richard Deeming21-Oct-14 1:55
mveRichard Deeming21-Oct-14 1:55 
Try adding WITH SCHEMABINDING to your functions, between the RETURNS <type> and As lines.
http://www.sqlservercentral.com/blogs/sqlstudies/2014/09/15/i-schemabound-my-scalar-udf-and-you-wont-believe-what-happened-next/[^]


ISNUMERIC is not reliable. All of the following values will be considered numeric, but cannot be cast to an integer:
  • ISNUMERIC('-')
  • ISNUMERIC('.')
  • ISNUMERIC('-$.')

If you're using SQL 2012 or higher, use the new TRY_PARSE function[^] instead. Otherwise, test that the string doesn't contain any non-numeric characters:
SQL
If @ValueString Like '%[^0-9]%' Or @ArticleString Like '%[^0-9]%'
Begin
    -- Either @ValueString or @ArticleString are not valid integers.
    set @result = 0
End



Assuming you're starting with a date or datetime / datetime2 type, your CONVERT_DATE_TO_NUMERIC function can be replaced with:
SQL
Convert(int, Convert(char(8), YourDateColumn, 112))

Passing 112 to the Convert function[^] formats the date as yyyyMMdd. Converting that to an integer gives the same result as your function.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


AnswerRe: Rewrit a Scalar function to a table valued function Pin
Eddy Vluggen21-Oct-14 2:33
professionalEddy Vluggen21-Oct-14 2:33 
QuestionStored Procedure for Item Allotment Pin
avisharma@sharma19-Oct-14 20:01
avisharma@sharma19-Oct-14 20:01 
QuestionRe: Stored Procedure for Item Allotment Pin
Jörgen Andersson19-Oct-14 21:22
professionalJörgen Andersson19-Oct-14 21:22 
AnswerRe: Stored Procedure for Item Allotment Pin
avisharma@sharma19-Oct-14 23:04
avisharma@sharma19-Oct-14 23:04 
GeneralRe: Stored Procedure for Item Allotment Pin
Shweta N Mishra20-Oct-14 2:24
professionalShweta N Mishra20-Oct-14 2:24 
GeneralRe: Stored Procedure for Item Allotment Pin
avisharma@sharma27-Oct-14 2:42
avisharma@sharma27-Oct-14 2:42 
GeneralRe: Stored Procedure for Item Allotment Pin
Shweta N Mishra27-Oct-14 3:37
professionalShweta N Mishra27-Oct-14 3:37 
GeneralRe: Stored Procedure for Item Allotment Pin
Jörgen Andersson20-Oct-14 4:53
professionalJörgen Andersson20-Oct-14 4:53 
QuestionCheck if email for each specific recipient was sent or not sql server 2008 Pin
bjay tiamsic19-Oct-14 0:25
bjay tiamsic19-Oct-14 0:25 
AnswerRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
Wendelius19-Oct-14 0:41
mentorWendelius19-Oct-14 0:41 
GeneralRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
bjay tiamsic19-Oct-14 17:58
bjay tiamsic19-Oct-14 17:58 
GeneralRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
Wendelius19-Oct-14 18:20
mentorWendelius19-Oct-14 18:20 
SuggestionRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
Richard Deeming20-Oct-14 2:16
mveRichard Deeming20-Oct-14 2:16 
GeneralRe: Check if email for each specific recipient was sent or not sql server 2008 Pin
Wendelius20-Oct-14 17:23
mentorWendelius20-Oct-14 17:23 
QuestionSQL report to get average amount of time for helpdesk closures Pin
Danpeking17-Oct-14 3:29
Danpeking17-Oct-14 3:29 
AnswerRe: SQL report to get average amount of time for helpdesk closures Pin
GuyThiebaut17-Oct-14 3:45
professionalGuyThiebaut17-Oct-14 3:45 
AnswerRe: SQL report to get average amount of time for helpdesk closures Pin
Wendelius17-Oct-14 3:47
mentorWendelius17-Oct-14 3:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.