SQL SERVER - Cannot resolve collation conflict for equal to operation

June 11, 2007 by pinaldave

Cannot resolve collation conflict for equal to operation.

In MS SQL SERVER, the collation can be set in column level. When compared 2 different collation column in the query, this error comes up.

SELECT ID
    FROM ItemsTable
            INNER JOIN AccountsTable
    WHERE ItemsTable.Collation1Col = AccountsTable.Collation2Col

If columns ItemsTable.Collation1Col and AccountsTable.Collation2Col have different collation, it will generate the error “Cannot resolve collation conflict for equal to operation“.

To resolve the collation conflict add following keywords around “=” operator.

SELECT ID
    FROM ItemsTable
            INNER JOIN AccountsTable
    WHERE ItemsTable.Collation1Col COLLATE DATABASE_DEFAULT
    = AccountsTable.Collation2Col COLLATE DATABASE_DEFAULT

Collation can affect following areas:
1) Where clauses
2) Join predicates
3) Functions
4) Databases (e.g. TempDB may be in a different collation database_default than the other databases some times)

Reference : Pinal Dave (http://www.SQLAuthority.com)

Posted in Pinal Dave, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Error Messages, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Server DBCC, SQL Tips and Tricks, T SQL, Technology | 117 Comments

117 Responses to “SQL SERVER - Cannot resolve collation conflict for equal to operation”

on June 12, 2007 at 11:52 am Andrea

Thank you!! It really works!!
on July 2, 2007 at 4:12 am vaibhav

Thanks for the solution
on July 4, 2007 at 12:59 am Vlad

thanks for that! it really helped me
on July 6, 2007 at 3:22 am Santosh

Thanks a lots for simple and easy answer.
on July 12, 2007 at 9:27 am Rory

Agreed. Very helpful.
on July 18, 2007 at 12:06 am Mlden

Grerat!
on July 20, 2007 at 6:28 am Bairavi

Thanks a lot. Its very helpful to resolve the problem.
on July 21, 2007 at 4:20 am Tanuja

Thanks a lot. That was quick and simple answer.
on July 24, 2007 at 6:20 am Fabricio

Thank’s! The Best Solucion!
on July 29, 2007 at 4:49 am Gareth Stretch

Thanks for the help, I am still having a problem though maby i am being stupid. in my case i have a union select. see example

select top 10 ‘Listings’ as SearchItem , id as SearchResultID ,’Listings.aspx’ as PageToLoad ,Description as SearchDetail from StudentDirectoryItems
where Description like ‘%’ + @SearchValue + ‘%’ or Address like ‘%’ + @SearchValue + ‘%’ or PhoneNumbers like ‘%’ + @SearchValue + ‘%’ and VarsityID = @VarsityID
union

select top 10 ‘News’ as SearchItem , News.id as SearchResultID ,’HomePageNews.aspx?newsID’ as PageToLoad , News.ShortDescription as SearchDetail from News
left outer JOIN VarsityNews ON News.ID = VarsityNews.NewsID
where News.ShortDescription COLLATE DATABASE_DEFAULT like ‘%’ + @SearchValue COLLATE DATABASE_DEFAULT + ‘%’ or News.DisplayDescription COLLATE DATABASE_DEFAULT like ‘%’ + @SearchValue COLLATE DATABASE_DEFAULT + ‘%’ and VarsityNews.VarsityID = @VarsityID
union

Your help will be much appreciated.
on July 29, 2007 at 5:55 am pinaldave

Gareth,

change your code like :
where News.ShortDescription COLLATE DATABASE_DEFAULT like ‘%’ + @SearchValue + ‘%’ COLLATE DATABASE_DEFAULT or

Regards,
Pinal Dave (http://www.SQLAuthority.com)
on August 10, 2007 at 2:55 am Madboy

Thanks! It worked
on August 10, 2007 at 8:28 am Andreas

Hi Pinal
i have the following query:

SELECT
Site.Site__ID,
Site.Site_Type,
Site.Site_Post_Code,
Site.Site_Town,
Site.Site_PhaseName,
Site.Site_Name,
Office.Office__ID,
Office.Office_Type,
Office.Office_Status,
Office.Office_Name,
[User].User_Organisation,
[User].User_PhaseName,
[User].User_FullName,
[User].User_EmailAddress
FROM Site WITH (NOLOCK)
LEFT JOIN
Site_SiteToOffice ON Site.Site__ID = Site_SiteToOffice.Site__ID
LEFT JOIN
Office ON Site_SiteToOffice.__Office__ID = Office.Office__ID
LEFT JOIN
Office_OfficeToUser ON Office.Office__ID = Office_OfficeToUser.Office__ID
LEFT JOIN
[User] ON Office_OfficeToUser.__User__ID = [User].User__ID
LEFT JOIN
Site_SiteToUser ON Site.Site__ID = Site_SiteToUser.Site__ID AND [User].User__ID = Site_SiteToUser.__User__ID
where
(len (@CompanyName_key)=0 OR Office_Name COLLATE DATABASE_DEFAULT like @CompanyName_key )
AND (len (@UserName_key)=0 OR User_FullName COLLATE DATABASE_DEFAULT like @UserName_key )
AND (len (@UserEmail_key)=0 OR User_EmailAddress COLLATE DATABASE_DEFAULT like @UserEmail_key )
AND (len (@SiteName_key)=0 OR Site.Site_Name COLLATE DATABASE_DEFAULT like @SiteName_key )

Although i have placed the collate database_deafault i still get the error? any suggestions?
on August 10, 2007 at 8:35 am Andreas

neddless to say that the parameters where decalred earlier on etc.
on August 10, 2007 at 9:15 am LEWIS

thanks!
on August 13, 2007 at 5:45 pm Mente

Chingón!
on August 14, 2007 at 11:12 am Dru

Very Helpful….thanks.
on August 16, 2007 at 12:16 pm SHAMEL

This work , very helpful
Thanks
on August 17, 2007 at 8:59 am Rafael

Hi!!!

How can i use the COLLATE DATABASE_DEFAULT in this update

update a set area = b.area from tbl_lnventas as a
inner join [10.105.162.223].dbunica3.dbo.cat_entidad as b on b.codigolada = left(a.ctelefono,8)
where a.area=”
go
on August 27, 2007 at 2:01 pm Jeffrey

Great help! I ran into an issue with a case statemen and found an answer that might be helpful to someone else. Looked up “Collation Precendence” in books online and found a quick solution to a problem I don’t have time to fix the root cause for:

SELECT (CASE WHEN id > 10 THEN GreekCol ELSE LatinCol END) COLLATE DATABASE_DEFAULT
FROM TestTab
on August 30, 2007 at 7:41 am SQL SERVER - 2005 - Find Database Collation Using T-SQL and SSMS Journey to SQL Authority with Pinal Dave

[...] 30th, 2007 by pinaldave This article is written based on feedback I have received on SQL SERVER - Cannot resolve collation conflict for equal to operation. Many reader asked me how to find collation of current database. There are two different ways to [...]
on September 3, 2007 at 9:53 am GAP

Thanks a lot!
on September 12, 2007 at 9:12 am filip

Thanks for your advice with the collation error, it saved us lot of time.
on September 12, 2007 at 11:20 pm Lieven

Eersteklas!
Works like a charm!
on September 13, 2007 at 6:59 am Percy

Gracias, me saco del problema
on September 14, 2007 at 10:41 am veronica

Thank!!!
on September 14, 2007 at 1:01 pm Andy

let me be # 27 to say thanx…
on September 20, 2007 at 5:29 am Will

Thanks dude -you’ve made life easier!
on September 20, 2007 at 9:21 am langdotnet

Thanks!!!
on September 24, 2007 at 10:02 pm Qumrul Hasan

Thanks a lot. !!!
on September 26, 2007 at 3:59 am J. Bornemann

Great help!
Googled “Cannot resolve collation conflict for equal to operation” and the first hit was this perfect solution!

Many Thx!
on October 16, 2007 at 6:28 pm kaven

Hi,

I got the errros below, did anyone know about it?
Expression type int is invalid for COLLATE clause

Thanks
on October 22, 2007 at 10:41 am Oxana

Thank you so much! Nice and easy solution!
on October 24, 2007 at 2:40 am Farzad

Thanks!!! It Realy Works !!!
on October 30, 2007 at 6:38 am rpd

Thanks! This worked well for a database move I’m working on. I needed to concatenate a bunch of obsolete fields to dump into another new field. Here’s my example:

select
‘varchar_field1: ‘+varchar_field1+’
varchar_field2: ‘+varchar_field2+’
varchar_field3: ‘+varchar_field1+’
text_field1: ‘+cast(text_field1as varchar(800)) COLLATE DATABASE_DEFAULT
from my_table

Without collate database_default, I’d get this error:
Cannot resolve collation conflict for column 1 in SELECT statement.
on November 3, 2007 at 3:21 am Jason

Great… Going live with a major project and this little gem was a sweet, quick and perfect resolution

Cheers
on November 5, 2007 at 11:56 pm Dhong

Superb!!! Thank you!
on November 14, 2007 at 12:38 pm amer ms

hi

i too face this problem and found that the collation of one of the database is different. now i want to make the collation same. can i change the collation of an existing database and will it update collation for all existing tables and columns of that database.
on November 15, 2007 at 12:55 am Bola

Thank you,

Really appreciate it.
on November 19, 2007 at 11:38 am hiren shah

This work , very helpful to you
It Realy Works !!!
Thanks
on November 20, 2007 at 2:10 am Mark

Wow this works but just wondering why it works?

Thanks
on November 20, 2007 at 9:48 pm me

Thanks a lot
on November 22, 2007 at 2:33 pm Lovely

HI Mr. Pinal Dave, such a great help, the collation problem wasnt there o the query i sent earlier, bacause that was incomplete…

the complete query plus the solution:::

set @str = ’select t0.docnum as SORefNo, t0.DocDueDate as SODocDueDate, t0.cardCode as CustomerCode, t7.cardName as CustomerName,
t1.itemcode as ItemCode, t4.ItemName as ItemName, t5.WhsName as WareHouseName, t6.U_NAME as UserName,
t1.quantity as SOQty, t2.quantity as SIQty,
case
when t1.quantity<=t2.quantity then 0 else t3.quantity
end as DraftSIQty, t1.quantity - t2.quantity as ”BackOrder”
from ordr t0 inner join
rdr1 t1 on t0.docentry=t1.docentry inner join
ocrd t7 on t0.CardCode=t7.CardCode inner join
ousr t6 on t0.Usersign=t6.UserId inner join
oitm t4 on t1.itemcode=t4.itemcode left join
owhs t5 on t1.Whscode=t5.Whscode left join

(select t10.draftkey, t11.baseentry, t11.baseline, t11.quantity from
oinv t10 inner join inv1 t11 on t10.docentry=t11.docentry) t2 on
t2.baseentry=t1.docentry and t2.baseline=t1.linenum left join
drf1 t3 on t3.baseentry=t1.docentry and t3.baseline=t1.linenum and (t2.draftkeyt3.docentry or t2.quantity is null)
where (t0.docduedate between ”’+convert(varchar(20),@startDate,102)+”’ and ”’+convert(varchar(20),@EndDate,102)+”’ ) ‘

– @whsCode
if ( @whsCode ‘NULL’ )
Begin
SET @str = @str + ‘ and ( (t1.Whscode COLLATE DATABASE_DEFAULT in (Select Value from fnSplitter(”’+ @whsCode +”’) ) ) or (t1.Whscode COLLATE DATABASE_DEFAULT is null) )’
End
Else
Begin
SET @str = @str + ‘ and((t1.Whscode in (t1.Whscode)) or (t1.Whscode is null))’
End
SET @str = @str + ‘ and not(t2.quantity is null and t3.quantity is null) ‘
SET @str = @str + ‘ order by docnum ‘

exec (@str)

Mr.Pinal, ur such a genius, i want to be ur friend.. u may not be aware but u helped me already with a lot of things, ur articles was so useful…..thanks thanks for the solution… :D:D:D
on November 27, 2007 at 8:05 pm Jean

Thanks a million for the blog post Pinal.

Very usefull stuff.

:)

Jean
on November 28, 2007 at 4:38 pm Madhumita

Thanks a lottttttt!!!!! It worked!
on November 29, 2007 at 4:31 pm Aftab

HI Mr. Pinal Dave,

How can we change the collation of a column???

what r the different types of collation in MS Sql??

Please help me asp.
Thanks in advance…
on November 29, 2007 at 4:33 pm Aftab

HI Mr. Pinal Dave,

I want to find the list of those employees whose name starts with either A or B without using union query.
on November 30, 2007 at 3:42 pm Jason

Thanks Pinal,

Saved me a lot of searching.

Jason ;-)
on December 5, 2007 at 12:43 pm Marlene

