dandrews 45259 (7/4/2016)

---

Hello,

I hoping somebody can help with a sql issue I have. WE have sales orders and works orders. I am looking at the works order history...

SELECT

MinNum = @MinNum + (n * @Span),

MaxNum = @MinNum + ((n+1) * @Span)

FROM (VALUES (0),(1),(2),(3),(4),(5),(6)) d (n)

WHERE n < @Interval

gkrs (7/1/2016)

---

Yep I know what you mean, the dbase design/input validation could be a lot better. Thank-you for all the replies. The following LIKE seems to work in...

In case that was missed in translation (!), here it is again:

DECLARE @database2 NVARCHAR(100);

DECLARE @DBs TABLE (DBname NVARCHAR(100));

INSERT INTO @DBs VALUES ('?'),('?'),('?');

SELECT * FROM @DBs

BWFC (7/1/2016)

---

gkrs (7/1/2016)

---

I regularly have to mass update customers address areas when the postcode lookups for those areas are altered. e.g the lookup table can be something like below.

I usually...

Why are you attempting to include the sample data setup in your report definition? It's only in...

You have a spare turtle?

Beatrix Kiddo (6/30/2016)

---

I'm sure you are very good: it's absolutely not a slight on anybody who doesn't work in London, it's just saying that very good people can vote with...

Here's some stuff for you to explore. Your query can be simplified a lot and made much faster...

IF 0 = 1

WITH MyDates AS (

SELECT * FROM (VALUES

('1500', '20160423'),('0020',...

Can you provide a few examples of *exactly* what they look like?

lcaradon (5/10/2016)

---

We periodically get this message below in the SQL Server log on SQL 2012 Enterprise edition. The database is encrypted using TDE. The encrypted databases on the server were...

When you say it's slower, is it 4s vs 2s or 104s vs 102s?

This is more important: what datatype are q2.DateofOnsetofLabour and q2.TimeofOnsetofLabour?

richardmgreen1 (6/30/2016)

---

Hi Chris

I've had a look at the updated Splitter code and it actually runs a few seconds slower than my original.

Not entirely sure why as I would have thought...

Two changes worth trying. Firstly, introducing the splitter:

OUTER APPLY (

SELECT MedicalInduction = ds.Item

FROM [MeditechDR01-M1].[livefocdb_daily].[dbo].[RegAcctQuery_Result] aq1

CROSS APPLY DelimitedSplit8K (replace(replace(aq1.[ValueInfo],'}',''),'{',''),'|') ds

WHERE aq1.[Query_MisQryID] IN ('MAT.MEDIND')

AND aq1.SourceID = ad.SourceID

AND aq1.VisitID = ad.VisitID

) q3

Secondly, the...

Cool, well done.

There are issues with the fragment of query you posted - do you want help with resolving them?

The...