A simple CASE statement can 'beautify' the Data Type but just be mindful you'd have to account for quite a few different types.

Here is an example of a few:

USE AdventureWorks2012

SELECT...

When I'm looking for that kind of info I just normally write a query something like this.

USE AdventureWorks2012

SELECT

COLUMN_NAME,

DATA_TYPE,

CHARACTER_MAXIMUM_LENGTH,

IS_NULLABLE,

NUMERIC_PRECISION,

NUMERIC_SCALE

FROM

INFORMATION_SCHEMA.COLUMNS

WHERE

TABLE_NAME = 'Address'...

Although similar the other post asks about information regarding Foreign Keys while this thread asks for Columns Data Type and Size. ...

Sorry folks, just realized that I actually didn't ask a question.

Any ideas what else I can do to troubleshoot this issue? There seems to be so little documentation around...

I suspect there is a piece of info missing. Are you sure they are actually stored as double quotes.

For example try this:

DECLARE @test-2 TABLE(myString VARCHAR(25))

INSERT INTO

Click here on how to post examples.[/url]

If you just want AdventureWorks just simply change your code to...

Use DBSizeTrack

INSERT INTO Track (RunDate,Dbname,file_Size_MB)

SELECT

GETDATE() as RunDate,

DB_NAME() AS DbName,

SUM(size)/128.0 AS File_Size_MB

FROM AdventureWorks2012.sys.database_files

That's because you execute it once for every DB but always tell it to use 'AdventureWorks'

Try this instead

EXEC sp_MSforeachdb

'USE [?];

SELECT

GETDATE() as RunDate,

DB_NAME() AS DbName,

SUM(size)/128.0 AS File_Size_MB

FROM sys.database_files'

That...

Lynn Pettis (9/1/2015)

---

GilaMonster (9/1/2015)

---

It probably did nothing, since the error was in code and repair can't fix that (short of deallocating pages from the system tables)

Why don't you just leave...

GilaMonster (9/1/2015)

---

Ed Wagner (9/1/2015)

---

That's a neat approach...

Just submitted my request to attend PASS this year. (First Time)

Really hope it gets approved. :Whistling:

However, I just noticed the housing block is all sold out. Maybe, I should...

Luis Cazares (9/1/2015)

---

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...

This worked for me.

SELECT DISTINCT

t5.pgroup,

CONVERT(NUMERIC(5,2),(CAST(COUNT(CASE WHEN t6.state = 'INSTALLED' THEN 1 ELSE NULL END) OVER (PARTITION BY t5.pgroup) AS NUMERIC)/CAST(COUNT(t6.state) OVER (PARTITION BY t5.pgroup) AS NUMERIC))*100) AS INSTALLED,

CONVERT(NUMERIC(5,2),(CAST(COUNT(CASE WHEN t6.state...

ChrisM@Work (9/1/2015)

---

yb751 (9/1/2015)

---

You shouldn't have multiple CompanyID's stored this way. You'll want to normalize your data. You can't do joins that way unless the actual ID in tableB...