Thank you to you both.

I read the article, that is a very good one.

Thanks again

Andrew SQLDBA

Sean

That is very nice, I completely forgot about that way. That is very clean and efficient.

Andrew SQLDBA

Sharon

I would suggest never using an asterisk like that. You will only have difficulties. Also, always name your columns, never use an asterisk in your query. What happens to the...

Thank You Scott

That is exactly what I thought as well. Nothing I can do about that. I looked at the original data.

Thank You for your assistance and suggestion

Andrew SQLDBA

Hey kramaswamy and LinksUp

The code was prefect. Thank you both.

I was missing something so very small, it covered the page and I could not see it. 🙂

Thanks again to you...

Thanks GSC_DBA

That is really Great!! I tried using MS_ForEachDatabase, but could not get it working correctly. I was missing something in the dynamic code, and could not get it correct.

I...

Hey Lowell

Yes, in fact they are already in Simple recovery mode. But with the amount of data being pumped int at times, they can grow. And over time, they get...

I am really not totally clear on what you want. But I am going to take a guess.

If you want the structure of table1, you can rename table2 and then...

Thank You Everyone

That is what I knew. I was just hoping that someone more intelligent that I would know of something else.

Thanks

Andrew SQLDBA

Thank You, very good advice on that.

Yes, you understand correctly. I would really like the database to not log anything for this data load.

Yes, I had left that to...

Lynn

Thank You so Very much. I was trying to make this so much more difficult.

I am so embarrassed, I am not going to show or tell what path I was...

You need to know at what date and time the reference data is, meaning something like '1960-01-01 00:00:00' and that bigint represents the number of seconds that has passed since...

I would start by looking at the query that is preforming the select. I always use stored procedures so that I can easily troubleshoot the query without having to launch...

Thank you to Everyone.

I actually forgot to mention that this was a one time update of another column, in a table with less than 7000 rows. So I was not...

Thank you

That worked perfectly

I was mistaken, I do not have code to remove the leading zeros. Can you also assist with that part?

Thanks

Andrew SQLDBA