I think he needs more than coffee - in fact, I think he had more than coffee ... And plenty of the stuFf too.

But, in the morning, he'll look...

Rather than saying "it's not working", which is close to useless to us, please provide details of what you tried...

ChrisM@Work (8/17/2012)

---

Phil Parkin (8/17/2012)

---

Missing something, I'm afraid.

SELECT ... INTO

always creates a new table. When it creates that table, uses the data types of the source columns, but not primary...

Nice work - thanks for posting back.

May I suggest that you consider using table aliases - it will make your query much more readable. Eg

select t.col1, t.col2 from tablewithaverylongnameindeedohyes t

--rather...

Missing something, I'm afraid.

SELECT ... INTO

always creates a new table. When it creates that table, uses the data types of the source columns, but not primary keys or identity...

Have a look in INFORMATION_SCHEMA.VIEW_COLUMN_USAGE for the view-related info - you may have to join that to another i_s view to get everything you want.

david.ostrander (8/16/2012)

---

Hello -

I currently have an SSIS package being built where I want to upload rows from an excel document into a Recordset Destination in SSIS. What I'm having...

I'd like to nominate this as a candidate for the 'esoteric thread of 2012' award 🙂

If you've been able to derive the question, why not go ahead and answer?

raghuldrag (8/16/2012)

---

hi friends

i ve created on table create table rab(deptno number(33),

job varchar(22));

insert into rab ('22','clerk');

insert into rab ('25','manager');

insert into rab ('20','sales');

output:

deptno job

22 ...

It would be polite of you to answer mine and Anthony's questions - they are there for a reason: we are trying to understand your reasons for doing this, whether...

kishor.patgir (8/16/2012)

---

Hello All,

I have one table which have one field sr_no. in this field data up to 1.to ..100.

In this if i delete some record then sr_No not Maritain.

I want...

gayathri-b (8/15/2012)

---

Kindly Help me out ...Even I face the same Issue...

Is there anything to do with teh DB2 settings like time out etc.,

From SSIS do I have to configure the...

Teee (8/15/2012)

---

Hi,

I need to take the characters from the left before the '/' string and insert into a column and the characters on the right after the '/' string...

patrickmcginnis59 (8/14/2012)

---

Shadab Shah (8/12/2012)

---

Jeff Moden (8/10/2012)

---

Shadab Shah (8/9/2012)

---

Hi all,

I have come across various section on this website where it is mention that SQL Server is a set based programming language.

...