First, I don't use sp_helptext...

Please post the DDL for the table(s), sample data for the tables, expected results after the update(s) are completed, and the code used for the updates (including code for the...

Jeff Moden (3/4/2013)

---

Charmer (3/15/2012)

---

SQLKnowItAll (3/15/2012)

---

The first problem is that @DecNumber is a BIGINT. You cannot store characters in BIGINT. First you need to change this to CHAR(2) or...

ScottPletcher (3/4/2013)

---

GilaMonster (3/4/2013)

---

ScottPletcher (3/4/2013)

---

GilaMonster (3/4/2013)

---

Bear in mind that a clustered index implicitly includes...

Based on your code, something like this will work:

WITH BaseData as (

SELECT

a.PLANT_NO AS PlantNumber,

SUM(a.APPLIED_VOL) AS AppliedVolume

FROM

[EdwStaging].[RAW].[FactSettleFee_TIPS_QRMTIPS_QPOST_SETTLE_FEE] a

GROUP BY

...

sunder.mekala (3/4/2013)

---

Hi Friends,

I have a requirement where i have to write a Sql for :

basically i have 2 columns 'startdate_SK' and 'enddate_SK' columns in table 'A'

'startdate_SK' is a integer...

No. Database mirroring has to be doe between the same versions of SQL Server.

prakashr.r7 (3/4/2013)

---

Eugene,

I can generate unique values....what i am asking is " How do you generate unique values for 40 rows ? " We can generate upto 36 right? How...

Best way to determine this is to setup a test environment and do it both ways. Using a default will alleviate the need for the developers to code for...

Lynn Pettis (3/3/2013)

---

First answer, yes. You can only have one mirroring endpoint per instance.

Regarding the second question, from MSDN:

LISTENER_IP = ALL | (4-part-ip ) | ( "ip_address_v6" )

Specifies the...

Chrism@Work brought to my attention a copy/paste error in my code. Please see the code below:

SET NOCOUNT ON

GO

--I changed the order of these functions to the order in which

--they...

First, your code as posted fails with this error:

Msg 8114,...

Easy peasy:

if exists(select 1 from sys.tables where object_id = object_id('dbo.Class'))

DROP TABLE dbo.Class;

if exists(select 1 from sys.tables where object_id = object_id('dbo.Amount'))

DROP TABLE dbo.Amount;

create...

Considering that Database Mirroring is accomplished at the transaction level I still don't have enough information to even try to answer your question. How about providing more details in...

Could be the fact that you double posted, or just that no one has an answer for you. I know I don't.

Please post any further responses here.