• Got a Tipila, google, windows live or facebook account ?
Tips tagged: sql
0
votes
use this to remove duplicates update ScrOutRespondentsCompleted set Partition = -888 where Id in( select max(id) from ScrOutRespondentsCompleted where partition = 1204 group by RespondentId having COUNT(*) > 1 ) and Partition = 1204
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
2
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