Try this

SELECT name

FROM sys.views

WHERe OBJECT_DEFINITION(object_id) LIKE '%where empid=%'

Great articles and timely (for me!). One question though, for the OLE DB Destination fast load, are there any recommended values for "Rows per batch" and "Maximum insert commit size"...

There's nothing built in, but you can use this function

http://www.sqlservercentral.com/Forums/FindPost944589.aspx

Yep, have been for a number of years now.

I may be wrong,...

Try this

SELECT s1.Member_ID,

s1.Eff_Date,

MIN(t1.Term_Date) AS Term_Date,

ROW_NUMBER() OVER(ORDER BY s1.Eff_Date)...

Thanks for the feedback!

DECLARE @T TABLE(item INT,pricecode INT,price INT)

INSERT INTO @T(item,pricecode,price)

SELECT 1018,1,100 UNION ALL

SELECT 1020,2,120 UNION ALL

SELECT 1031,1,90 UNION ALL

SELECT 1045,5,45 UNION ALL

SELECT 1018,2,120 UNION ALL

SELECT 1430,7,35 UNION ALL

SELECT 1020,3,95 UNION ALL

SELECT 1430,5,30;

WITH...

Not sure you understood myquery, but this should work

WITH CTE AS (

SELECT *,

ROW_NUMBER() OVER(PARTITION BY Name ORDER BY ID) AS rn

FROM mytablename)

UPDATE CTE

...

DECLARE @T TABLE(ID INT, Name VARCHAR(10), deleted INT)

INSERT INTO @T(ID,Name)

SELECT 1, 'Orange' UNION ALL

SELECT 2, 'Orange' UNION ALL

SELECT 3, 'RED' UNION ALL

SELECT 4, 'RED' UNION ALL

SELECT 5, 'RED';

WITH CTE AS...

SELECT Dept,EmpNum,

SUM(CASE WHEN IndCode='APP' THEN IndHours ELSE 0 END) AS APP,

SUM(CASE WHEN...

Also a minor change will give you the NULL for the latest end month

WITH CTE AS (

SELECT ProcessID, Month, Compliant,

ROW_NUMBER() OVER(PARTITION BY ProcessID...

It's quite a well known technique, just google for sql "gaps and islands".

Something like this?

WITH CTE AS (

SELECT ProcessID, Month, Compliant,

ROW_NUMBER() OVER(PARTITION BY ProcessID ORDER BY Month) -

ROW_NUMBER()...

Try this

DECLARE @t TABLE(ProcessID INT, Month INT, Compliant INT)

INSERT INTO @t(ProcessID, Month, Compliant)

SELECT 1,1,0 UNION ALL

SELECT 1,2,0 UNION ALL

SELECT 1,3,1 UNION ALL

SELECT 1,4,1 UNION ALL

SELECT 1,5,0 UNION ALL

SELECT 1,6,1;

WITH CTE...

The SELECT inside the brackets is known as a derived table, the 'x' is simply to give it a name (which is required by SQL Server)