Please check this forum

http://qa.sqlservercentral.com/Forums/Topic462732-148-1.aspx

-- Get 2 latest orders for each part:

Select o1.*

From PURC_ORDER_LINE as o1

Join (Select o2.PART_ID, Max(o2.PURC_ORDER_ID) as od1

From PURC_ORDER_LINE as o2

...

Why even create a view, do a join between the tables and do a Cast(fieldname, int). See example below

SELECT dbo.Job.JobNumber AS JobId, dbo.empMain.firstname, dbo.empMain.lastname, dbo.timeCard.total_hr * DB1.dbo.sscERate.rate AS Hrs,

DATEADD(DAY, 7...

Can you please post the table structure with sample data.

Also the code that is linking the 2 tables

The only possible explanation I can give is it's falling into a "When" weirdness case.

May be the "When" invokes the newid() for each "when" and if the case has already...

I have not encountered a single else case with this statement listed below

Declare @myvarint

set @myvar= CAST(CAST(NEWID() AS VARBINARY) AS INT)

SELECT @myvar,

CASE (ABS(@myvar) % 10)

WHEN 0 THEN 22000

WHEN 1...

It is not possible to apply a transaction log backup:

* Unless the database or differential database backup preceding the transaction log backup is restored first.

...

Everything I hear these days are cloud based.

Virtualization is the way to go, doesn't really matter what products are being used.

Not sure about your question.

You are asking to provide a cred "View definition" permission and "Execute" permission?

If yes you can give such rights to the creds and not have to...

When any critical error / warning is reported by SQL Server Agent, it is written to a log file MSSQL\Log\SQLAgent.out. By default only critical errors and warnings are reported...

So is this logging related to SQL Server agent( like jobs etc)?

It's in the NSService.exe.config under sql server installation folder under notificationservices folder

For each of the items in the <switches> node, set the logging level by changing the value attribute.

To...

http://sqlblog.com/blogs/eric_johnson/archive/2010/10/28/calling-child-packages-in-ssis.aspx

check this article out

http://www.databasejournal.com/features/mssql/article.php/3572301/RowNumber-function-in-SQL-Server-2005.htm

I probably would check if those references exist in the script tasks and they are 64 bit compatible.