SQL Padawan (8/20/2012)

---

The code below ran pretty fast on my desktop. Give it a try:

SELECT DISTINCT @holder1 = s1.SaleID,@holder2 = LocationID

FROM #Sale s1

INNER JOIN #SaleLocationXref SLX1 ON S1.SaleID = SLX1.SaleID

INNER...

Jeff Moden (8/20/2012)

---

I do need to make a correction to my last. It's not "non-Latin" collations that may have the problem... its usually the "Windows Collation" compared to "SQL...

Did you mean PIVOT?

Just a guess here but it looks like your data is trying to define a matrix of values with row and column delimiters of | and ^?

In that case, I'd...

No longer an enigma! This explains it pretty well.

I guess I'm going to need to read up some on collations.

Are you trying to get the mean (average) or median?

And why is B 7 and not 6?

I took a shot at it with this:

;WITH Sale AS (

SELECT a.SaleID, a.SaleStart, a.SaleEnd, b.LocationID, c.ItemID

FROM #Sale a

JOIN...

Jeff Moden (8/17/2012)

---

Just to clarify... there is no bug with REPLACE. It's a bug with just about anything that uses the "wrong" COLLATION. Even simple JOINs can be...

ChrisM@Work (8/17/2012)

---

HowardW (8/17/2012)

---

This sounds a really simplistic question, but based on what you've said, it should just be:

update xys set submitdate=NULL where id in ('1','2'.........'100')

I feel I must be missing...

vinu512 (8/17/2012)

---

Yes, that's the article I read to start with this. I...

Operating only with stone knives and bearskins at my disposal, I offer you this:

create table #emp(ename varchar(34),job char(33),sal varchar(22))

insert into #emp values('sa','sales','400')

insert into #emp values('ka','manager','4000')

insert into #emp values('sam','Markting','2500')

insert into #emp...

Correct. They are SQL 2005 features and this is a SQL 2008 forum.

demonfox (8/17/2012)

---

check out msdn for new additions in the 2008 ;the datatypes , filegroups , new keywords (MERGE,OUTPUT etc..)

for 2005 to 2008 you are good to go , for 2000...

ChrisM@Work (8/17/2012)

---

dwain.c (8/16/2012)

---

The quality of the hires will be roughly proportional to...

From the T-SQL perspective IMHO, the MERGE statement, table value constructors (TVC) and grouping sets are probably what I'd consider the most interesting. Add to that maybe User-defined table...