Could you please help, i get the collation error with this query:
SELECT *
FROM ctbl_ReplenishOrders RO
left JOIN #tbl_OutputOrdered OO ON RO.OrderDate = OO.OrderedDate AND RO.Itemcode COLLATE DATABASE_DEFAULT = COLLATE DATABASE_DEFAULT OO.ItemCode
WHERE OO.Itemcode IS NULL

Even though i am trying your collation solution, it seems still not to work. Can you please help?
Many thanks!marlene
on December 9, 2007 at 6:09 pm Ehsan

wow, u r wonderful dude
on December 12, 2007 at 5:09 pm John

PD - thanks for the post!

Marlene , try:

SELECT *
FROM ctbl_ReplenishOrders RO
left JOIN #tbl_OutputOrdered OO ON RO.OrderDate = OO.OrderedDate AND RO.Itemcode COLLATE DATABASE_DEFAULT = OO.ItemCode COLLATE DATABASE_DEFAULT
WHERE OO.Itemcode IS NULL
on December 12, 2007 at 9:03 pm srn

Thanks Pinal,
It works.
on December 12, 2007 at 10:16 pm Subu

Excellent this worked perfectly. Thanks!!!
on December 13, 2007 at 12:44 pm RW

Very useful tip. Thanks, perfect answer!
on December 13, 2007 at 6:42 pm Miikka Salonen

