guerillaunit (3/5/2012)

---

Hi Eugene,

I'd like to divide the statement into separate subscripts because the subscripts need to be processed in sequence. I was opening to use the GO command so...

You could also add a left to the order by in my example if your real data is longer than 1 character.

order by

case left(MyChar, 1) when '!' then 1

...

Here is another way of doing something similar to the previous example.

create table #Chars

(

MyChar char(1)

)

insert #Chars (MyChar)

values

('!'), ('"'), ('$'), ('?'), ('@'), ('^'), ('{'), ('>'), ('1'), ('2'), ('3'), ('4'), ('5'), ('6'),...

Jonathan AC Roberts (3/5/2012)

---

Sean Lange (3/5/2012)

---

Jonathan AC Roberts (3/5/2012)

---

drew.allen (3/5/2012)

---

The original question was about taking multiple values and...

Jonathan AC Roberts (3/5/2012)

---

drew.allen (3/5/2012)

---

The original question was about taking multiple values and storing them in a single...

+1

Did you try it??? Of course it won't work. There are a number of problems with that, not the least of which is you can't have a use statement in...

Well you already have the OBJECT_ID so it is pretty simple.

SELECT OBJECT_NAME(ep.major_id) AS [ObjectName],

CAST(Value AS nvarchar(500)) AS [MS_Description]

,OBJECT_SCHEMA_NAME(ep.major_id) as SchemaName

FROM sys.extended_properties AS ep

WHERE ep.class = 1 AND ep.minor_id = 1

ORDER...

Are you using this parameter as a where clause? It sounds like that...

Or you could make it more of a table type structure.

SELECT COUNT(assignment) AS ShiftCount, 'FirstShift' as ShiftDescription

FROM tb_DNM_1_employee

WHERE (assignment = '7') and (rank = '1')

union all

SELECT COUNT(assignment), 'SecondShift'

FROM tb_DNM_1_employee

WHERE (assignment...

Thanks for posting clean ddl and sample data...goes a long way!!!

I am not totally clear if you wanted the literal "BLANK" or an empty string so I wrote it both...

Hi and welcome to SSC. It is very unclear what you trying to do here. Take a look at the first link in my signature about how to best post...

Did u look at BOL? http://msdn.microsoft.com/en-us/library/ms177541.aspx

SELECT OBJECT_NAME(ep.major_id) AS [ObjectName],

CAST(Value AS nvarchar(500)) AS [MS_Description]

FROM sys.extended_properties AS ep

WHERE ep.class = 1 AND ep.minor_id = 1

ORDER BY OBJECT_NAME(ep.major_id)

Best place to start would be the first link in my signature.

You are welcome. Hope you were able to tweak to get what you needed.