Sean Lange (1/8/2014)

---

sharonsql2013 (1/8/2014)

---

Yes so I am counting RoundTables in ('1', N/A') AND IsVideo in ('1', 'N/A').

and then need to do an and between these to counts.

Should I separately count...

Here's a solution with only one table scan.

Declare @WorkItemId int = 10110

SELECT

WorkItemId,

RelatedWorkItem = LEFT(z.RelatedWorkItem,LEN(z.RelatedWorkItem)-1)

FROM @tblRawData

CROSS APPLY (SELECT RWIStart = CHARINDEX('; Related Work',WorkItemDescription)) x

CROSS APPLY (SELECT PWIlist =...

What make of car do you drive?

AndrewSQLDBA (1/7/2014)

---

Hello Everyone

I hope that all is well.

I am working with some dates that are in the datetime data format. What I would like to do is set the current...

Please post ddl and insert scripts for your sample data.

What have you tried so far?

Which rows would you return from your sample data for today?I suspect your issue isn't the coding, but the business logic.

Rando (1/2/2014)

---

I'm getting the data from Microsoft Performance Monitor. The date field is not a date field

If I sort the...

Using what?

-- a little reformatting shows that the same query is referenced THREE TIMES

CTE (comments, matter_uno) AS

(SELECT case when isnull((

SELECT top 1 i.comments

FROM BO_LIVE3.dbo.HBA_SOURCE_BUS i

INNER JOIN...

Different route, similar results.

First some sample data:

SELECT TOP (50000)

ID = ROW_NUMBER() OVER (ORDER BY (SELECT NULL)),

[Version] = 'CTCAE v4.03 (MedDRAv12.0)',

Grade = 1+ABS(CHECKSUM(NEWID()))%5

INTO Data

FROM SYSCOLUMNS a, SYSCOLUMNS b

Second,...

In the UK, contact Grey Matter. They'll sell you 4 developer licences for about 40 quid. You choose what you want those licences to be for, so you could have...

IT2012 (12/19/2013)

---

Thanks for the reassurance! I was beginning to get a little afraid there might be cyber-bloodshed! 🙂

Honestly, I am learning what I can. My situation is I am...

Use GROUP BY.

Each one of your five current threads

select quarie between houseno ..........

select house_no order

select only up to first '-' only

display order by like 1,2,3,4,5...............plz write quarie

display order by houseno

relate to...

Each one of your five current threads

select quarie between houseno ..........

select house_no order

select only up to first '-' only

display order by like 1,2,3,4,5...............plz write quarie

display order by houseno

relate to...