SELECT pcs.MACHINE_NAME

October 5, 2018 at 3:00 pm

#2008396

A utility table would be more efficient and if you are using a case insensitive collation all it would need is the actual list of proper cased months. If you...

Test on a test or development server before deployment.

DECLARE @STR nvarchar(20)='''00000000000';
SELECT @STR String, Replace(@str, '''', '') ReplacedString;

Ditch your DTS. In SSMS use the Import wizard to generate a package to do the import, save it to the file system. Create a new project in SSDT, delete...

https://blogs.technet.microsoft.com/heyscriptingguy/2009/08/13/hey-scripting-guy-can-i-query-a-microsoft-access-database-with-a-windows-powershell-script/
https://stackoverflow.com/questions/25682703/connect-to-sql-server-database-from-powershell

Use dynamic SQL and build your query joining sys.tables and sys.columns on object_id where is_identity = 0 and a cursor.

PowerShell or VB script and a Windows Task Scheduler job would be the easiest to automate.

I suggest using Registered Servers in SSMS and registering all your SQL Servers under a Server Group then right click the group and select new query. In the new query...

WITH t (EName, UnitsSold, Category)
AS
   (
   SELECT *
   FROM (VALUES ('Nik',    12, 'Red')
, ('Bob',    10, 'Red')
, ('Luis',   10, 'Red')
, ('James',  ...

WITH x
AS
(Select A.EMP
     , A.SpanReason
     , A.EventStartOrEndDate
     , ROW_NUMBER() OVER (PARTITION BY A.EMP ORDER BY A.EventStartOrEndDate ) as RN
FROM
  ...

Check out this thread

Add a Row_number() OVER(PARTITION BY mac

September 26, 2018 at 5:37 pm

#2007174