...
And one more time for a more common purpose where it converts a string of words delimited by commas to a table:
CREATE FUNCTION [dbo].[ufn_CommaStringToTable]
(
@CommaSeparatedValues ...
... [student_country_birth_code],
[student_country_domicile_code],
[student_nationality_code],
[student_ethnicity_code]
FROM
[sourcedb].[dbo].[events]
Simple bit of ...
... AS XML).query('data(/STAFF/GENDER)') AS VARCHAR(10)) AS Gender
FROM
[dbo].[XML_EVENTS]
-- Returns column GENDER for every record/row (eg. "Male")
Or
-- Using .value()
SELECT
CAST(Event_XML ...
... emp.ContributionValue=1 THEN 5010
WHEN emp.ContributionValue=2 THEN 5011
WHEN emp.ContributionValue=3 THEN 5012
ELSE 9999
END
FROM [dbo].[DMExtractEmployeeTable] emp
INNER JOIN [dbo].[DMExtractReferenceTable] ...
... of this page.
Go go go
Note that in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one.
-- drop a stored procedure if it exists
IF ...
... e.TimeStart, e.TimeEnd) [Total Time]
,RANK() OVER (ORDER BY e.[TimeStart] DESC) [Rank]
FROM
[ReportServer].[dbo].[ExecutionLogStorage] e
INNER JOIN
[ReportServer].[dbo].[Catalog] ...
... ,a.[Status]
,a.[ByteCount]
,a.[RowCount]
FROM [ReportServer].[dbo].[ExecutionLog] a
INNER JOIN [ReportServer].[dbo].[Catalog] b
ON a.ReportID = b.ItemID
The Top 5 Most ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.