Erin Ramsay (4/1/2013)

---

🙂

Give me a set based statement...

gurvimail (4/1/2013)

---

I have two tables with float data types and am using EXCEPT to check for the new rows in the source tables.

Their is data in the source table but...

Stale statistics?

Hi and welcome to SSC. It is somewhat difficult to help here because you did not provide very much information. We like to see ddl, sample data and desired output....

Sean Lange (4/1/2013)

---

Grant Fritchey (4/1/2013)

---

Lynn Pettis (3/31/2013)

---

Yes, I am sure about doing this, but I am both anxious and excited about going. It may not be the safest place...

Todd Bernstein-449184 (4/1/2013)

---

TableB contains the combination that all must be met in tableA order to be returned from tableA. For instance

Desired Output

A_ID A_text

1, Yes1

2, Yes1

99, Yes1

The A_id 1,...

Your data is not normalized and your results are not normalized. The reason this is difficult is because your structures make this difficult.

At any rate, you did a great job...

I was feeling charitable this morning so I created the ddl and sample data to work with.

if OBJECT_ID('tempdb..#Data') is not null

drop table #Data

create table #Data

(

MyName varchar(20),

Age int,

Salary int,

Department varchar(20)

)

insert #Data

select...

nitha jen (4/1/2013)

---

hello sir..can u plz help me .....i don't knw how to solve this conflict ''The INSERT statement conflicted with the FOREIGN KEY constraint "FK_product_details". The conflict occurred in...

Great job posting ddl, sample data and desired output!!!

Can you explain how you get the results? I can't figure out what the logic is supposed to be here.

You're welcome. Glad that works for you.

BTW, you copied everybody's ranking and...

Grant Fritchey (4/1/2013)

---

Lynn Pettis (3/31/2013)

---

Yes, I am sure about doing this, but I am both anxious and excited about going. It may not be the safest place but having...

bryan van ritter (3/29/2013)

---

Hi,

i have a table which looks like this:

custiditemdateamount

131-1-2013 1

121-1-2013 2

241-2-2013 2

241-2-2013 1

and i want to make it look like...

you're welcome.

This one seems to have a way of doing that.

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/678c5758-7272-48da-9c7d-50b4b49c9615/%5B/url%5D