Note that sys.dm_db_index_usage_stats only returns stats from the last time the server was started. Just because an index hasn't been used since start up doesn't mean it is...

Try:

UPDATE dbo.TableA

SET sysReturndate_Current = DATEADD(qq, 1, ReturnDate)

WHERE CurrentRecord = 1 AND Frequency = 'Quarterly' AND ReturnDate IS NOT NULL;

Since Express and Compact only support Subscriber access for replication, you'll need a third database that supports publish. both express and compact could then subscribe to the third db

If you can't use a linked server you'll need to use OPENROWSET instead.

http://msdn.microsoft.com/en-CA/library/ms190312.aspx

Phil is correct. You should be able to do this in a Derived Column transformation. The expressions are quite powerful.

fwiw I bought a dev edition for my own lab. I asked MS about licensing for other machines in my lab. The answer is that I can install...

dwain.c (11/6/2014)

---

How's this on your eyes?

declare @howmany int = 50;

with n1(n) as (select $ from (values ($),($),($),($),($),($),($),($),($),($)) n(n)),

n2(n) as (select $...

Just thought I add my minimalist CTE-based tally table generator:

declare @howmany int = 50;

with n1(n) as (select 1 from (values (1),(1),(1),(1),(1),(1),(1),(1),(1),(1)) n(n)),

...

Good observation, though the output becomes misleading. I never doubted that the "right" row was deleted. I just found the results from the output clause to be confusing....

well, isn't that interesting!

Don't know about the "should be done" bit though. My version doesn't need a self-join. It's just weird that SQL loses track of what it...

yes, of course, but with those caveats it should still be useful

Edit: I'm wrong. It can't be used in the way I imagined.

e.g. try to find hrefs in...

The row...

Alan.B (11/5/2014)

---

emph. mine

g.britton (11/5/2014)

---

Well....a multi-character delimiter is just a simple pattern without wildcards. So even though that's not the...

Well....a multi-character delimiter is just a simple pattern without wildcards. So even though that's not the design goal, it...

Found it here:

http://www.sqlservercentral.com/articles/String+Manipulation/94365/

Silly me, I was searching for "multi-character delimiters" Had I searched for "patterns" I would have hit it right away!