The problem is your original primary key. You have a composite key in your Issuers table of IssuerId, IssuerRecordChangeCodeDateTime. Then you try to make only IssuerID a foreign key. That...

ashisht4u (12/12/2011)

---

Lynn,

Actually I'm preparing for my interview and I came across some of the question on DB, I'm at C++ but not done much work on SQL-Server. I want to...

I agree with Gus on this one. Just to show you based on your example you could do something like this.

create table #Details

(

Application_ID int

)

go

insert #Details

select 4

go 8

insert #Details

select 8

go 23

insert...

Please don't cross post. Direct all replies to the original thread. http://www.sqlservercentral.com/Forums/Topic1220407-391-1.aspx

Welcome to SSC. You need to provide some more details before anybody can post a complete answer to your question. Start by posting ddl (create table scripts), sample data (insert...

This really should be done without a cursor. From what I see in the logic there just is not a need for a cursor at all.

Most likely you are getting duplicates in your temp table. Your primary key on the base table is EXTINGNLABO and you have two inserts into your temp table, Then you...

You're welcome. Definitely makes all the difference when you post ddl and sample data (nicely done by the way).

Something like this should work.

select ORDERID, LOAD_DATE, FILENAME, ORDER_DATE, DOLLAR

from

(

select ORDERID, LOAD_DATE, FILENAME, ORDER_DATE, DOLLAR, ROW_NUMBER() over (partition by OrderID order by LOAD_DATE desc) as RowNum

from order_archive

)x

where x.RowNum =...

Take a look at the string splitter link in my signature.

toddasd (12/7/2011)

---

ramanamreddy (12/7/2011)

---

Hello,

I have a column patID with some values( with some condition 1), patID with some columns(with some condition 2).How can I merge all the values into a single...

Erwin Dockx (12/7/2011)

---

Sean Lange (12/7/2011)

---

In general you need to be careful about doing that. By changing from single quote to a double you are changing the data. For html this...

rpeplow (12/7/2011)

---

Hi,

Thank you for the reply. Looks like it'll do the trick. I agree the data isn't in an ideal format. But i'll have to make the best of a...

Well I think you find that you should keep this data separate but of course I don't know all the details of your project. There is probably a more elegant...

That is funny.