Thanks. I had problem with temporary table in join and this was nice and easy fix!
on December 19, 2007 at 1:33 am Karen

Thanks so much for the tip! It was very helpful.
on December 21, 2007 at 11:15 pm Carlos (phi)

Gracias, salvaste mi dia XD.
Thank you saved my day XD.
on January 16, 2008 at 6:14 pm BT

Thankyou , really helped me.
on January 18, 2008 at 5:05 am David Naas

It’s works! you kick ass dude
on January 29, 2008 at 8:20 pm John Motson

Thanks Pinal, that saved the day for me!

John
on January 30, 2008 at 12:05 am sudharsan

Hi dave….awesome….a solution made to look so simple for quite a complex problem (it was definetly complex for me…:)…thanks a ton
on January 30, 2008 at 2:27 am Sheau Jeng

Very helpful! Thank you…
on February 4, 2008 at 8:43 pm Turker Tunali

Great help. It really works. Great job.
that saved the day for me
on February 14, 2008 at 4:42 pm Greg

Excellent - simple post and resolved my problem - much appreciated!!
on February 15, 2008 at 12:14 am John Yoder

Worked for me. Thanks for the post!
on February 15, 2008 at 12:31 pm liquidskinn

hey, thanks so much for posting this. it really helped me. so much. :D

