I moved this to the t-sql forum area because it is t-sql i'm looking for and it appears to be getting more traction.

http://www.sqlservercentral.com/Forums/Topic862522-392-1.aspx

sorry for the ambiguity

i've attached a more descriptive doc of what i'm looking for w/ screen shots. Forgive me but i dont know how to manipulate these forum posts vary well. The attached...

Roy if you run what u sent me in the msdb database you will see the sysjobhistory, sysdtspackages etc tables are returned. Notice that their under the system tables folder...

in my instance i want to return all the talbes in my DBA database minus the system tables under the DBA database. However the below returns all the tables plus...

that didnt work. It's still returning the system tables.

Let me clarify. I'm not talking about the tables from the system database.

I'm talking about the system tables listed under a regularly...

very nice. i wouldn't have thought about using the parse name. nice work.

THIS WILL WORK AS WELL. A LITTLE CLEANER

Declare @string varchar(200)

Set @string = 'Ford; homeslice SSSSSSHAABABSHBA WORKABLE ; 2001; 99,000'

SELECT RTRIM(LTRIM( SUBSTRING(@STRING, LEN(LEFT ( @STRING, CHARINDEX(';', @STRING)))+1 , CHARINDEX(';', @STRING, 6)...

actually i dont think that will work in this instance

this will WORK however IT COULD BE DONE A BIT CLEANER HOWEVER I'M LEAVING FOR THE DAY

Declare @string varchar(200)

Set @string...

if the model will always be the second value in the delimited list then i would go online and bring down the split function. Which is below

---------------------------------------------------------------------

CREATE FUNCTION dbo.Split

(

@RowData nvarchar(2000),

@SplitOn...

Will the models always be the second value in the delimited list? Or will you have to join this to a model table that holds all the models?

thanks. that worked.

when i say thanks guys i mean thanks Jeff.

I didnt realize you had replied several times. Either way nice work!

trying to wrap my mind around what u guys did.

first:

DATEDIFF ( datepart , startdate , enddate )

So DATEDIFF(hh,0,UtcTd) = 956142. What is that. The number of hours since when? 1900?...

sounds like bad code to me.......i would hesitate changing it late friday unless ur glutton for punishment.

I grew up w/ a mike french. ur not from florida are u?