You're nearly there. Try this structure instead

IF EXISTS (SELECT 1 FROM tbl WHERE username = 'whatever')
BEGIN
    --Username found code
    SELECT 1;
END;
ELSE
BEGIN
...

Thanks for taking the time to write that out.

While I'm sure it would have been helpful in this case to permit 'circular' references, I'm still not convinced that this is...

Firstly, please note that a Script Component is different from a Script Task – the names are not interchangeable. You are talking only about script tasks here (script components appear...

The server threw an exception [0x80010105]

Did you Google this error? I just did, and there are lots of hits. Based on the knowledge you would have accrued from the hits,...

The SQL Agent service may (should) run as a different user from both SQL Server and Windows (which is not relevant here). Check the service credentials.

Now if MS could fix bloody circular project references it would be great.

Can you provide a practical example where circular (as defined by MS in this case) references are an...

• This reply was modified 5 years, 9 months ago by Phil Parkin.

you can try the following.

create a folder where you put the create scripts for those tables

on the projects where you need those tables ensure you have the folders setup...

I can add them with a shared post deployment script, but the triggers in the project would fail since they won't be able to "see" the tables...

Not ideal, but could...

I can't think of a way of doing this which allows the schema objects to be both part of every database project and maintainable from a single place.

I don't think...

I'm a fan of SSIS, and it can certainly be done that way (but it's not trivial).

You could write a simple PoSh script to pre-process the file & split it...

Do you have a different source file for every layout?

Your file format does not appear to match the data you have provided (eg, row 1 is at least 122 characters in length, whereas your layout is 78 characters in...

Ah, my apologies. I'd assumed that, with >2,700 points, you would understand exactly what I meant.

What we need here is code which other developers can run in SSMS.

So

1)

DROP TABLE IF...

You know the drill. Can you provide some sample consumable DDL, data and desired results, please?

Thank you for your feedback, appreciate your valuable time, skills and know ledges. Do you agree if we have more than 5 millions rows in source table, we should...