SELECT * FROM syscolumns WHERE columnproperty(id,column_name,isidentity) = 1

Hope this link helps

http://www.tek-tips.com/viewthread.cfm?qid=1488839&page=10

Sorry I didnot notice the group by clause. Here's the correction

select r.row_choice,isnull(leftlabel_avg,.001),isnull(rightlabel_avg,.001) ,

@left_label as left_label,

@right_label as right_label

from

#rowtmp r

left join

(select inner_qstn_text, ...

That's really great to hear 🙂

You're welcome 🙂

Does this work?

select r.row_choice,isnull(leftlabel_avg,.001),isnull(rightlabel_avg,.001) ,

@left_label as left_label,

@right_label as right_label

from

#rowtmp r

left join

(select inner_qstn_text,

case

when rad.inner_qstn_choice = c.left_label

then Avg(cast(c.seqn as float)) else null end as leftlabel_avg,

case

when rad.inner_qstn_choice =...

Table structure is important. 131000 is not really a big number. It would be great if you could provide the kind of indexes that exist on the tale and how...

This makes use of recursive logic

Initially create a function and a procedure:

CREATE FUNCTION GetLowestOrderID (@OrderID char(16))

RETURNS char(16)

AS

BEGIN

DECLARE @LowerMostOrderID char(16)

SELECT @LowerMostOrderID = tsv_orderid FROM testsv A WHERE tsv_ord_ref_reorder = @OrderID

IF...

Just a wild guess. Could you pelase check the output of this query in the script?

select name from master.sys.databases where state_desc = 'ONLINE' and is_read_only = 0 order by name

The...

I believe you would have to add a linked server and make remote procedure calls through the trigger. Please see documention for sp_addlinkedserver to add the remote server as a...

Could you please share the backup creation script?

Thanks

Satish More

Since the user selects only some of the reports, you may have to put the filter in the query too

select distinct questionid from questions D where D.questionid not in

(select...

This is indeed a very interesting question and I tried my hand on it too. Here's the table creation script:

create table questions (reportid int,questionid int)

insert questions

select 1,1

union all

select 1,2

union...

Hey Dietmar

We had a similar issue on board earlier and Gail had a solution for it.

http://www.sqlservercentral.com/Forums/Topic695034-357-1.aspx

Do check this also out.

Thanks

Satish More

I hope this link turns out to be useful:

http://social.msdn.microsoft.com/Forums/en/sqlreplication/thread/34ab68ad-706d-43c4-8def-38c09e3bfc3b

Please do let me know

Thanks

Satish More

Secondly I would also suggest you to check in case any disaster recovery method like mirroring is configured. In case mirroring gets suspended, logs would not truncate.