SQLPain (9/8/2015)

---

Thank you guys for all your help !!!

Would the following 2 statements fetch the same result?

1)AND (CC.EndDate >= H.SysDateTime OR (CC.EndDate IS NULL AND GETDATE() >= H.SysDateTime))

2)AND ISNULL(CC.EndDate, GETDATE())...

Sorry, I understood that you needed to print, copy and execute the code.

You can concatenate all the commands in a single string. This article explains how to do it: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

DECLARE...

sgmunson (9/8/2015)

---

Luis Cazares (9/8/2015)

---

It depends on the expected output. My code will return...

Don't you love the disappearing OPs?

Why don't you simply display the results as text instead of a grid?

SQLAddict01 (9/8/2015)

---

I have so many NOT IN conditions like ::

Select * from backups

where

databasename not in (select databasename from backups where servername...

You just accumulate the row counts. Be sure to initialize your variable to zero to avoid getting a null value.

while

process a chunk

set @p_affected_rows =...

Either you can write your query like this:

SELECT *

FROM Test

WHERE NOT( ServerName = 'D900'

AND DatabaseName = 'Test1')

Or you could tell us how do you define the first row. Remember...

The subqueries make no sense as they're not tied to anything from the outside. You're probably after something simpler as this:

DECLARE @Start datetime,

@End datetime;

SELECT @Start =...

This seems to return the same results as Jeff's code without the need of a tally table.

SELECT tt.*, new.String

FROM #MyHead tt

CROSS APPLY (SELECT SUBSTRING( pString, PATINDEX('%A[^BCD]%', pString), 8000)) Start(tString)

OUTER APPLY...

It depends on the expected output. My code will return all the rows...

andreakreif (9/8/2015)

---

This will also replace all temp table creates.

CREATE TABLE #SomeTable becomes ALTER TABLE #SomeTable.

Like Luis said, this is not an automated process.

Seems like regular expressions with patindex might work....

Jeff Moden (9/4/2015)

---

Nicely done, Luis.

Just a tip... if it all occurs on the server itself, you don't...

Want a cool Sig (9/4/2015)

---

DATEADD( YY, DATEDIFF(YY, 0, @Date),0)

Hi Luis, I've never seen this before and I don't see it in the online documentation... how does it work? I...

Reformatting full names is a pain and something you can't really automate in the real world without some problems. Take this example:

SELECT LEFT(FullName,CHARINDEX(' ',FullName)-1) AS x

,RIGHT(FullName,LEN(FullName)-CHARINDEX('...