Or you can consider switching over to Ola Hallengren's excellent database maintenance scripts, available for free at https://ola.hallengren.com/%5B/url%5D. They drive all the backups for you, including the cleanup of old...

Did you copy/paste the complete error message? Most SQL Server errors include at least an error number, and having the exact text of the error can help.

Also, you state that...

Not sure what type of courses you are looking for - classroom training, books, videos, something else?

If watching videos on your own device is your favorite method of learning, then...

GilaMonster (1/10/2016)

---

Sure, with the same general idea.

t1 INNER JOIN t2 on t1.Col1 = t2.Col2 OR t1.Col1 = t2.Col3 OR t1.Col1 = T2.Col4

Don't know what the performance will be, but I...

Eric M Russell (1/11/2016)

---

This smells like healthcare claims data. If so, then "userpolicyid" is something like PayerID + SubscriberID + DependentID, and the format is not coded consistently between external...

Rankerg (1/10/2016)

---

I get a flat / EDI file from client and ETL to the DB and since the client is sending entire yearly data instead of DELTA I need to...

It's not the dress, dear!

I am once more going to tell you that the question is too vague for an answer.

In order for us to help you, you have to provide clear, concrete information....

A user-defined function can be called from within a query. And a query is optimized by the Query Optimizer - which means that the QO decides on what is the...

The syntax error is a missing closing parenthesis.

However, Eirikur is right: his method performs better (or probably I should say...

I'm pretty sure I already mentioned that the performance will be dramatic.

Also, if the table grows significantly I would index all three columns. I expect a plan with three seeks...

VegasL (1/9/2016)

---

Data comes that way. I can't normalize. I think this is analogous to an index match function from xls, which comepares one column against the other 3 columns then...

I am glad you found it!

Thanks for posting back - in case someone else runs into the same issue and finds this thread when googling for solutions, your post may...

Eirikur Eiriksson (1/9/2016)

---

You are very welcome and thanks for the feedback.

😎

As demonstrated here, often in-line date tables are easier solutions than physical date tables, especially if they are supporting logic...

Start here: http://www.sqlservercentral.com/stairway/75773/%5B/url%5D.

Also, download and insstall the AdventureWorks sample database. Though far from perfect, it's a much better test- and play-ground than Northwind.