Click here to Skip to main content
15,877,573 members
Home / Discussions / Database
   

Database

 
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 
AnswerRe: Rewrit a Scalar function to a table valued function Pin
Eddy Vluggen21-Oct-14 2:33
professionalEddy Vluggen21-Oct-14 2:33 
I'm going to suggest something weird.

It looks as if you are using the scalar function to convert a single column into another. That could also be done before your query is executed, and that "might" save time. Might, as I haven't tested it Smile | :)

Add the required int-column for the date, and run an update-query to do the conversion. Your table is now one column larger, but lost a calculation. You could keep the converted date consistent by updating them over a trigger when a record is inserted/modified. If you're not allowed to modify the original table, you can always create a new table and add the primary key of the original.

That way you can eliminate the need for the function completely, and move the calculation to the moment the records is inserted/updated. That delay may be hardly noticeable when manipulating a single record, while it adds up to a lot of calculations if it has to be done "on the fly".
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

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 
GeneralRe: SQL report to get average amount of time for helpdesk closures Pin
GuyThiebaut17-Oct-14 4:16
professionalGuyThiebaut17-Oct-14 4:16 

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.