Skip to content

Instantly share code, notes, and snippets.

@Mooophy

Mooophy/err.sql

Created January 26, 2017 03:01
Show Gist options
  • Save Mooophy/19feec412f878e110dea7922934b3667 to your computer and use it in GitHub Desktop.
Save Mooophy/19feec412f878e110dea7922934b3667 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
err.sql
exec sp_executesql N'SELECT ExpertQuery.Time.TimekeeperEmployeeId AS [Time.TimekeeperEmployeeId], ExpertQuery.Time.TimekeeperEmployeeIdSummary_PrimaryText AS [Time.TimekeeperEmployeeIdSummary.PrimaryText], ExpertQuery.Time.TimekeeperEmployeeIdSummary_SecondaryText AS
[Time.TimekeeperEmployeeIdSummary.SecondaryText], ExpertQuery.Time.TimekeeperEmployeeIdSummary_CodeText AS [Time.TimekeeperEmployeeIdSummary.CodeText], ExpertQuery.Time.ClientMatterDisplay AS [Time.ClientMatterDisplay], ExpertQuery.Time.MatterId AS [Time.MatterId], ExpertQuery.Time.MatterIdSummary_PrimaryText AS [Time.MatterIdSummary.PrimaryText], ExpertQuery.Time.MatterIdSummary_SecondaryText AS [Time.MatterIdSummary.SecondaryText], ExpertQuery.Time.MatterIdSummary_CodeText AS [Time.MatterIdSummary.CodeText], ExpertQuery.Time.TransactionDate AS [Time.TransactionDate], ExpertQuery.Time.TobillHours AS [Time.TobillHours], ExpertQuery.Time.ToBillAmount AS [Time.ToBillAmount], ExpertQuery.Time.PhaseTaskId AS [Time.PhaseTaskId], ExpertQuery.Time.PhaseTaskIdSummary_PrimaryText AS [Time.PhaseTaskIdSummary.PrimaryText], ExpertQuery.Time.PhaseTaskIdSummary_SecondaryText AS [Time.PhaseTaskIdSummary.SecondaryText], ExpertQuery.Time.PhaseTaskIdSummary_CodeText AS [Time.PhaseTaskIdSummary.CodeText], ExpertQuery.Time.ActivityId AS [Time.ActivityId], ExpertQuery.Time.ActivityIdSummary_PrimaryText AS [Time.ActivityIdSummary.PrimaryText], ExpertQuery.Time.ActivityIdSummary_SecondaryText AS [Time.ActivityIdSummary.SecondaryText], ExpertQuery.Time.ActivityIdSummary_CodeText AS [Time.ActivityIdSummary.CodeText], ExpertQuery.Time.ProjectId AS [Time.ProjectId], ExpertQuery.Time.ProjectIdSummary_PrimaryText AS [Time.ProjectIdSummary.PrimaryText], ExpertQuery.Time.ProjectIdSummary_SecondaryText AS [Time.ProjectIdSummary.SecondaryText], ExpertQuery.Time.ProjectIdSummary_CodeText AS [Time.ProjectIdSummary.CodeText], ExpertQuery.Time.TimeNarrative AS [Time.TimeNarrative], ExpertQuery.Time.TimePrebillNarrative AS [Time.TimePrebillNarrative] FROM ExpertQuery.Time WHERE Time.WipStatusEnum = @Time_WipStatusEnum;',N'@Time_WipStatusEnum tinyint',@Time_WipStatusEnum=66
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment