rena24 (9/14/2012)

---

Ok, I am really thankful for your Help. My Company has created a ETL tool that we must use for import/Export Data. Sometimes I am allowed to use SSIS...

Sheesh!!! Some companies have the strangest rules/regulations about things. There is a tool that...

GilaMonster (9/14/2012)

---

SQLRNNR (9/14/2012)

---

GilaMonster (9/14/2012)

---

SQL Kiwi (9/14/2012)

---

GilaMonster (9/14/2012)

---

Thank you, you...

Are you reading this data in from a file? If so, then this is not a big deal at all. The biggest challenge is that if this data is already...

martinetymic (9/14/2012)

---

and sorry for the format : it's my first time asking questions in a forum!:-)

some details:

d_an = first year with a specific medical condition

before this date : d_YEAR=0

after this...

Sure I can help. But first you need to help me. See the first link in my signature about best practices when posting questions. Until you post stuff we can...

Several more than...

martinetymic (9/14/2012)

---

Hello,

in fact I did something similar:-)

'd_1998'=

case when diab_d1=1998 then 1

else 0

end,

but it is with the next step that I have some pb:

DECLARE @sql VARCHAR(500)

DECLARE @Annee INT

SET @Annee=1998

WHILE @Annee<=2011

BEGIN

SET @sql='UPDATE...

Oh wow...I just looked a little closer at the details. You need to look at the numbers or tally table. This is not the right way to do whatever it...

Something is missing here because you reference Primary_Import in your explanation and in your code but the table is not created.

The meat of your issue is found here:

The way...

rena24 (9/14/2012)

---

Hello everyone!!!

I have a file with these Data -->

H;2334;8989;90;000

L;XXX;YYY;90;000

L;UUU;PPP;78;000

H;4445;855989;90;000

L;AAA;BBB;90;000

L;YYY;TTT;78;000

I want to set a primary Key (gid) to each row in that way -->

1;H;2334;8989;90;000

1;L;XXX;YYY;90;000

1;L;UUU;PPP;78;000

2;H;4445;855989;90;000

2;L;AAA;BBB;90;000

2;L;YYY;TTT;78;000

Is there any way to do this...

martinetymic (9/14/2012)

---

Hi,

I have a problem in sql server 2005 to submit :

My table 1 is as follows : 1 column with refid and one with a year (d_an)

Table 1

REFIDd_an

11998

22001

31999

42012

I would...

Well a primary key belongs to a table, not the database. I think this link will probably...

robert.baird 2778 (9/14/2012)

---

No.. that is stored in table2

table1:

Name

Addy

Ph.

table2

RunDateTime

The package writes a new timestamp in table2 everytime its fired off, showing the begin time of the package (the update to...

Gary Noter (9/14/2012)

---

Looking to see how to do this type of join.

VaxTable as VT

- table2RecordID

- vaxDate

- customerID

- dollarAmount

CustomerRequestTable as RT

-...