thanks thanks thanks! :)
on February 15, 2008 at 5:36 pm Graham

brill thanks, got me out of sticky jam
on February 29, 2008 at 8:10 pm jack

Great! Huge thank you! Regret that I haven’t found this earlier.
on March 18, 2008 at 12:37 pm Mindaugas

Wow man, it works. Very appreciate….
on March 19, 2008 at 11:20 am Ehsan

Great, it is a great help
on March 20, 2008 at 5:57 am Bin

Very good mate, thanks
on March 28, 2008 at 9:44 pm Visgor

I’m trying the following syntax:

SELECT count(*) FROM [f_matter] M (nolock) LEFT JOIN #Matter T ON M.matter_Num COLLATE SQL_Latin1_General_Pref_CP850_CI_AS = COLLATE SQL_Latin1_General_Pref_CP850_CI_AS T.Matter

Getting error “Incorrect syntax near ‘COLLATE’.”
Please help. What am I doing wrong?
Thanks
on April 1, 2008 at 12:55 pm Eugene

Thanks a million,. you are a lifesaver.
on April 10, 2008 at 4:23 pm Amit Garg

Simply Great help…….
on April 14, 2008 at 3:56 pm Vergil

Thanks a lot :-)
on April 14, 2008 at 5:47 pm Melody

