We keep a calendar table (100 years, past and future) that has flags for business days, holidays EOM, days of the week, quarters etc.

Type "system error messages" into the search tab of books-on-line.

You can also use the import wizard. Right-click on the database in the object explorer. Select Tasks --> Import. From the there, the wizard will guide you....

My definition of a good QOD: Anytime I get the correct answer 😀

Good Question!

We do a lot of this. We keep tables of extended metadata that include source and destination information, conversion and special mapping instructions. These are used to generate...

As a general rule, it is feasable (we do it), but you must use care when updating the tables with developed applications or T-SQL or whatever. You may not...

aroatenberry (3/10/2010)

---

I have to insert values from Table A to Table B. Table B has a Reason column that will be the same for every entry.

So let's say that...

If you want everything to be identical, backup/restore should work just fine.

DECLARE @Yesterday datetime

SET @Yesterday = CONVERT(DATE,GETDATE() - 1)

SELECT DATEADD(HH,15,@YesterDay)

rburke 87921 (3/9/2010)

---

I have the following query;

SELECT dbo.Product.ProductID, dbo.Product.Category, dbo.Product.ProductCode, dbo.Product.Description, dbo.Product.Price, dbo.[Order].CustomerID, dbo.[Order].OrderID,

...

You should add SQL debugger (part of SSMS) to that list. I've found most DBAs don't appreciate the value.

I just noticed in the question header of the forum, you are asking about step by step instructions on importing Excel to SQL Server.

In the object explorer, right-click on the...

You've posted twice without including any description of the problem. Unless you can show us the query and the problem, the answer is a definite no.

Two drink minimum.

Have you granted execute permissions to all the procedures to the user or a role he/she is a member of?