ubeauty (4/22/2009)

---

It doesn't look like they are tab characters as when running the script above the following error message gets returned:

Conversion failed when converting the varchar value 'LC157790' to data...

From BOL:

The...

Assuming the table you're importing into is a staging table - which it should be - then change the data type of the receiving column to NVARCHAR.

Staging tables can...

jchandramouli (4/21/2009)

---

Hi,

Please run this query in a new window. This will give 2,3 as result. Now i need to update the procedure output (results : 1) to the table as...

UPDATE t SET overbook_flag = 'Y'

FROM #temp1 t

INNER JOIN (SELECT ROW_NUMBER() OVER (PARTITION BY doctor ORDER BY apptcreatedate) AS Appt_Number,

appt_count, appt_limit, apptcreatedate, doctor

FROM #temp1) d

ON...

Can you post the code please Kavin?

sward (4/20/2009)

---

I am applying it to DISTINCT ilr.person_code but i would need to have access to all the other columns related to the results that the distinct defines. Maybe there...

WayneS (4/17/2009)

---

Chris Morris (4/17/2009)

---

What do you want as your output, Wayne?/quote]

I'm trying to get things from table1 that are different from table2. I was able to get it through above...

What do you want as your output, Wayne?

If you want to find out fast if two tables match exactly on a set of columns, then here's a simple place to...

Pinal Dave's reverse function has this code in it:

RETURN (REVERSE(@StringToReverse))

Hello

Here's your daily table create statement, and some sample data. If you can do the same with the other table, then it will make it much easier for someone to...

bvinay57 (4/17/2009)

---

Hi

thanx for ur immediate response in my db i have Table1,Table2,Table3 tables i want to retrive data using select statement first i want to retrive data from Table1 after...

jcrawf02 (4/17/2009)

---

RBarryYoung (4/17/2009)

---

Chris Morris (4/17/2009)

---

C'mon Barry ya...

Hello

Please can you provide more information about your tables, the columns, and the expected output?

Cheers

ChrisM

There's nothing wrong with being a chubbychaser!

Dammit, where are those screenwipes? 😀