SQLian,

How do I add the field names to your code?  I tried Thom's but Not all my tables have identity fields...in fact they are only 6 out of 30...

SQLian,

The msg I get when I run your code is this:

Table 'UNFI_WEST_F_Compressed.dbo.UNFI_LI_SHORT' does not have the identity property. Cannot perform SET operation.

It is picking out a table without an identity...

• This reply was modified 4 years, 9 months ago by  GrassHopper.

SQLian,

How do I add the field names to your code?  I tried Thom's but Not all my tables have identity fields...in fact they are only 6 out of 30 in...

Jeff, I copied it from SQL studio to notepad and then here.  I'm not sure why it put...

John, thanks for the clarification in the definition of words.  I'm a little loose with my terminology sometimes.

That Worked! Thanks Des.

My question is...Why am I getting this error msg when i run some excel files???  They don't look different and column 17 and 18 in excel are empty...in the ones...

The data will be used by 1 or 2 persons for about a month and then a small dataset will be extracted from this and only that will be used. ...

I have a database with no compression on the tables(source).  I want to create a blank database(destination) where I can create the tables with "data_compression = Page" and then Insert...

Thanks!  I forgot about Try_cast .... Need to start using the new functions.

thanks, I will look into merge replication.

I wpuld like to get the following columns DC, prepaid, collect, WMItem, ItemDescription on the same row by Hdrid + RID. I'm not sure if this is clear or...

Point taken...please see data below.

Create Table dbo.MyTable(ID int, HdrID int, RID int, WmItem varchar(50), ItemDescription varchar(150), DC varchar(50), Prepaid varchar(50), Collect varchar(50))

Go

INSERT INTO MyTable (ID,HdrID, RID, Wmitem,ItemDescription,DC,Prepaid,Collect) VALUES...

This is what worked for me below.  There were some rows with the month names as values ie "FEBRUARY".
Try_Convert(varchar,Try_Convert(date,[date_From], 101), 103) as Date_To2