Jeff Moden (12/21/2011)

---

...Even though that works, what are you going to do with first names that begin with a salutation, last names that end with other titles and suffixes, and...

DECLARE @GroupPartitionSize INT

SET @GroupPartitionSize = 6 -- 700 in your actual data

SELECT

grp_no,

cnt, -- workings, not part of solution

...

drew.allen (12/21/2011)

---

Actually it sounds like he wants to overwrite the existing column if both the existing...

This is very very basic TSQL and looks like homework. Please read the link in my sig which will show you how best to ask questions and post sample data....

Hi Andrew

Firstly, try the MERGE statement for upserts, that's what it's for and it makes for clear and performant code.

Secondly, use COALESCE(ExistingColumn, StagingColumn) like this to handle the NULL issue:

ExistingColumn...

alishaik001 (12/21/2011)

---

My actual query is:

here Name is the fieldName and Employee is the TableName;

SELECT Name FROM Employee GROUP BY Name HAVING ( COUNT(Name) >= 1 );

From this query I got...

Can you post the actual query you are using? The query...

VIG (12/21/2011)

---

2 ChrisM@home

even more simple 🙂declare @subgroupsize int

set @subgroupsize=3

select dense_rank() over(order by act,grp desc) grp_no,1+(rn-1)/@subgroupsize grp_sub_no

,grp,member,act

from

(select * ,ROW_NUMBER() over(partition by act,grp order by (select...

mikes84 (12/20/2011)

---

Thanks for the response, Chris. Would you mind explaining this line a little bit more?

grp_sub_no = ((rn+2)/3*3)/3

The actual number I'd like to split the groups up by is 700....

Hi Mike

NTILE() is great for splitting tables into equal partitions for e.g. marketing, I think this better suits your requirement:

SELECT

grp_no,

grp_sub_no = ((rn+2)/3*3)/3,

grp,

member,

act

FROM (

SELECT...

Left-join table2 twice, once for each condition. Resolve the dispute in the WHERE clause and the output using CASE.

APPLY is explained in Paul White's papers - links are in my sig. It's somewhat similar to putting a correlated subquery in the FROM list. Read the papers - APPLY...

ramadesai108 (12/19/2011)

---

I have this query:

SELECT COUNT(*)

FROM Departments INNER JOIN

...

Hi Doug, welcome to the forum. This is a Running Total project, and there are several ways of getting the output you're expecting. The fastest is the Quirky Update (QU),...

Revenant (12/18/2011)

---

L' Eomot Inversé (12/18/2011)

---

. . . Perhaps it would be good to get together, preferably somewhere with a good range of whiskies. . . . But I'm based in...