Viewing 15 posts - 661 through 675 (of 761 total)
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...
April 24, 2012 at 2:26 am
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...
April 24, 2012 at 2:04 am
What authentication type is it??....SQL Authentication or Windows??
Please post the Error Message
April 24, 2012 at 12:58 am
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...
April 24, 2012 at 12:12 am
A UDF can be made dynamic. Please post the code of your UDF. So that we know what direction you're working in.
April 23, 2012 at 5:12 am
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)
April 23, 2012 at 4:55 am
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...
April 23, 2012 at 4:49 am
Nope...too good a problem for me...I guess...if you find a solution..do post it here...would love to know
April 23, 2012 at 4:36 am
riya_dave (4/17/2012)
i need help in my Stored procedure.
select empname ,(select case when empno is null then
begin
declare salary
declare @salary int
...
April 23, 2012 at 4:18 am
Please post some more sample data.
If you only give this much sample data then the solutions provided might not work always.
April 23, 2012 at 4:06 am
Guys...i think the OP should be using an SSAS Cube for this...won't it be simpler if the OP does that?
April 23, 2012 at 3:58 am
This was easy, but maybe this is what you are looking for.
SELECT * FROM Employees ORDER BY lvl desc, hid
April 23, 2012 at 2:53 am
stevro (4/19/2012)
You have to do something like this: In the future, please provide some testdata..
EDIT: Sorry, the above solution...
April 23, 2012 at 1:28 am
Viewing 15 posts - 661 through 675 (of 761 total)