• Got a Tipila, google, windows live or facebook account ?
Tips tagged: t-sql
1
votes
Here's how to do a union query with an order by clause SELECT * FROM (SELECT TOP 1 StartDate FROM dbo.ExportStatus WHERE PubSurveyVersion = @PublicationId ORDER BY StartDate DESC) t1 UNION SELECT * FROM (SELECT TOP 1 QueuedTime FROM dbo.ExportQueue WHERE PubSrvId = @PublicationId ORDER BY QueuedTime DESC) t2
1
Matching Tips
Search options
  • Use the syntax:
    seach text, tag1, tag2,...
    to search for tips with the given tags.
  • Add ,mytips to the search text to search within MyTips only.
  • Use the syntax:
    ,tag1, tag2,...  to get all tips with the given tags.
Login to Tipila