hydbadrose (9/20/2011)

---

The data is sample is in bracket (Milestone #1), (1. A Nat System Must Be band at the Community Level)

(A. Develop Protect-Prep Comm), (1.1.A ) and you are saying...

It depends on your business requirements, not on what someone else might think based on a very, very small data sample.

They all look like strings so a varchar would be...

WHERE ColumnName NOT LIKE '%[0-9]%'

Use the Windows...

You don't need all those NULLs, just:

EXEC msdb.dbo.sp_get_composite_job_info @execution_status=1

Second that!

I would guess you're talking about Reporting Services, Yes?

And you want to be able to click on one of the rows in your report which then opens the appropriate report?

Yes, see http://www.sqlservercentral.com/Forums/Topic1171862-391-1.aspx

Sorry, don't understand your question, you're going to have to explain in more detail what you're trying to do.

You can't use a variable as the table name in a SELECT statement, you will need to use dynamic SQL.

Start here Dynamic SQL

Beware when using the BETWEEN operator, it is inclusive of the values of the two expressions.

From MSDN:

BETWEEN returns TRUE if the value of test_expression is greater than or equal to...

Try this:

DECLARE @sql VARCHAR(MAX)

SELECT

Nice one John

Something like this:

SELECT DISTINCT

o.name

FROM

sys.columns c

JOIN

sys.objects o ON c.object_id = o.object_id

WHERE

c.name = 'ItemInsertedWhen'

AND

o.name LIKE 'CMS_%'

AND

o.type = 'U'

Join with the sys.columns table