Working with VB should not be a problem, simply either increase the length of the text box or go into the properties (f4 key) for the text box and set...

Use BOL and read up on sys.columns or execute some T-SQL for example

To return all column names:

SELECT * FROM sys.columns

To search for a particular column

SELECT object_id,name FROM sys.columns WHERE name...

Here is the article which contained Jeff's code - study it to learn an incredible amount about dates and time calculations.

http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/

Pass this onto Jeff

This response has earned a coupon...

Suggest you search Jeff Moden's posts - I remember he had a method of determining holidays but for the love of life I can not find it in my favorites....

Just a suggestion, if you do not have too many SPs you can have the database tell you what I believe you want to know.

Remeber it is work intensive on...

Provided that you only want to write out data you might consider writing your merged information as a Comma Separated File (.csv). Excel will open a .csv file. ...

Sorry but your Select statement makes no sense to this individual.

Please read the article on posting questions as it appears in my signature block follow the instructions in the article...

First of all when trouble shooting simplify the code, (Since you need to find the 1st and Last character positions for the substring function) so lets find them. For...

However when i put them onto the dev system and run the application code against it the application fails with an error which states that "Row cannot be located for...

So the query optimizer appears to be working Now what is your question? All I read is a statement...

Dcarpenter - the information you have provided makes it extremely difficult to even attempt to answer your question. Need some additional explicit information - such as ... is...

Except for one or two answers I think most of the suggestions are missing the boat so to speak.

From Webster Standard Dictionary

Analytical

3: skilled in or using analysis especially in thinking...

I got very frustrated working with your code and attempting to follow Microsofts procedures to correct the registration error so I developed my own without any problems. It is:

INSERT...

The answer to your question of how long to keep backups is the standard SQL Server answer it depends. If your database contains financial data which eventually finds its...

Can you be more specific

That is are you using an Application Role, or Windows authentication, or .... for...