hoseam (11/10/2016)

---

I have a procedure that has this Update statement

@TableName varchar(128) ,@SourceCount int

if @TableName = 'AcctStatus'

BEGIN

update dbo.MonitorDetail

set NoOfRowsLoaded = isnull((select count(1)

from document.Status with (nolock)), 0),

...

tocy1980 (11/10/2016)

---

A have already tried format to text, number, custom etc. but still nothing.

I would like to avoid opening...

hegdesuchi (11/9/2016)

---

i have to check if record exists in table , if there is record then update else insert.

Stg_table

Id seq name company

1 ...

liorvikel (11/9/2016)

---

i have linked server to oracle.

when i insert like that

insert into [LinkedSRV]...[xfer_in_order] (seq_id, action_type, action_code, batch_id)

values(2001, 'PTL_TEST', 'M', 'Batch001')

he put the value into oralce but oblivious ...

david.jack (10/27/2016)

---

Hi,

I'm very grateful for any light that can be shed on this. My code was per the following:

SUM( ISNULL( NULLIF(VAL1,0), VAL2) )

My understanding is that this should return the...

This sounds like an IDEAL candidate for the "data driven subscriptions" feature available in the "enterprise" version of SQL Server. You can customize an SSRS report by adding a...

rjjh78 (11/7/2016)

---

Thank you for those who replied. I think I did a bad job explaining what I wanted to do. Below I have provided sample code and 2...

philand3 (11/5/2016)

---

Hello sgmunson,

Thanks for trying to come out the quality answer. And thanks to chris who is continuously replied my query's without any hesitation.

I had 4 different requirement for which...

Ed Wagner (11/4/2016)

---

Yes, I've encountered that exact error using SSMS 2008 and SSMS 2012. It's normally when I try to copy large data sets from SSMS to paste elsewhere....

anjaliagarwal5 (11/4/2016)

---

I tried doing this:

select * from testTable

order by

case TestName

when 'Prod' then 1

...

Without a way to reproduce the issue, it would be difficult for anyone to be able to help solve it, but... if you can reproduce this, at least specify the...

Eirikur Eiriksson (11/4/2016)

---

sgmunson (11/4/2016)

---

And here's an alternative that achieves the desired output (however conflicting with the original post that may be...), and shows the performance characteristics, as I'm guessing this...

And here's an alternative that achieves the desired output (however conflicting with the original post that may be...), and shows the performance characteristics, as I'm guessing this sample data would...

Eirikur Eiriksson (11/4/2016)

---

sindhupavani123 (11/4/2016)

---

My output should look like this:

Clientfields value ...

ChrisM@Work (11/4/2016)

---

sindhupavani123 (11/4/2016)

---

I have the following data with client account decision and status

Clientfields value

111Decisionaccept

111Statusdeposited

112decisionaccept

113Decisionaccept

114Decisionaccept

114Statuscontract

115DecisionConditional Accept

115Statusdeposited

116DecisionConditional Accept

117DecisionConditional Accept

118Statuscontract

118DecisionConditional Accept

I would like to get

...