Aubrey-314204 (11/11/2016)

---

Recently we migrated from SQL 2008 to 2014. I have come across an error that only is happening on the 2014 environment, but working successfully in 2008. ...

Ed Wagner (11/11/2016)

---

Sean Lange (11/11/2016)

---

Phil Parkin (11/11/2016)

---

I'm not sure for...

Quick Dynamic SQL solution

😎

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @TEMPLATE NVARCHAR(MAX) = N'

UNION ALL

SELECT

''{{@SCHEMA_NAME}}.{{@TABLE_NAME}}'' AS TABLE_NAME

,COUNT(*) AS ROW_COUNT

...

Alvin Ramard (11/11/2016)

---

Eirikur Eiriksson (11/11/2016)

---

andy.plumb (11/10/2016)

---

thanks for the reply, I tried that and got error:

Description: An error occurred executing the provided SQL command: "SELECT * FROM U_Observation WHERE UPDATED_DATE >...

andy.plumb (11/10/2016)

---

thanks for the reply, I tried that and got error:

Description: An error occurred executing the provided SQL command: "SELECT * FROM U_Observation WHERE UPDATED_DATE > DATEADD(YEAR-2,GETDATE())". Native error :...

Then your login is a member of the sysadmin role

😎

Here is a quick suggestion

😎

USE TEEST;

GO

SET NOCOUNT ON;

;WITH CT(CN) AS (SELECT CN FROM (VALUES ('0'),('1'),('2'),('3'),('4'),('5'),('6'),('7'),('8'),('9')) X(CN))

SELECT

REPLICATE(C.CN,6) + CX.CN AS GEN_SEQ

FROM CT C

CROSS APPLY CT CX

WHERE ...

hoseam (11/11/2016)

---

I get string values as input, e.g 'Documentation.Account', whatever value I get I want to extract it to get anything after a period(.) e.g'Account' I was thinking of using...

😎

Not certain how to read these requirements.

TheSQLGuru (11/10/2016)

---

Eirikur Eiriksson (11/10/2016)

---

homebrew01 (11/10/2016)

---

I'm sure it's a long list, but what are the "Top 10" list of improvements I can take to management to help justify spending the $$...

sqlserverDBA2016 (11/11/2016)

---

Yes it is a shared point database, and are you telling me that with swl server 2014 I won't be able to have this colation, in that...

niall5098 (11/10/2016)

---

HI All,

I am trying to update a default instance to sp3. the issue however is when the patch runs it fails with the following error:

=== Verbose logging started: 04/11/2016...

Would have thought that if you carefully follow the process detailed in that page "Setting Up Windows Service Accounts", you should be safe.

😎

Why don't you set up another instance and...

No, you will have to...

Good job with the DDL and the sample data, can you complete this by posting the desired results?

😎