If there are multiple values, you need to include curly braces...

Example:

SELECT StrToSet (

'{[Geography].[Geography].[Country].[Germany]

,[Geography].[Geography].[Country].[Canada]}'

...

Qira (8/3/2015)

---

Hi,

I've

1. Data Warehouse

2. OLAP CUBE in Analysis Services

My question is - If my Data Warehouse is changed (Having Append Data) - My OLAP Cube will have the Append Data?

It's...

You almost have a working function with the 2 scripts you already provided.

Just combine the two!

SQL-DBA-01 (7/30/2015)

---

Hello Experts,

If I run the below command, it helps to clean up the files inside the folders but unable to clean up the folder and sub-folders older than 30...

Here...

This may help in making a decision.

http://technet.microsoft.com/en-us/library/ms189261(v=sql.105).aspx

IMO - for your scenario - I would choose a foreign key constraint 🙂

You get a float value that is n days since Jan 01 1900 00:00:00

Select convert(float,getdate(),112)

SELECT CONVERT(DATETIME,41729.6878646605 )

Hi Andrew,

I have created this for you from a similar maintenance task I undertake:

EXEC sp_MSforeachdb 'IF ''?'' NOT IN (''tempDB'',''model'',''msdb'', ''master'')

BEGIN

DECLARE @desiredSizeInMB INT = 16, @execSQL NVARCHAR(MAX)

...

Hi,

Have you tried using Execute Process Task?

...if you choose your batch commands from the target "Executable" this should give you want you want.

JimS-Indy (9/3/2013)

---

OK, that's exactly what I wanted. Now, how to streamline this SQL (note the redundant select statements...) Using Project ID 0355 for testing...

begin transaction

delete tblWorkOrders

from tblWorkOrders wo

where wo.projectid=03555

and not...

npranj (9/2/2013)

---

I need to understand which one is better with respect to performance :

1. SQL 2012 has introducted FETCH OFFSET ...

SELECT FirstNm,LastNm

FROM Person

ORDER BY FirstNm

OFFSET 5 ROWS

FETCH NEXT 10 ROWS...

t2sqldba (8/14/2013)

---

Hi,

I got a requirement where I need to collect report about SQL server configuration and the report should have columns like SQL server instance name,SQL Server Collation,Edition,location of TempDB,SQL...

If scan counts are a concern, you could add a primary key for all columns (as you are using a SELECT * FROM)

DECLARE @Tbl AS TABLE

(

...

Hi,

Having had a brief look, the second query (on my PC) was better in terms of CPU and fewer reads.

I also added a PK to the table variable which further...

I don't like to use the term "it depends" but in my experience the more you calculate up front (in the data source/set) less goes wrong.

With that said;

...