sarwar.ali490 (12/11/2016)

---

Hi All,

I got a requirement to validate multiple conditions in a given string.Eg STRING is a 30 byte key.I have to check

1.Length is >10 and

2.susbtring(1,6) in(e.g..123456,67892) and

3.if susbrting(1,6)=123456...

Phil Factor wrote a long piece on this few years back Consuming JSON Strings in SQL Server[/url]

😎

Ed Wagner (12/11/2016)

---

Eirikur Eiriksson (12/11/2016)

---

spectra (12/11/2016)

---

Hi,

I have two files i.e .ldf and .mdf in my disk. As we know these are normally SQL Server database...

spectra (12/11/2016)

---

Hi,

I have two files i.e .ldf and .mdf in my disk. As we know these are normally SQL Server database log and data files....

Can you post the full code for the stored procedure please?

😎

ptownbro (12/10/2016)

---

We have a new server and want to move the SSAS databases from the old server to the new one. I thought this could be done by detaching the...

Quick example of an inline calendar CTE, you should be able to adjust it to your requirements.

😎

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @DateRanges TABLE

(

StartDate DATE,

EndDate DATE

)

INSERT INTO @DateRanges (StartDate,EndDate) VALUES ('2016-12-01','2016-12-01')--2016-12-01

INSERT INTO...

Try to keep it as simple as possible, not only is the logic more readable, it also helps the performance.

😎

SQLUSERMAN (12/10/2016)

---

Suppose I want to find customers in the customers table who are not in the US or the UK.

To me the query for the above requirements would be as...

In SQL, one cannot use this kind of a where clause, if using multiple values it will have to be a sub query

😎

where Sales.SalesTerritory.[Group] in (@Sales.SalesTerritory.[Group])

should be something like

where...

swarun999 (12/9/2016)

---

Hi I have a issue. When I am using this scrpit in SSRS its showing error.

select sales.SalesTerritory.TerritoryID , sales.SalesTerritory.Name , sales.SalesTerritory.CountryRegionCode,

sales.SalesTerritory.[Group] ,

sales.SalesTerritory.SalesYTD, year(sales.SalesTerritoryHistory.StartDate) as [Year]

from sales.SalesTerritory join...

savibp3 (12/9/2016)

---

I have 2 proc , calling one proc inside another. There are 2 parameters need to pass .When I call the main procedure and it takes parameter.There is considition...

ChrisM@Work (12/9/2016)

---

Eirikur Eiriksson (12/9/2016)

---

ChrisM@Work (12/9/2016)

---

Brandie Tarvin (12/9/2016)

---

rodjkidd (12/9/2016)

---

ChrisM@Work (12/8/2016)

---

rodjkidd (12/7/2016)

---

Eirikur,

I'm about a 20 minute walk to the High Holborn Caffe 1882. Let me know if you still want to meet...

ChrisM@Work (12/9/2016)

---

Brandie Tarvin (12/9/2016)

---

rodjkidd (12/9/2016)

---

ChrisM@Work (12/8/2016)

---

rodjkidd (12/7/2016)

---

Eirikur,

I'm about a 20 minute walk to the High Holborn Caffe 1882. Let me know if you still want to meet up today?

Chris, are...

avi7070 (12/9/2016)

---

Hi,

It would be better to schedule FULL, DIFF, and TLog backups for production server databases. As you are not using any not using any high availability technique.

For Point in...