Viewing 15 posts - 646 through 660 (of 1,246 total)
July 26, 2017 at 7:59 am
Next question... Are you familiar with the syntax differences between scalar & table functions, with regard to referencing them in your code?
July 25, 2017 at 3:51 pm
CREATE FUNCTION [dbo].[ufn_GetPlannersName]
(
@intFeasibilityRequestId BIGINT
)
RETURNS TABLE WITH SCHEMABINDING AS
RETURN
SELECT TOP 1...
July 25, 2017 at 3:50 pm
Yeah, there are a couple different functions in that query (in...
July 25, 2017 at 2:48 pm
In addition to what other's have said, the inclusion of a scalar valued function isn't doing you any favors either...dbo.[ufn_GetPlannersName](fr.feasibility_request_id) AS [Planner],
You should see a nice performance boost...
July 25, 2017 at 2:14 pm
July 21, 2017 at 11:06 am
I really appreciate the help. Thank...
July 21, 2017 at 10:43 am
See if this is producing the desired results...
IF OBJECT_ID('tempdb..#TestData', 'U') IS NULL
BEGIN -- DROP TABLE #TestData;
CREATE TABLE #TestData (
RowNum INT NOT NULL PRIMARY...
July 21, 2017 at 10:22 am
July 20, 2017 at 11:15 am
July 20, 2017 at 10:33 am
I want my refrigerator to do only two things... keep my stuff cold...
July 20, 2017 at 9:33 am
July 19, 2017 at 6:11 pm
I'd rather eat crushed glass than use either of the PIVOT or UNPIVOT operators. That's because they're both garbage. There are better ways to accomplish either, using manual cross tabs...
July 19, 2017 at 11:27 am
July 19, 2017 at 7:45 am
July 18, 2017 at 1:56 pm
Viewing 15 posts - 646 through 660 (of 1,246 total)