What is set for the collation in the Dataset Properties Dialog Box, Options (Report Builder)?

😎

Whenever sets of requirements (Subject/Business) are incompatible with other sets of requirements (Subject/Business), it is appropriate to subset the data into Subject/Business specific Data Marts. My preference is a single...

What is the definition of the hierarchy, according to the screenshot, the parent entry is a member of the children.

😎

halifaxdal (11/11/2016)

---

This is really a challenging to me: I am assigned folders (yes, plural, more than one folder) on SFTP server, each folder correspondent to one client. Each folder will...

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...