Very nice one Anthony.

You need to be more precise about what you are trying to do. From what I understand this is the only way.

Declare @temp int = 11

Select * From Test...

You still haven't told us what you mean by "Crash"

If you think the time taken is Unacceptable then you are definitely on the right track.

In 99.99% of the cases Cursors can be avoided...because that is what SQL server is...

What authentication type is it??....SQL Authentication or Windows??

Please post the Error Message

Nope you can't do what you are trying to do in a UDF....by Dynamic UDF I meant the passing of parameters and the returning of values...which is done dynamically.

But, you...

A UDF can be made dynamic. Please post the code of your UDF. So that we know what direction you're working in.

Declare

@table varchar(30),

@col varchar(max),

@query varchar(max)

Set @table = 'tablename'

Set @col = 'col1, col2, col3, col4'

Set @query = 'Select '+@col+' From '+@table+';'

Exec (@query)

Even if you attach the mdf and ldf file using PowerShell, it will attach the files which actually crashed....right??

Shouldn't you be looking at other options like restoring a backup of...

Nope...too good a problem for me...I guess...if you find a solution..do post it here...would love to know

riya_dave (4/17/2012)

---

hi guys,

i need help in my Stored procedure.

select empname ,(select case when empno is null then

begin

declare salary

declare @salary int

...

Please post some more sample data.

If you only give this much sample data then the solutions provided might not work always.

Guys...i think the OP should be using an SSAS Cube for this...won't it be simpler if the OP does that?

This was easy, but maybe this is what you are looking for.

SELECT * FROM Employees ORDER BY lvl desc, hid

stevro (4/19/2012)

---

Given that the DB_Name will be duplicate the above solution wont work.

You have to do something like this: In the future, please provide some testdata..

EDIT: Sorry, the above solution...