Sergiy (1/6/2016)

---

Those who know other languages better than SQL they prefer to use CTE. it's simply more comfortable for them.

Those who know how to design databases and program in SQL...

Is that a problem? Should the language be kept in a glass case and never added to or...

Edvard

Not directly, no. You could do some additional fancy date arithmetic to subtract Saturdays or Sundays, or you could create a Dates table, and join to that, counting only...

Nicole

You say it's for ETL processing - are you using SSIS? If so, you might consider weeding out the invalid values in your data flow. There are ways...

Nicole

You say it's for ETL processing - are you using SSIS? If so, you might consider weeding out the invalid values in your data flow. There are ways...

One way to get round it is to dynamically set the properties of the connection manager, instead of the data source.

John

Try this. It relies on there being a unique key in your table, which I've represented by the column OrderbyThisCol.

CREATE TABLE Names (

OrderbyThisCol int NOT NULL PRIMARY KEY

,Name varchar(10)...

Satheesh

What error message do you get when the connection fails? Is there anything in the errorlog? What protocol are you using both locally and remotely to connect with...

I prefer CTEs to subqueries because you can get all the definitions out of the way at the front, and then the main query looks more neat and compact.

John

It's partly about preference, and partly about using the right tool for the right job. If a CTE is unnecessary, don't use it. If you prefer subqueries, don't...

I suppose you could create the table on the fly if you don't want a permanent one. This is a common technique. It would be a bit fiddly,...

Here's one way of doing it. It may or may not be the most efficient. Create a table of dates with one row for each date between the...

The trigger fires once per update, not once per row updated. It will have an adverse effect on performance if you use a loop instead of a set-based update....

Error messages? Unexpected results?

Please see here. It's so that we only consider...

Shazme

It's not always a problem if the database collation doesn't match that of the server. You usually get issues if your code creates temp tables and joins to...