Thank you too much! It’s helpful!
on May 5, 2008 at 2:30 am salman

Thanks a lot, it happend to me in a case statement.
on May 13, 2008 at 2:07 pm Manjula

Hello, Marvellous Dave….it really worked for me. Thank you very much.

Cheers :)
on May 13, 2008 at 6:17 pm Shearer

Great, strange issue i felt. Thanks for the solution.
on May 26, 2008 at 10:45 am aibvhiey

thanks a lot..
on May 26, 2008 at 11:04 am aibvhiey

thank you very very much..
on May 27, 2008 at 2:47 pm Nives

Thank you very much! It is a great help!
on June 4, 2008 at 8:33 am krisna

thank you sir, you save my day ^^
on June 4, 2008 at 9:37 am Thiam Hooi

Great solution from the original post… Thanks a lot
on June 12, 2008 at 3:39 pm shahzad

Thank you very much! It is a great help!
on June 16, 2008 at 7:53 pm Darren Thmpson

Cheers mate! :o)
on June 16, 2008 at 7:59 pm Aash

Hi have the below query and cannot quite figure out where excatly to use the collation.

Can somebody please help:

INSERT INTO CRMSUBSCRIPTIONSV1_HITS(USER_LOGONNAME, USER_PASSWORD, ORDER_ORDERPRODUCTID, ORDER_HITSPURCHASED)
SELECT DISTINCT USER_LOGONNAME,USER_PASSWORD,ORDER_ORDERPRODUCTID,ORDER_HITSPURCHASED
FROM CRMSUBSCRIPTIONSV1 WHERE CRMSUBSCRIPTIONSV1.PRODUCT_ISHITBASED = ‘1′ AND NOT EXISTS
(SELECT USER_LOGONNAME,USER_PASSWORD,ORDER_ORDERPRODUCTID,ORDER_HITSPURCHASED
FROM CRMSUBSCRIPTIONSV1_HITS,CRMSUBSCRIPTIONSV1 WHERE
CRMSUBSCRIPTIONSV1.USER_LOGONNAME = CRMSUBSCRIPTIONSV1_HITS.USER_LOGONNAME AND
CRMSUBSCRIPTIONSV1.USER_PASSWORD = CRMSUBSCRIPTIONSV1_HITS.USER_PASSWORD AND
CRMSUBSCRIPTIONSV1.ORDER_ORDERPRODUCTID = CRMSUBSCRIPTIONSV1_HITS.ORDER_ORDERPRODUCTID AND
CRMSUBSCRIPTIONSV1.ORDER_HITSPURCHASED = CRMSUBSCRIPTIONSV1_HITS.ORDER_HITSPURCHASED)
GROUP BY ORDER_ORDERPRODUCTID,USER_LOGONNAME,USER_PASSWORD,ORDER_HITSPURCHASED

