Small modification:

EXEC master.dbo.sp_msforeachdb 'USE [?];

SELECT t.name, c.name, ''?'' AS [database]

FROM sys.tablest

JOIN sys.columnsc ON t.[object_id] = c.[object_id]

WHEREt.[type] = ''U''

AND c.name LIKE ''PAtient_Something%'';';

You linked two Boolean expressions together with AND, meaning both must return TRUE in order for the WHERE clause to return TRUE.

However, looking at the first parts already leads to...

I have run against the same issue with filter tables in Excel. In the end I filtered them out just like you did.

Regarding your question about other kind of tables...

There is no need to use caps. It's pretty annoying.

Something real quick I came up with:

EXEC master.dbo.sp_msforeachdb 'USE [?];

SELECT t.name, c.name

FROM sys.tablest

JOIN sys.columnsc ON t.[object_id] = c.[object_id]

WHEREt.[type] = ''U''

AND...

GilaMonster (1/19/2015)

---

And I have 30 grads doing a homework exercise that requires they import data from flat file into SQL Server (import/export wizard is the way everyone who searches google...

kevaburg (1/19/2015)

---

Koen Verbeeck (1/19/2015)

---

David Burrows (1/19/2015)

---

I'm on 2008R2 and I set my project properties for Debug/Release configurations for dev and prod respectively.

When I want to deploy I select Build/Configuration Manager...

David Burrows (1/19/2015)

---

I'm on 2008R2 and I set my project properties for Debug/Release configurations for dev and prod respectively.

When I want to deploy I select Build/Configuration Manager from the menu...

Grant Fritchey (1/19/2015)

---

Eirikur Eiriksson (1/19/2015)

---

Grant Fritchey (1/18/2015)

---

WayneS (1/18/2015)

---

I'm curious...

How many folks have a home lab set up with servers?

How many folks just use virtual machines on a computer (be...

What I would do:

* Read the flat file like you normally would, i.e. with a flat file source. You can use a for each loop container with a wildcard to...

I believe - but don't quote me on this - you get some MSDN subscriptions.

(Or you have to be a gold partner for this)

Sometimes when MS is working with a...

TomThomson (1/16/2015)

---

Koen Verbeeck (1/14/2015)

---

The question of today wasn't bad...

The WHERE clause is for the SQL statement in the data set 🙂

Instead of using NULL in the filter, use "Nothing" instead.

Nice trivia, thanks.

It seems strange to me that adding a column would cause the table to be dropped. Did you use the ALTER TABLE statement?

In my opinion, the blank column issue could...

ChrisM@Work (1/15/2015)

---

Koen Verbeeck (1/15/2015)

---

ChrisM@Work (1/15/2015)

---

or resolve it in the string:

+ '

FROM employee m

LEFT JOIN shiftdetails b ON m.empno = b.empno

where b.shifttype = ''' + @shifttype +...