jdasilva (5/9/2014)

---

Yes, and it currently is, but that query refines data based on a an office code selected...

I have a feeling the reason is because of performance? Have you tried changing your UNION to UNION ALL? It seems that since you have a date in there you...

Despite the fact that you are working with Oracle I would highly recommend you read up on normalization. The structures you presented need some serious help with normalization. You have...

scotsditch (5/8/2014)

---

I'm trying to do something so simple, it's driving me nuts. Especially since I remember doing it before.

I want to create a computed Column in a SQL Server...

Budd (5/6/2014)

---

I have 2 identical tables one contains current settings, the other contains all historical settings.

I could create a union view to display the current values from tableA and all...

No you don't...

hoseam (5/9/2014)

---

There has been few changes to this code..

Before I used to pass parameters

declare @Fund_Id varchar(50),

@Product_Id varchar(50),

@NewFund_Id varchar(50),

@NewProduct_Id varchar(50),

...

Well unfortunately my crystal ball is still out for repair. As a result I can't your screen, I have no idea what you...

Luis Cazares (5/8/2014)

---

jcrawf02 (5/8/2014)

---

WayneS (5/8/2014)

---

Ed Wagner (5/8/2014)

---

No real surprise there. I checked out the site quite some time ago and remarked to myself how miserable the questions were. ...

danielfountain (5/8/2014)

---

Hi all,

I am using a cursor (i know - but this is actually something that is a procedural loop).

So effectively i have a table of names of stored procedures....

Megha P (5/8/2014)

---

Sean Lange's code works perfectly ..with index seek

WHERE (@p_flag = 1 AND moveFlag = 26)

OR (@p_flag <> 1 --if this is a bit I would use = 0...

Good question about a topic I knew nothing about. Thanks Tom.

ramana3327 (5/7/2014)

---

Hi,

I need to do some analysis.

We have a database that track how much time it take to execute wcf service call or from UI controll call. I identified 1-2...

There is no execution plan attached. It would also be helpful if you could include table and index definitions.

Why are you using NOLOCK? Is missing and/or duplicate data acceptable? This...

Eirikur Eiriksson (5/7/2014)

---

NOLOCK turns the database...