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
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.