We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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.
Join the community of 500,000 technology professionals and ask your questions.