And here's a mashup of all 3 methods presented, with full aliasing and slightly changed field names, so that all the methods can be more easily compared. ...

One of the problems with "dumbed down" examples is that the solutions don't necessarily apply well to the full-scale real-world problem, often due to surprisingly simple differences that suddenly render...

As Sean indicates, you need to provide better information to get a good answer. From what you posted, we have no clear picture as to what you really...

Sean's query is exactly what I would code, but not without first running the following query to be absolutely certain that those names are unique:

SELECT COUNT(DISTINCT lastname) AS LAST_COUNT, COUNT(*)...

Unless you have other identifying information, all it will take to fail the process is two records in employee2 with the same value for lastname, but differing values for firstname....

Some of the runtime symptoms of the below suggested causes could be: 1.) sudden CPU usage spikes for however long this runs before it fails, or even 2.) a long...

pharmkittie (6/27/2014)

---

Thanks Steve. I appreciate the help. I called Microsoft before I got your reply. The person I spoke to said that we could buy SQL Server 2104,...

EDIT: Yep, Lynn, that would be mine. Oops... that's not right. It's the queries using MAX and MIN. The 'Z' value would throw those queries...

Here's another alternative that should perform well as it not only uses just one pass on the table, but uses NULLIF which usually is rather fast:

SELECT marker

FROM TEMP_A

GROUP BY marker

HAVING...

pharmkittie (6/25/2014)

---

I am unclear about whether we have to purchase 1 CAL for every named user (named meaning a person who will log in to a website developed in .NET...

SCH70 (6/24/2014)

---

If it were limited to T-SQL querying alone, then I think this would be fairly straightforward. Trying to incorporate that into SSRS's scripting would be difficult and laborious. ...

SCH70 (6/23/2014)

---

Well, after weighing some options I used a rectangle on the main report with subreports calling each of the five charts individually. I them left justified all five...

cbrammer1219 (6/23/2014)

---

Worked means successfully completed the operation of reading the data within the flat files, inserting it into a table as One column, then copy the file to a different...

We need more information. You say it "stopped working", but never said what the exact definition of "working" is, nor exactly what it means when you say it...

Taking a literal interpretation of the words you used, here's the code:

DECLARE @String varchar(500);

SET @String = '<p>Assessed By: Michael Jordan Yagnesh</p>

<p>Reviewed By: Fred Smith</p>

<p>Home Address</p>'

PRINT LEFT(@String, DATALENGTH(@String) - ISNULL(NULLIF(CHARINDEX('/<', REVERSE(@String)),0)...