try hackerrank.com

I find the easiest way to think of it is to write the WHERE clause to select the records i DON'T want and then wrap those rules in a NOT(...)

So...

Agreed. but when you are prototyping it is very likely that you don't have the full story from the business, especially where they need to persist changes in entities which...

@sergiy

The problem is not with the code-first mentality; it is with a lack of awareness of what the defaults are when using code-first. I can build perfectly...

I think the main problem with LINQ is that it fetches table data based on .NET classes so often will not limit the data to only those columns you are...

It is all about the data!

It doesn't really matter what presentation tool you are using if the underlying data is not sound. 3NF has not changed in 30 years...

Do you want to send the query or the query results?

Like Phil Says - db_sendmail

Or you could use SSIS and SQL Agent

Or you could use SSRS and subscriptions

Or you could...

And invest in SQL Redgate's toolbelt: one of the best investments for moving code between environments and managing source code control in SQL. Not affiliated, just a happy customer.

you will need Oracle drivers installed on your development and production machines. I would look at the drivers from Attunity as they seem to run much faster than the...

OK.

I might have been a bit harsh in that last post.

We have all been the victims of poorly designed databases written by the app developers who don't even know that...

WOW!:w00t:

I think I may have hit a nerve!

I know traditionally that database devs and application devs have made uneasy bedfellows but I didn't realise that these attitudes were still so...

so if a customer has 10 orders and each order has 10 lines, you would expect to see the customer details 100 times. how about if the customer has...

What have you tried so far.

You might be better off giving us some sample data and the desired output.

PIVOT works in much the same way as in Access:

You need a...

you are very welcome. Well done on setting off on the right track; you have saved a load of pain later on

@G^2

I hate the way the package process has been designed precisely because of the ASYNC nature of the initiating process. Without a rewrite, the short answer is no. The...