Click here to Skip to main content
15,667,949 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to set the timer for SSIS package Pin
Marek Grzenkowicz15-Jul-08 22:58
Marek Grzenkowicz15-Jul-08 22:58 
GeneralRe: How to set the timer for SSIS package Pin
nagveni16-Jul-08 10:05
nagveni16-Jul-08 10:05 
GeneralRe: How to set the timer for SSIS package Pin
Marek Grzenkowicz19-Jul-08 9:50
Marek Grzenkowicz19-Jul-08 9:50 
Questionconvert datetime format Pin
tai-fun14-Jul-08 11:01
tai-fun14-Jul-08 11:01 
AnswerRe: convert datetime format Pin
Arindam Tewary14-Jul-08 22:09
professionalArindam Tewary14-Jul-08 22:09 
GeneralRe: convert datetime format Pin
tai-fun15-Jul-08 1:15
tai-fun15-Jul-08 1:15 
AnswerRe: convert datetime format Pin
leoinfo15-Jul-08 5:35
leoinfo15-Jul-08 5:35 
QuestionBULK INSERT and collation problem Pin
msx2314-Jul-08 10:56
msx2314-Jul-08 10:56 
I'm trying to use BULK INSERT to import a text file and then check its contents against a table in the database. I'm getting a problem when I compare the results however.

I'm making a temp table to hold the text file's contents
CREATE TABLE #Temp(Code varchar(5), number varchar(2))


Then using BULK INSERT to get the contents in
BULK INSERT #Temp FROM 'PATH.txt' WITH (FIELDTERMINATOR = ',',ROWTERMINATOR = '\n')


And then checking if any matches occur
SELECT Code, (CASE WHEN
				(SELECT Count(DBTable.Code) From DBTableWHERE DBTable.Code= #Temp.Code) > 0	
			 THEN "Yes"
			 ELSE "No" END) AS FLAG
From #TempCCServs 


The problem is that I get the following error message now:
"Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation."

Anyone have an idea what I'm doing wrong?
Thanks for any help.
AnswerRe: BULK INSERT and collation problem Pin
Syed Mehroz Alam15-Jul-08 1:08
Syed Mehroz Alam15-Jul-08 1:08 
QuestionWhere To Buy SQL 2000 Reporting Service? [modified] Pin
thundernow14-Jul-08 4:21
thundernow14-Jul-08 4:21 
AnswerRe: Where To Buy SQL 2000 Reporting Service? Pin
DerekFL14-Jul-08 7:51
DerekFL14-Jul-08 7:51 
QuestionFind Last week dates? Pin
Member 387988114-Jul-08 3:04
Member 387988114-Jul-08 3:04 
AnswerRe: Find Last week dates? Pin
subai14-Jul-08 3:21
subai14-Jul-08 3:21 
AnswerRe: Find Last week dates? Pin
leoinfo14-Jul-08 3:35
leoinfo14-Jul-08 3:35 
AnswerRe: Find Last week dates? Pin
TheFM23414-Jul-08 6:26
TheFM23414-Jul-08 6:26 
JokeRe: Find Last week dates? Pin
leoinfo14-Jul-08 18:27
leoinfo14-Jul-08 18:27 
GeneralRe: Find Last week dates? Pin
TheFM23415-Jul-08 3:24
TheFM23415-Jul-08 3:24 
GeneralRe: Find Last week dates? [modified] Pin
Member 387988114-Jul-08 18:47
Member 387988114-Jul-08 18:47 
QuestionHow to write query Pin
BalasubramanianK14-Jul-08 0:23
BalasubramanianK14-Jul-08 0:23 
AnswerRe: How to write query Pin
TheFM23414-Jul-08 6:53
TheFM23414-Jul-08 6:53 
GeneralRe: How to write query Pin
BalasubramanianK14-Jul-08 18:17
BalasubramanianK14-Jul-08 18:17 
QuestionDelete Query Pin
sjs4u14-Jul-08 0:10
sjs4u14-Jul-08 0:10 
AnswerRe: Delete Query Pin
subai14-Jul-08 0:29
subai14-Jul-08 0:29 
AnswerRe: Delete Query Pin
Declan Bright14-Jul-08 1:19
Declan Bright14-Jul-08 1:19 
AnswerRe: Delete Query Pin
TheFM23414-Jul-08 7:20
TheFM23414-Jul-08 7:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.