Yes, that's exactly the kind of...

I really enjoyed the piece, Use SSIS to send emails[/url] by Joe Millay, and have used it as a basis for my own implementation.

The article does represent a complete...

Here's my quick stab at it. Not sure about performance on a super large data set, but maybe the framework will help.

- Adam

ifOBJECT_ID('tempdb..#Orders') IS NOT NULL DROP TABLE...

Here's one solution. Excuse my simplistic sample data. I wasn't sure by what conditions an NPI might not be distinct, so I included some duplicates to demonstrate that...

I knew when I wrote it...

After further thought, this one might be more flexible for you.

Again - I thought there might be more status codes you need to filter out other than just "1" so...

Here's a ultra-simplistic version.

- Adam

;with Claim_Status as

(

select 100 as [Claim Number] , 1 as [Status]

union all select 100, 3

union all select 101, 1

union all select 102, 1

union all select...

Try this:

If exists

(

select CPUTM

from [dbo].[System_Management_Facility]

where CPUTM > '0:00:55.38'

) PRINT 'GOOD'

On a side note, the question was not assigned a Category. I now have 2 points in category NULL, and 2 in category "No Category". I am not sure...

Or you can

select ASCII( col1 )

to see what nonprintable characters are in there.

(Keep in mind, that will only show you the first one.)

I, like Steve, have been intentional about trying to stretch my SQL skills this year. Part of that plan has been that I now follow a number of T-SQL...

From

http://msdn.microsoft.com/en-us/library/ms173854.aspx

Returns the angle, in radians, between the positive x-axis and the ray from the origin to the point (y, x), where x and y are the values of the two...

Something like this, I imagine:

UPDATEYourTable

SET[YourPathname] = REPLACE([YourPathname] , '\QA\' , '\PROD\' )

- Adam

SELECT

LEFT(Employee_Name , 12) as 'Employee First 12'

fromtbl_Employees

Does this get you close? I assumed that KEY and PMI were supposed to be the same field.

- Adam

;with [DATA] as

(

select 'DINO' as [PMI], '12345' as , '01/05/2015'...