Thanks Jack

i would not have figureed that out especially when putting the LEFT statement on two lines

LEFT(CASE @TestVal

xx

xx

xx

END, 10) TestVal ;

is that the way all functions...

Hi Jack

lets say my example is this:

DECLARE @TestVal INT

SET @TestVal = 3

SELECT

CASE @TestVal

WHEN 1 THEN 'First One XXXXXXXXXXXXXXXX'

WHEN 2 THEN 'Second One XXXXXXXXXXXXXXXX'

WHEN...

Hi Lynn

that will work 🙂

is there anyway to interject a CAST statement to manipulate the length of the value ?

Thanks

Jim

Hi Eddie

Thanks very much for sharing your code

I will try these out and see what it gives me

Appreciate Your TIme

Jim

Thanks Matt

Jim

Hi Julian

you may find this helpful

http://www.mssqltips.com/tipprint.asp?tip=1328

Jim

Hi Folks

can someone tell me if there is a way to just select certain attributes from sp_spaceused

I am trying this out as an example:

USE AdventureWorks;

GO

EXEC sp_spaceused @updateusage = N'True';

GO

it...

Thanks RML51

Jim

Thanks Perry

Jim

Excellent Matt

I found it

Thanks very Much

Jim

Not at this time and no plans to

Jim

Hi Perry

got it

but can i just move these two files since they are not attached, when i move the system databases ?

Thanks

Jim

Hi Folks

I have the distmdl.mdf and .ldf files on my c drive but they are nor currently attached

can i just move these two files to their new location after...

I have not tried this yet but i do have the same question about mssqlsystemresource.mdf

as well as a database called "distmdl.mdf" as i am not sure what that is

Thanks

Jim

Hi Raj

thanks for your input

Jim