SELECT TimesheetKey, SiteKey, [Date],

SUMDuration = SUM(Duration) OVER(PARTITION BY SiteKey, [Date], GroupRule), GroupRule

FROM #TIMESHEET

Walton (7/27/2011)

---

Thanks Brandie.

I think i need to go with the option 1. But I am curious about the hidden ansi character. Would you please explain what is ansi hidden character...

It's not unusual.

Thanks for stepping up Brandie 🙂

I tried it with a 2-column and 3-column output. Since the result sets are both run into the same table, you get a column mismatch...

Here's an easy way but it depends upon the structure and content of the two result sets:

-- Make a test proc returning 2 result sets

CREATE PROCEDURE dbo.junk AS

SELECT SetID...

Thanks! Must admit though, it's borrowed from the teachings...

DECLARE @WordToCheck VARCHAR(30) = 'SQL SERVER'

SELECT Letter, COUNT(*)

FROM(

SELECT Letter = SUBSTRING(@WordToCheck, n.n, 1)

FROM (SELECT TOP 30 n = ROW_NUMBER() OVER(ORDER BY [Name]) FROM sys.columns) n

WHERE n.n <= LEN(@WordToCheck)

) d

WHERE Letter...

What datatype is the string?

DECLARE @Variable_Char CHAR(30), @Variable_Varchar VARCHAR(30)

SET @Variable_Char = 'String to measure '

SET @Variable_Varchar = 'String to measure '

SELECT LEN(@Variable_Char), LEN(@Variable_Varchar), DATALENGTH(@Variable_Char), DATALENGTH(@Variable_Varchar)

SELECT LEN(REPLACE(@Variable_Varchar,...

Decide on the logic then worry about the code. For instance, you could stop traversing if a previous number is reached and use the prior number. You could set a...

"...on server. It works fine on mine local machine..." - do you mean you have installed a local server and it runs ok there? Are the functions dbo.split the same...

Dom, can you confirm which version of SQL Server you are connecting to? Cheers.

You're absolutely right, good spot.

-- Naming a table [Index] is NOT advisable.

SELECT ad.ACCOUNTID, x.SecurityID,

MatchStatus = CASE WHEN a.ACCOUNTID IS NULL THEN 'Only in Index' ELSE 'Matched' END

FROM [INDEX] x

CROSS JOIN (SELECT DISTINCT...

Not much information to go on.

Run the following code and post back comments.

SELECT

OrgCode AS UnitState ,

OrgCode As State,

COUNT(*) AS Rows_Per_OrgCode

--IsNull(Count(*), 0) As [SLRP Approved]

FROM tLookup_StateTable...

Try this - IN and appropriate OUT on the same row:

;WITH SequencedData AS (

SELECT *,

PersonID = DENSE_RANK() OVER(ORDER BY strLastName, strFirstName),

rn = ROW_NUMBER() OVER (ORDER BY strLastName, strFirstName, datAdded)...