queries.sql

SELECT TOP (1000)
  [EmployeeID]
      , [LastName]
      , [FirstName]
      , [Title]
      , [Team]
      , [BirthDate]
      , [HireDate]
      , [ReportsTo]
      , [Address]
      , [City]
      , [Region]
      , [PostalCode]
      , [Country]
      , [WorkPhone]
      , [Extension]
      , [FaxNumber]
      , [HomePhone]
      , [MobilePhone]
      , [EmailAddress]
      , [Notes]
      , [RegionCvrd]
      , [ChristmasCard]
      , [Inactive]
      , [Password]
      , [EmployeeType]
      , [IsInternationalUser]
FROM [hs-prod3].[dbo].[Employees]
WHERE Inactive = 0 AND [Password] IS NOT NULL;


DELETE FROM [hs-prod3].[dbo].[Employees]
WHERE LastName = 'string' AND FirstName = 'string';

UPDATE [hs-prod3].[dbo].[Employees]
SET EmployeeID = 'RAJESH'
WHERE FirstName = 'RAJESH' AND LastName = 'KUMAR';


UPDATE [hs-prod3].[dbo].[Employees]
SET [Password] = 'Tucker21'
WHERE EmployeeID = 'MILDA';

-- Update the real table with the default password
-- rajeshg820
-- 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
UPDATE dbo.Employees
SET Password = 'Tucker21'
WHERE Password IS NULL OR LTRIM(RTRIM(Password)) = '';

SELECT *
FROM dbo.Bidders
WHERE ProjNo=15878;

SELECT *
FROM dbo.ProjectNotes
WHERE ProjectNo=15884;

SELECT *
FROM dbo.Projects
WHERE ProjectNo=15886;

SELECT *
FROM dbo.ContactAddress
WHERE ContactId IN (SELECT ContactId
FROM dbo.Contacts
WHERE CustomerId=16422);

SELECT *
FROM dbo.CustomerNotes
WHERE CustomerID=16428;

SELECT FollowupDate
FROM dbo.Customers
WHERE CustomerId=16428;

SELECT *
FROM dbo.FOB;

SELECT *
FROM dbo.EstFreight;

SELECT *
FROM dbo.ProductApplications;

SELECT COUNT(*)
FROM dbo.CompanyTypes
WHERE CustomerTypeID=1 AND Inactive=0;


SELECT *
FROM dbo.States
WHERE CustomerTypeID=1;

SELECT *
FROM dbo.LeadGeneratedFroms;

SELECT *
FROM dbo.Bidders
WHERE [Primary]=1 AND OrderNr IS NULL;

SELECT *
FROM dbo.Projects