declare @Year varchar(10) = '16'.

select *

FROM test1 t1

INNER JOIN test t2 WHERE t2.col LIKE '%-' + @Year

WHERE t1.Col LIKE @Year + '-%'

You must have the derived table joined to something else.

It may cause all sorts of issues which I don't see the reason to list.

If you post the whole query and...

Index name is not a really good indicator of index existence.

You may have many identical indexes, all with different names.

To check if an index with the same structure as you...

Is it what you're after?

IF OBJECT_ID('Proc2') is null

exec ('CREATE PROC Proc2 as SELECT 1 as One')

GO

ALTER PROC Proc2

AS

IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL

SELECT * FROM #TempTable

GO

IF OBJECT_ID('Proc1')...

The code defines only the metadata.

Apart from metadata there is user data in any table.

What happens to it when you execute "create or alter"?

What if the code does not contain...

ZZartin (11/29/2016)

---

This depends on source and target and how the information is being used. I would consider a surrogate key anything that is generated in the target system as...

You mean this?

The essential feature of a "natural" key is...

dalland (11/28/2016)

---

Sergiy, your approach seems to amount to "everything is a surrogate". There's no point me disagreeing with that. If that's your opinion then I guess this part of the...

dalland (11/28/2016)

---

Sergiy,

All data in a database consists of "artificial" symbols assigned by machines or human beings. There are no exceptions. In that very broad sense keys are always surrogates for...

1. Not sure what login identifies, apart from login itself....

If you think of it, those SSN, NIN, tax registration numbers, etc., are not natural keys, they all are artificial numbers, auto-generated by some kind of computing system.

They are the...

RonKyle (11/27/2016)

---

Ok, I'll change it to "in many cases." My point was that it seems...

One of the biggest questions here is - how do you query the table?

Can you post one of the typical queries which use a filter on that datetimeoffset column?

RonKyle (11/23/2016)

---

In most cases there isn't one. I would certainly never use an SSN for this. But that doesn't mean that...

"10 tables, 3000 rows" is not the scale which could possibly justify choice of such an expensive (in all meanings) tool as SQL Server.

It's not even enough for Access.

An Excel...