Divine Flame (12/7/2011)

---

You shouldn't. You can always use IF EXISTS to know if there is any...

Thanks, i'll give this a go and see what i can come up with.

Cheers

R

ChrisM@Work (12/7/2011)

---

Let me ask another question. This looks like a single step in the creation of a complex cross-tabbed report. Is this the case?

If so, is the data you're inserting...

ChrisM@Work (12/7/2011)

---

INSERT...SELECT will insert rows from the output of the SELECT. If there are no rows returned by the SELECT, then no rows will be inserted.

In your case, you...

Due to the fact i couldn't find a result. I just decided to re-install.

Perhaps this is the only way.

Thank you all for your imput and help.

Cheers

Rixxe

Yes that is correct.

Yes, as there is only one account which should be the admin.

Thanks for the idea about changing the server name, but i get this:

Msg 15247, Level 16, State 1, Procedure sp_dropserver, Line 20

User does not have permission to perform this action.

Msg...

Connecting to the parent company, hence the name change.

It would have made sense to create a copy, and i would have done if i was aware when this change...

Lowell

Thankyou very much for your help. This is saved me a stupendous amount of time.

Many thanks

R

Thankyou very much for your help, that works now.

One last thing if i may:

How would i add this function into the procedure?

It changes the yob to always have a day,...

Thank you for the help.

Currently I have this:

Still getting an error which has now become:

(12100 row(s) affected)

Msg 102, Level 15, State 1, Line 27

Incorrect syntax near '('.

Trying to find what...

So i ran it with those changes suggested, and i get the following error:

(12100 row(s) affected)

Msg 242, Level 16, State 3, Line 1

The conversion of a nvarchar data type to...

I was unaware you could do that, i'll give it a go.

Also do you have to specify the type of DateTime? e.g. yy-mm-dd/dd-mm-yy etc?

Many thanks

R

Well, seeing as when its reading in a particular file, it errors half way through the reading process i'm not sure what else i can do.

I've attempted splitting the arraylists,...