What is wrong with the import feature? That is what it is designed to do.

Sql server does not have a UI. You will have to create a way to present this to your users.

Ninja's_RGR'us (5/18/2011)

---

Sean Lange (5/16/2011)

---

Check out this post from Jeff Moden. split function. This will get you started down the right path. This is a really common misconception about a varchar...

Jay B-317395 (5/17/2011)

---

Hi Hope thie helps

tTimeTable

DayID PeriodID StaffID

1 1 ...

The reference here would be a great place to start. They seem to have a lot of information about this exact error with lots of resolutions. 😛

With well over 40 views and no responses it should be clear there is no exact and certainly not a simple answer. It also sounds like you need to do...

Please don't continue posting the same question again. Instead you should reply to Steve in your original thread here.

Do not reply to this thread. Please respond to the original one.

Try this script

SELECT * FROM sys.dm_os_performance_counters WHERE object_name LIKE ('%Deprecated%')

You can also find some info here

If that doesn't work you can this link

There can definitely be a performance difference. If you select * from a table with 150 columns and you only need 3 columns you asking sql to retrieve and return...

Let us know if you need some help implementing. There are tons of people on here willing and able to help.

How about some ddl and sample data along with desired output that matches the sample data? Please see the link in my signature about how to post questions to get...

Pure speculation but that is probably the date that the developer at MS created the database for 2005 and the installer just restores that DB during install. Since it didn't...

That is a really bizarre requirement. If the table you showed us is the whole table what does it matter if you delete it and recreate it? Wouldn't you loose...

That is totally unclear to me what you are trying to do. Please see the link in my signature about how to post your question so you have the best...

Check out this post from Jeff Moden. split function. This will get you started down the right path. This is a really common misconception about a varchar variable.