Actually, 2 and 3 are still not mutually exclusive this way. For rule 1 you can determine whether a row needs to be included by reading only data from this...

Thanks for taking it offline. Please be even more careful with other people's privacy than your own.

One tip: since 'companyphone' is going to be your first selection criterion, I would...

I know for a fact that my employer (JF Hillebrand) does not want their name and contact data listed in...

declare @stmt nvarchar(max);

select @stmt = stuff((

SELECT ' UNION ALL SELECT * FROM ' + quotename(sc.name) + '.' + quotename(st.NAME) + ' WHERE PROTOCOLNAME =...

;WITH InnerTable AS

(

SELECT ROW_NUMBER() OVER (PARTITION BY COURSE_ID, TEACHER_ID ORDER BY COURSE_ID) AS Row,

TEACHER_ID, COURSE_ID, SCDAY, SCINI, SCEND

FROM Schedule

)

select Teacher_ID,

Course_ID,

max(case row when 1...

The opening post seemed to ask for a string to datetime conversion. However as was clarified only recently, poster was actually looking for a conversion from datetime into a formatted...

select convert(datetime, '1967-10-13T17:55:12', 126)

Do you want me to chew your food for you too? 😉

Note the comments on BOL though: no spaces!, i.e. one minute past 1 on January first...

iluvmyelement (10/12/2011)

---

UPDATE: I think I made the necessary change to get what I expected. Now I just need to adapt this to my 'real' database with different tables/fields....

I haven't tested it (I don't have nw installed), but this should do what you need using a sub-query construction. You can also use the window-functions (f.e. row_number()) to do...

1 - No,...

Thanks for the attempt, but that is not the execution plan. That is a picture of a part of the execution plan. Please have a look at this article http://www.sqlservercentral.com/articles/SQLServerCentral/66909/...

Just use the "alter table" command.

For example:

alter table dbo.Mytable alter column colname int identity(1,1) not null

Do you know SQL server has a feature called identity? All you need to do is define your primary key column as an int column and give it the identity(<seed>,<increment>)...

Ok, so let's assume you've got a trigger that creates the view dynamically. And thus you've got the view all set to return all totals for all statusses in a...

By specifying '//r' for the xpath, you say SQL server needs to traverse the entire document in search of any elements called 'r', anywhere in the document.

Do you know anything...