Somewhere in Oxfordshire innit?

doodlingdba (9/10/2015)

---

Thanks Chris - I will look through the FOR XML syntax and see if I can figure it out. All new stuff for me but interesting! Thanks for taking...

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/10/06/bad-habits-to-kick-order-by-ordinal.aspx

adonetok (9/10/2015)

---

In a store procedure will get value from application for member ID like

'12456', '88997'...

How to complete store procedure in where statement below

where [MEMBER ID] IN ( @myID )

@myID =...

doodlingdba (9/10/2015)

---

This is awesome, thanks. I haven't ever used CROSS APPLY so good to see it in action. Now I need to figure out how to only print a message...

squvi.87 (9/10/2015)

---

ChrisM@Work (9/10/2015)

---

Since you're going to get a table scan with the WHERE clause containing non-SARGable predicates, remove it altogether. Also, include a coded alternative in your CASEs as the...

Edvard Korsbæk (9/10/2015)

---

It will take me app. 15 minutes to create a program, that makes the report - OK

So, I use the Jack as you descibe it.

I am in the...

SELECT

SP.Name,

m.permission_name

FROM sys.server_principals SP

CROSS APPLY (VALUES ('VIEW ANY DEFINITION'),('VIEW ANY DATABASE'),('VIEW SERVER STATE')) m (permission_name)

WHERE SP.name = 'something'

AND NOT EXISTS (

SELECT 1

FROM sys.server_permissions SPM

WHERE SPM.grantee_principal_id =...

Yes it's possible to do, but it's a little like digging a big hole underneath your car so you can get a flat tyre off and put a fresh tyre...

Since you're going to get a table scan with the WHERE clause containing non-SARGable predicates, remove it altogether. Also, include a coded alternative in your CASEs as the default is...

SELECT

BD.ID

,x.MyFilter

,BD.F1

,BD.F2

,BD.F3

FROM BASE_DATA BD

CROSS APPLY (

SELECT MyFilter = CASE

WHEN BD.F1 = 0 AND BD.F2 = 1 AND BD.F3 = 0 THEN 'F2 only'

WHEN BD.F1 =...

VD (9/3/2015)

---

Sweet! I tried that approach with the order by testdate ACS and of course the grouping was wrong. I will figure out the regrouping with dense_rank()!

thanks so...

mw112009 (9/3/2015)

---

I need the sql statement that meets the following

I need a list of memberids who meet the following criteria

Select memberid, measureid from numerator

1. There should be atleast 1...

tt-615680 (9/3/2015)

---

I'm sorry if I'm not being clear but I can only see what I've already sent you, basically, when I run the following:

-- 9 - Populate the #ParsedFileList table...

John Mitchell-245523 (9/3/2015)

---

It's got to be TextData, hasn't it? That's the only string or binary column that's being inserted. Looks like you've captured events in your trace that...