Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!
SELECT id, sName, iStatus FROM [SQL01].[dbo].[KPIDay]
not sure where I need the [sqldatabase].[dbo].[table
SELECT Lead_T.sName AS Expr1, LeadSource_T.sName, TransferClient_T.sName AS Client, TransferSubscription_T.sName AS Subs, LeadTransfer_T.zXUpdtdWhn AS Date, LeadTransfer_T.zXUpdtdBy AS [Updated By], TransferClient_T.id FROM TransferClient_T INNER JOIN LeadSource_T INNER JOIN LeadTransfer_T ON LeadSource_T.id = LeadTransfer_T.FKiSourceID INNER JOIN Lead_T ON LeadTransfer_T.FKiLeadID = Lead_T.id ON TransferClient_T.id = LeadTransfer_T.FKiClientID INNER JOIN TransferSubscription_T ON LeadTransfer_T.FKiSubscriptionID = TransferSubscription_T.id WHERE (LeadTransfer_T.zXUpdtdWhn BETWEEN CONVERT(DATETIME, '2012-10-29 00:00:00', 102) AND CONVERT(DATETIME, '2012-10-29 23:59:59', 102)) AND (TransferClient_T.id = 27) ORDER BY TransferClient_T.zXUpdtdWhn, Date, LeadSource_T.sName DESC
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Queries: Select, then Append, then Delete||8||33|
|Any benefit to adding a Clustered index here?||4||32|
|Rewriting a simple query||2||20|
Join the community of 500,000 technology professionals and ask your questions.