If you look at the execution plan, you'll see that SQL converts the IN list into multiple OR conditions, so there's no difference.

Great, no problem.

Luis Cazares (11/13/2014)

---

Gazareth (11/13/2014)

---

Presuming from your other post you're looking for a VB answer:

=StrConv(Fields!FieldName.Value,vbProperCase)

Note there's a Reporting Services section further down the page where you'll have more luck with VB,...

No problem. Of course, if you're interested in learning T-SQL, this is definitely the right...

Presuming from your other post you're looking for a VB answer:

=StrConv(Fields!FieldName.Value,vbProperCase)

Note there's a Reporting Services section further down the page where you'll have more luck with VB, anything you post...

Can't remember if the AND will work, you may need nested IIF functions, so one of these should work:

=IIF(fields!addressline1.Value < "," AND fields!postcode.value < ",", "No Details", Fields!addressline1.Value)

or

=IIF(fields!addressline1.Value <...

I actually encountered this exact behaviour last weekend. Got me a bit worried!

My explanation would be that the CTE is never materialised as such, so the rn value is never...

Powershell sounds good for this. You'll need to install SQLPS module, and then simply (NB - pseudocode):

Invoke-SqlCmd -ServerInstance servername -Database dbname -Query "EXEC proc" | Export-Csv filename.csv

or

Invoke-SqlCmd -ServerInstance servername -Database...

Try putting the SQL 2014 path before the other SQL paths in the environment variable?

Ed Wagner (11/4/2014)

---

I don't want to condemn the updates to failure or...

TomThomson (11/6/2014)

---

Good question.

It raises an issue about the quality of this wizard: why on earth doesn't it read metadata for the target table and set lengths accordingly? It...

Hire two temps for a week & give them 5,000 addresses each to go through 🙂

Just use the exists in a case statement:

select *, case when exists(select * from dimFacts df2 where df2.lead_id = df.lead_id and df2.referrals = 1 and df.moves = 1 and df2.date_value...

Hi, and welcome to SSC.

You should record the price in both places; while it may seem like redundant data they're actually separate attributes - one's the list price and the...

happycat59 (10/30/2014)

---

Steve Jones - SSC Editor (10/6/2014)

---

Agree with HappyCat. I'd set up the same jobs on both servers, but disable the jobs on the secondary. If you failover, you can...