Big Ben (I didn't :-D)

Use a CTE or derived table to generate the LEAD and LAG before filtering.

You can't execute a result set, you need to assign the text into a variable. Please, be very careful with SQL injection as this could be a recipe for disaster...

Here's an example on how to work with iTVFs, actually 2.

For more information about iTVFs and how they compare with normal scalar functions, check this article written by Jeff: http://www.sqlservercentral.com/articles/T-SQL/91724/

Here...

Why are you doing that when you can do this

DECLARE @templogin NVARCHAR(128);

Set @templogin='domain\user1';

exec [DBA].[dbo].[CopyAllLoginsUsers] @loginholder= @templogin;

Especially when using NVARCHAR(MAX), you're exposed to SQL injection.

Use parametrized queries whenever possible. For...

Beer

People who say that Oracle is the future are probably people that already work with Oracle or just got certified on Oracle. The truth is that I'd have more confidence...

Phil Parkin (3/2/2016)

---

Luis Cazares (3/2/2016)

---

Hugo Kornelis (3/2/2016)

---

The alternative, since this appears to be some type of ETL process to feed a DW table, would be to create an SSIS package.

That...

Hugo Kornelis (3/2/2016)

---

The alternative, since this appears to be some type of ETL process to feed a DW table, would be to create an SSIS package.

That tool is specifically built...

Did you see this thread?

http://www.sqlservercentral.com/Forums/Topic1765816-2799-1.aspx

Thanks for posting, Gary.

I understand why Hugo couldn't be sure of the legitimacy of your post. Just add a few words when sharing this valuable links to give some certainty....

Why don't you store the pattern in a different table so you can just replicate it any times you need?

I'm not really sure how to do it, but you're basically facing the migration from xml files to sql scripts. If you're able to convert the xml into relational data,...

Here's an option that could help you achieve your goal. I'm not posting the full solution so you need to understand what's going on.

WITH

cteRows AS(

SELECT...

Here's an article by Dwain Camps in which he explains how to use percentiles in versions previous to 2012. https://www.simple-talk.com/sql/t-sql-programming/using-the-t-sql-percentile-analytic-functions-in-sql-server-2000,-2005-and-2008/

If anyone wants to give it a shot, here's the sample...