Well I would not assume to know exactly what the creators of the trining kit were thinking exactly but when you say serivce accoutn normally that is a reference to...

When I have to do something like this I always get the code from the report server even when I can find the solution. To get the files you need...

as far as I know bak is the only format that is native to SQL processes for the Backup process. There are several third party programs that do backups...

you can not run a 'backup' to excel but you certainly can export a table to excel. If you click on a database and select export data then you can...

it is not a great idea but if you abosultley have to then you can do so by eclosing the column name in brackets. for example if you had...

I know it is monday but I really feal dense.

When I run the following Query I get the exact results row by row you say you are expecting. When...

I see what you are asking for now. there are several high end SQL editors you can buy with much more advanced coding options but personally I hope they...

danny,

you indicate you are having a problem with the Query I provided but I am not sure what problem you are having. I ran it against your sample data...

I don't know about an add-in but in the editor window you can select edit from the menu and select find/replace. ssms contains the functionality to do a search...

While those on this board could give you a general idea of what you should look for you need an understanding of SQL server to take it to a practical...

I had to make a change to your sample data 30:00:00 is not a valid time.

hopefully this will take care of your problem.

Declare @sample TABLE

(ID INT IDENTITY(1,1), DID INT,...

If you are setting the learner id to the employer id where they are already equal then you are setiing ID abc to id abc. I have to be...

I think I am a little confused. Currently in your example all the records have the same client id. based on your example you what the learners client ID...

Actually before I read your article I must admit I gave very little thought to set based programming at all.

Bad habits die hard and it was before I read your article from another post.

that and it was 12 records so I must admit I gave it little thought.