I don't have a way to fully validate this but I am fairly sure Active/Active does not allow what you want. That said you might can install a second instance...

Antares686 (3/29/2012)

---

ColdCoffee (3/28/2012)

---

tommyh (3/28/2012)

---

Wouldnt something like this work just as well?

SELECT

CustomerId

FROM #Purchase

GROUP BY CustomerID

having sum(case when ProductCode = 'A' then 1 else 0 end) > 0

...

ColdCoffee (3/28/2012)

---

tommyh (3/28/2012)

---

Wouldnt something like this work just as well?

SELECT

CustomerId

FROM #Purchase

GROUP BY CustomerID

having sum(case when ProductCode = 'A' then 1 else 0 end) > 0

...

Just playing with it a bit, including an effective date.

DECLARE @Shipping AS TABLE (Minimum money null, Maximum money, ShippingCost money, UseDeminshingCalc bit, DateEffective datetime)

INSERT INTO @Shipping VALUES (0.00,60.00,10.00,1,'20120101'),(0.00,80.00,5.00,0,'20100101'),(0.00,100.00,5.00,1,'20070101')

DECLARE @orders TABLE...

Some additional things to consider is take a snapshot of the database size and logfile size before and after a load to determine database growth. Then set a growth value...

First off what specifically is slowing you down? Is it loading of new data or querying existing data? Hase you profiled the system to see what is taking up the...

Munabhai (3/28/2012)

---

create table omar.dbo.a123

(

contactid char(10),

firstname varchar(20),

emailaddress varchar(20)

)

CREATE NONCLUSTERED INDEX IX_NC_PresidentNumber

ON omar.dbo.a123 (EmailAddress)

Let's assume,...

Can you also post the DDL of the table. If the table has a clustered index on firstname then that value is automatically included in non-clustered indexes and thus is...

First and foremost you shot your own foot off with this.

On Error Resume Next

As this will just skip the error and report success, so please remove because you want...

OK let's back up here. Typically there are not concurrent users on an SSIS package as packages are importing/exporting/data mining and other wokflow tasks at a non-async time in relation...

sturner (3/28/2012)

---

I have seen this over and over again through the years. More often than not, VB programmers were self-taught or migrated to VB from vbscript (or VBA like with...

Consider rewriting the query would be my first choice. 1 thing I notice is the inner most subquery outputs p.Note which is not used in the upper subquery and in...

For a fixed list then use patindex like this

SELECT Description, substring(IsNull(Description,''),PATINDEX('%[¢ç°ÇãÂ~´/^]%',IsNull(Description,'')),1)

FROM TBProduct

WHERE ...

This might help http://sqlserversolutions.blogspot.com/2010/12/execution-tree-in-ssis.html

I do have 1 question

Exactly what is a special character to you? Some people might include a period or dollar sign as considered special. So need to be sure there...