I've seen that Prompt handles snippets in a wonderful way. I know that templates have been available for a long time, but I'm not sure if you could create custom...

tnpich (9/2/2015)

---

The one posted by you back in 2007. I wasn't paying attention to the dates when I was looking at this.

My SQL skills are not much past the...

I understand it as coder and debugger. 😀

Well,...

Yet another option 😀

SELECT LEFT( Filename, Start.Bytes - 1) AS theFilename,

SUBSTRING(Filename, Start.Bytes + 7, Start.Records - Start.Bytes - 7) AS Bytes,

...

Here's an example on how to do it dynamic. It's not that complicated and it could become a stored procedure on itself.

DECLARE @LastName nvarchar(100) = 'Tamburello',

@FirstName...

You can do it with the bcp utility by using xp_cmdshell or SSIS or Powershell.

Even with large tables, NOLOCK hints aren't the best option. I'd suggest you to read more about this hint and understand how this is a poor idea.

Back to the original...

A CASE statement can only return one data type. If possible, it will implicitly convert the values following the data type precedence rules. In this case, the empty string is...

Vladan (9/1/2015)

---

Solution of Luis seems to me to be the best of the 3 variants. My code has rounding problem (returns 55.55 instead of 55.56), which I overlooked before and...

denis.gendera (9/1/2015)

---

All, thx for the quick solution one thing I forgot to mention how would I also include the column that shows the # machines this patchgroup got deployed?

pgroup ...

A bit simpler:

SELECT

t5.pgroup,

CONVERT(NUMERIC(5,2),SUM(CASE WHEN t6.state = 'INSTALLED' THEN 100. END) / COUNT(*)) AS INSTALLED,

CONVERT(NUMERIC(5,2),SUM(CASE WHEN t6.state =...

Another option is to change only the dateformat, or the condition (which can be painful to get it completely right).

SET dateformat dmy;

CREATE TABLE #TestDates(

UserField1 char(8));

INSERT INTO...

Chocolate

Brandie Tarvin (8/31/2015)

---

I am planning to upgrade at least one of my machines. Haven't decided if it'll be the 8.1 or 7. But I'm waiting to hear feed back from...

This can help you, but it could give you false positives. I'm using sys.sql_modules, but you can use your table.

SELECT *

FROM sys.tables t

WHERE EXISTS( SELECT * FROM sys.sql_modules m WHERE...