Would it work with the real creation time of the file by using a script?

This code is untested, but it could give you an idea.

Option Strict On

Imports System

Imports System.IO

Imports System.Data

Imports...

This is a great place to use a cursor. You need to go table by table to get the desired results.

Here's an example, just change the query text and you...

I know that you're posting on the 2008 forum, but I'll include the 2012 option just in case.

--SQL Server 2008/2005

WITH CTE AS(

SELECT *, ROW_NUMBER() OVER(PARTITION BY...

Street

Or without subqueries:

SELECT TOP 1 @@servername AS Servername

,[min server memory (MB)] = MAX(CASE WHEN name = 'min server memory (MB)' THEN value END )

,[max server memory (MB)] = MAX(CASE WHEN...

I would suggest to have a unique or primary key constraint in your target table to prevent the insertion of rows 14 and 15. As Phil said, there's no use...

I'd start by updating the statistics in your development server. Those seem very stale.

Same queries in different environments can generate different execution plans because they have to adapt to the...

Apples

A year ago, someone else asked a question about a Movie Rental Database. Could this be the same school assignment?

sys.user (4/11/2016)

---

Well, since the original database was meant to work with single copies...

Are you sure your model makes a difference between Title/movie and DVDs/copies? Those are different entities.

NineIron (4/11/2016)

---

OK. Now for some more knowledge transfer..................this stored procedure containing the dynamic sql is used for an SSRS report. The dataset isn't pulling the fields because of issues with...

You just made my day 🙂

I learned this concatenation method from Wayne Sheffield, which he explains it in here: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

And combined it...

This method will allow you to get the 10,000 duplicates. Check the index option used, which would be needed and can only be used for PKs and UNIQUE indexes.

CREATE TABLE...

This code is meant to be run in SSMS, then you can transform it into VB code. I would suggest to convert it to a Stored Procedure and call the...