kabaari (10/4/2011)

---

Any idea how to resolve this?

select count(distinct d.sn) as quantity, sum((l.labor) / 1000) as laborhour , sum(cast(l.labor as decimal(18,2)) * count(distinct d.sn) / 1000 * 23.37) as appLabor

from shippingLabor...

The drop down has three values:

Do not subscribe

No email notification

Immediate notification of new posts by email

I suggest a new option

Immediate notification of new posts to your posts only by email

Sometimes...

JimS-Indy (10/3/2011)

---

I'm creating a stored procedure. It "clones" bills of material. It has four params:

@NewBoMID (the ID of the "Target" Bill of Material that will have the "clone" added to...

A thread is someone's question correct? So if I respond to a thread, I don't necessarily want to be emailed when other people respond to the same thread unless...

Ninja's_RGR'us (10/3/2011)

---

Actually along the same lines. I've subscribed to a couple forums and I keep getting 1 mail for new topic + 1 mail for new post for every...

The codeproject can have some decent people answering questions on their forums.

http://www.codeproject.com/

Matthew Lehn (10/3/2011)

---

You can actually put a collation into the replace function, i.e.

SELECT test = REPLACE('Lock' COLLATE SQL_Latin1_General_CP1_CS_AS,'l','kn')

which in this example will return "Lock" since I set it to case-sensitive....

Matthew Lehn (10/3/2011)

---

I have an interesting issue that I am hoping someone could explain or otherwise help me diagnose. Suppose I have the following:

SELECT [UnicodeLower] = REPLACE(N'aerostar Inc',NCHAR(230),N'ae(lower)'),

[ASCIILower] = REPLACE('aerostar...

Glad you got it working.

Ben

mike 69307 (10/1/2011)

---

So i need to bring the create table to the top above the select statements, and then add this to the select statements?

t.finalplace , t.totalpoints

FROM vwFullPlayerInfo fpi

join

mike 69307 (10/1/2011)

---

I have been working on this and have some of it completed but am unable to join the stored procedure. The first part of this code is my...

mike 69307 (9/30/2011)

---

I have spent the last few hours trying to get that to work. It should be fairly simple yet it will not work for some reason. Would it...

What programming language are you using? Is this a .net application? If it is and you have a key that matches between your two result sets. You...

I...

Chris Becker (9/29/2011)

---

SQL Server 2008R2 Standard 64-bit, Service Pack 1. On Win2008 Std Server 64bit Service Pack 1

Stored procedure call from .Net client is timing out. A bit...