sdhanpaul (10/22/2012)

---

I read that article about 100 times.

I read about 100 articles comparing different types of running sum...of which:

clr is the best way to do it but i cant get...

dj1202 (10/22/2012)

---

Hello everyone, I am working on a report that is passing parameters to a stored procedure for its dataset. I was thinking of simplifying the stored procedure and removing...

Like this?

create table #tblDoc

(

FromSender varchar(150)

)

insert #tblDoc

select 'John Doe1 <John.Doe1@abcd.com>' union all

select 'John Doe2 <John.Doe2@abcd.com>' union all

select 'John Doe3 <John.Doe3@abcd.com>' union all

select 'Some longer name <LongEmailAddressHere@LongDomainName.com>' union all

select 'Short <e@e.e>'

SELECT substring(FromSender,...

The running total problem is a difficult one in sql server. A cursor is one way to do this, however it is incredibly slow for this type of thing. Take...

ksharpe (10/22/2012)

---

You are FAST!

ok, give me a few minutes and I'll see if I can create the contsupp table from your examples.

I'll be right back - I'll try it out...

I think this is what you mean by 2 of the tables. The other table(s) is still pretty unclear what...

We do seem to end up on the same threads pretty...

ksharpe (10/22/2012)

---

Hi Sean

Thanks for your very prompt reply - you all are amazing. I recognize that you are volunteers and for those of us who rely on your generosity of...

joseph.moffatt (10/22/2012)

---

Hi all,

The SQL below *seems* to work as expected. However, it takes an awful long time to run. I would appreciate any advice how to improve this. Should I...

harri.reddy (10/22/2012)

---

well,

they gave me some tables(approx 9) tables and field that they want to fecth only those field.

they all r master table.so do i need to make table that connect...

Actually it really doesn't make it any easier. What would make it easier is...

This is a horribly...

harri.reddy (10/22/2012)

---

guys,

they gave me docs,which field they need and what lenght of data type.

my question is ,should i create logical /physical data model or start making table in sql server...

davdam8 (10/22/2012)

---

Yes, I omitted the rest.

I got this:

...

ORDER BY CASE WHEN CARAC= 'None' THEN CARAC ELSE CARAC END DESC

The problem is for each PROJ I get 2 times the same...

naqib_bs (10/22/2012)

---

I did the same think, but there is some administration problem in my windows, I am not administrator user

but I am member of administrator user therefore, it gives me...