Here's my suggestion:

WITH CTE AS(

SELECT pp.id AS pay_period_id,

pr.employee_no,

...

Everything that changes data in a database writes to trans log.

You might have some options to copy the table, but answer Eirikur's questions so we can have more details.

Are you sure? You better double check with him. :-D:hehe:

CREATE SCHEMA must be the only statement in the batch.

Weird enough, this is considered a single statement.

CREATE SCHEMA CLAIM

CREATE TABLE Claims( ClaimId int)

CREATE TABLE OtherTable( OtherId int)

Test 😉

Also, be aware that permissions are handled different between both options.

There's no best option. You have to define it based on...

To get a specific format from a date into a file, you need to convert it to string.

It's certainly easier to format with a SQL query than with SSIS. If...

Try this option: http://bfy.tw/79bE

I...

Here's an option. You can follow Phil's advice for a possible improvement on performance.

Use MSDB

Go

Select j.name,

j.[enabled],

B.run_date as [Last_Run_Date],

...

Y.B. (8/10/2016)

---

For your second requirement you can achieve that using a window function. If you want an example please provide DDL and sample data. Luis' signature has links...

Emmet Brown

Every output in a CASE statement should have the same type. When they don't SQL Server will try to do an implicit conversion following data type precedence.

To prevent this error,...

I haven't tested, but I've been told that it needs less resources and for that reason it run faster.

Each system has different needs, so it shouldn't be considered better or...

drew.allen (8/9/2016)

---

As long as you're under 24 hours you can use the following.

DECLARE @duration_sec INT = 1300

SELECT DATEADD(SECOND, @duration_sec, CAST('00:00' AS TIME))

This method should work for any unit of time...