Thanks in advance.
on June 21, 2008 at 1:08 am Lala Ramnath

Works!!!!!!!!!!!1
on July 10, 2008 at 9:32 pm Bongski

Thanks you very much sir. You’re the man!
on July 16, 2008 at 12:42 pm Benni

Great! Worked!
Thank you very much…
on July 22, 2008 at 5:47 pm Kruno

Thank you.
on August 5, 2008 at 3:54 am mc

Thanks Pinal!
on August 14, 2008 at 8:34 am Dinesh

I would like to add that use Collate with ‘IN’ clause also.

Have a look in my Query which I solved using collate for ‘IN’ clause.

SELECT DISTINCT top 100 PERCENT FT_TBL.product, FT_TBL.RSV_desc, FT_TBL.LIST_PRICE, FT_TBL.uom, KEY_TBL.RANK, PDoc.product AS PDocProduct,
FT_TBL.pgroup, FT_TBL.Special_Conditions, FT_TBL.shop_id, SUM([Order Contents].Qty) AS Sqty
FROM Products1 AS FT_TBL INNER JOIN
FREETEXTTABLE(Products1, *, ‘fuel pump’) AS KEY_TBL ON FT_TBL.ID = KEY_TBL.[KEY] LEFT OUTER JOIN
[Order Contents] ON FT_TBL.product COLLATE DATABASE_DEFAULT = [Order Contents].[Item Number] COLLATE DATABASE_DEFAULT
LEFT OUTER JOIN
(SELECT product
FROM ProductDocs
WHERE ([Shop ID] IS NULL)) AS PDoc ON FT_TBL.product COLLATE DATABASE_DEFAULT = PDoc.product COLLATE DATABASE_DEFAULT
WHERE (FT_TBL.shop_id IS NULL) AND (FT_TBL.car IN
(select DISTINCT [Car Type] FROM [Car Types]))
GROUP BY FT_TBL.product, FT_TBL.RSV_desc, FT_TBL.LIST_PRICE, FT_TBL.uom, KEY_TBL.RANK, PDoc.product, FT_TBL.pgroup, FT_TBL.Special_Conditions,
FT_TBL.shop_id
ORDER BY KEY_TBL.RANK DESC
on August 19, 2008 at 12:23 pm JohnTags

thanks you very much for nice tips! Its save my day. :)
on August 30, 2008 at 12:57 am zoran035

thanks you very much for nice tips!
(Ovo je bila nocna mora dosad - Hvala (Serbian) )
on September 4, 2008 at 4:55 am Fabian

Thanks you very much, Greate.
on September 4, 2008 at 3:31 pm Subhrangshu Banerjee

Thanks Pinal.
It has helped me a lot.
on September 4, 2008 at 9:51 pm Fabio

YES !!!! THANK YOU VERY VERY MUCH

MERCI BEAUCOUP (French)

MECI EN PIL (FWI Creol)

:-D
on September 11, 2008 at 5:00 pm Harthikote Naveen

Superb boss!!!!!!! thank u for ur knowledge sharing.
on September 13, 2008 at 12:31 pm Florian

Thank you very much!
on September 20, 2008 at 4:27 pm Bhumit

Its really works

Thank you very much
on September 25, 2008 at 2:13 pm Ashish

Thnaks for this Article. Really it helped me.
on October 1, 2008 at 5:55 pm Sara

Hi i need a help with collation problem

I am creating a database with sql_latin_general collation in an sql instance with collation latin_general.

While running installed application error occurs.is there any way to handle this scenario.

