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.

I also don't have any experience in this part of sql but like I Tom I kind of guesses it would be 1 or 3. However answer #4 was just...

gsavitha (3/2/2012)

---

Dera Hall of Fame

Thanks for your reply

I am planning to retervie a 3 result set from a table.1st set contaning all record in the row 1,4,7,10 and so on

2...