boehnc (9/17/2012)

---

this is basically the code...this join... left join UserView.vwEncounterDiagnosis d on d.VisitId=a.VisitId...will give me multiple rows per patient

i might need help with the diagnosis order/code statements in the where...

Please post your query.

e.g. in Source and Destination table CustID is unique number then we can have below query...

ranganathanmca (9/17/2012)

---

Hi Guys,

How to design SSIS Package for my below requirement please share some idea's and view to achieve this problem

1. We are having 2 different servers like (LNEW8T8,LNEW3T3) same...

boehnc (9/17/2012)

---

I have one table "patients"...one row per patient.

Patient.ID, Patient.Name, Patient.address, Patient.gender

1/Jim/123 elm/M

I have another table of patient diagnosis codes. It can have multiple dx codes...

eh.shams (9/17/2012)

---

source table is like this one :

Customer Code|cslAccumulationInvoiceItmId|cslAccumulationInvoiceRef|cslDeliveryNoteRef|cslProductRef|Amount|RateCurrencyRate|price beforePriceInBaseCurrency|Deliver No|Date-Reci

4005604666346644285322121.54504807110873542.7810873542.78171691/10/2012 00:00

4005604665946644284882122.86504807111539888.0211539888.02171461/10/2012 00:00

4005603641436413192044717.6651923019169601.89169601.81095611/30/2011 00:00

4005603530535304181764724.12519230112523827.612523827.61036111/27/2011 00:00

4005609649096488846394722.2656800011264368012643680270828/8/2012 00:00

4005603531235304184654722.7519230111786521117865211054911/28/2011 00:00

______________________________________________

on the destination i have same table , with only add status (bit) column.

i...

Grant Fritchey (9/17/2012)

---

rhythmk (9/17/2012)

---

Grant Fritchey (9/17/2012)

---

Thing is, those are two different queries. The IN statement can act to filter the results of ABC, but none of the columns from ABC1...

Just found below article from Gail on the same 🙂

http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/

Grant Fritchey (9/17/2012)

---

Thing is, those are two different queries. The IN statement can act to filter the results of ABC, but none of the columns from ABC1 are available in...

Robin Sasson (9/17/2012)

---

Its also depends on whether the columns you are joining on are indexed.

Indexing and performance is a large topic in it's own right.

Too many indexes on a...

znkin (9/16/2012)

---

I am using SQL 2008 and I need help to write a select query for the following output

I need list of distinct CustId who have ordered both ProdId 1...

somanath_kolekar (9/17/2012)

---

Hi rhythmk,

Thanks for the response.

Yes. For validations I am using primary key. If the row with that primary key exist in table 1, I need to reject that record...

somanath_kolekar (9/17/2012)

---

Hello All,

I am beginner to writing stored procedure. So checking out your views on implementing below requirement:

I have one table containing data in one system. I want to write...

SQLSACT (9/17/2012)

---

Hi All

Consider the following 2 tables

create table T1

(Col1 int, Col2 int)

go

create table T2

(Col3 int, Col4 int)

And the following query

select Col1, Col4 from T1,T2

What is actually happening when the select...

purushottam2 (9/16/2012)

---

I want to know which query is more optimized?

SELECT 1 FROM ABC WHERE Id IN (SELECT Id FROM ABC1)

===================================================

SELECT 1 FROM ABC a JOIN ABC1 b ON a.Id =...