Please help me its very urgent
on October 7, 2008 at 12:48 am Luciana

Thanks, very helpful!!!
on October 28, 2008 at 12:04 am Amoril

Exactly what I needed, thanks.
on October 31, 2008 at 2:33 pm Theo

Very tidy, saved me from my ALTER TABLE nightmare against an 30Gb db
on November 4, 2008 at 5:01 pm WOW

Thanks!
on November 6, 2008 at 2:29 am Marvin

Thanks !!!

This help me with this …

WHERE ESTADO_PROCESO COLLATE DATABASE_DEFAULT in (select string from dbo.fn_SplitStrings(@as_estados, ‘,’))
on November 11, 2008 at 2:25 pm Me

Thank you very much! Nice tip!
on December 4, 2008 at 3:28 pm GuS

Worked like a charm, thanks man :)
on December 9, 2008 at 1:35 pm MS

Many Many Thanks :)

It worked out for me!!!!!!!!!!!!

Plz kip up the gud work.
on December 12, 2008 at 12:50 pm Vinod

Thanks, it works!
on December 17, 2008 at 12:04 pm Sohbet

thank you baby
on December 22, 2008 at 3:45 pm Ruan

Hi guys

I have added the COLLATE DATABASE DEFAULT after my join clauses, now i get an error: Expression type int is invalid for COLLATE clause.

Here is the query, can someone please help??

SELECT
I.Name,
A.Name EventShortName,
ISNULL(F.Name, ”) GroupShortDisplay,
C.ParameterName,
D.WinningValue,
COUNT(EntrantID) TotalEntries,
CASE WHEN D.WinningValue = G.Pick THEN
COUNT(EntrantID)
ELSE
0
END CorretEntries,
CASE WHEN D.WinningValue G.Pick THEN
COUNT(EntrantID)
ELSE
0
END IncorrectEntries

FROM [Pikum.Web].dbo.Event A WITH (NOLOCK)

INNER JOIN [Pikum.Web].dbo.[EventParameter] B WITH (NOLOCK)
ON B.EventID = A.EventID COLLATE DATABASE_DEFAULT

INNER JOIN [Pikum.Web].[dbo].[Parameter] C WITH (NOLOCK)
ON C.ParameterID = B.ParameterID COLLATE DATABASE_DEFAULT

INNER JOIN [Pikum.Web].dbo.[PikumEventParameter] D WITH (NOLOCK)
ON D.EventParameterID = B.EventParameterID COLLATE DATABASE_DEFAULT

LEFT JOIN [Pikum.Web].dbo.EventCategoryGroup E (NOLOCK)
ON E.EventID = A.EventID COLLATE DATABASE_DEFAULT
AND E.EventCategoryGroupID = D.EventCategoryGroupID COLLATE DATABASE_DEFAULT

LEFT JOIN [Pikum.Web].dbo.CategoryGroup F (NOLOCK)
ON F.CategoryGroupID = E.CategoryGroupID COLLATE DATABASE_DEFAULT

INNER JOIN [Pikum.Web].dbo.[EntrantPick] G WITH (NOLOCK)
ON G.PikumEventParameterID = D.PikumEventParameterID COLLATE DATABASE_DEFAULT

INNER JOIN [Pikum.Web].dbo.Pikum I WITH (NOLOCK)
ON I.PikumID = D.PikumID COLLATE DATABASE_DEFAULT

WHERE PikumStatusID >= 7
AND UserPikumCreatorID = 1566
and pikumidentifier = ‘V7Y2A-D4F40′

GROUP BY

I.Name,
A.Name,
ISNULL(F.Name, ”),
C.ParameterName,
D.WinningValue,
G.Pick
on December 22, 2008 at 11:57 pm TimothyAWiseman

Thank you!
on December 30, 2008 at 10:24 am RobinAEllis

worked like a charm, thanks….
on January 4, 2009 at 6:09 pm Reza

Thanks, very helpful!!!