I did provide 2 queries which should be correct....

I would actually leave the last 3 subqueries. I'd probably move them to the from using the APPLY operator. The reason is that those seem to be unrelated quantities which...

Arrow

If they're all renaming queries, this could work.

WITH SampleData AS(

SELECT 'EXEC sp_rename @objname = N''PK_Filegroup_Tables_ID'', @newname = N''PK_FilegroupTables_ID'';' as Script UNION ALL

SELECT...

The operator BETWEEN is inclusive. The common way to do this is to write the range. Also, for using only dates, the ISO 8601 short format is preferred.

select count(1) from...

Candace

Or if you're on 2012, you could use CONCAT.

SELECT ID,

STUFF(

...

Shorter version without the need of scalar functions.

DECLARE @Date SMALLDATETIME = GETDATE();

SELECT CONVERT( char(8), DATEADD(MM, DATEDIFF(MM, 0, @Date), -1), 112);

More formulas: http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

cajsoft (4/27/2016)

---

Luis Cazares (4/26/2016)

---

You might need to use a recursive CTE if you can nest more than one level.

Remember, with a good DB design this would be as easy as...

I agree with Sean comments. Database design can be something complex without the proper formation. For instance, you're not designing a table, you're designing a database with several tables.

You need...

Sean Lange (4/26/2016)

---

Alvin Ramard (4/26/2016)

---

Tempted to...

Check this article: http://weblogs.sqlteam.com/jeffs/archive/...er.aspx

How?

What are you auditing?

No Name

Wonder if I should answer: "Using INSERT statements"

http://www.sqlservercentral.com/Forums/Topic1781117-1550-1.aspx