Lucky9 (6/12/2013)

---

I have a stored procedure to do the performance tuning, so below are the list of questions could someone please reply

below is the sample format of query inside the...

rick_markham (6/12/2013)

---

On your comment around my choice for view design it is personal preference. We use SQL Server as a staging area for data migration using SAP Data Services...

Like this?

select isnull(A.Name, 'A is null') as AName, isnull(B.name, 'B is null') as BName, C.Why

where A.ID = B.ID

and C.ID = A.ID

I understand your requirements. This is a bit challenging. Since you are brand new around here I went ahead and put together some ddl and sample data in a consumable...

rick_markham (6/12/2013)

---

thanks for the reply. Actually the issue is some kind of configuration setting with management studio. I can not remember what attribute to set.

I can right click...

Something like this should help you get started.

set dateformat ymd

select case left(AS400, 1)

when 1 then cast(RIGHT(AS400, 6) as datetime)

when 0 then DATEADD(year, -100, cast(RIGHT(AS400, 6) as datetime))

end as CalcDate

from...

Excellent question Hugo. I think the most disturbing thing is that at the time of this posting 38% of responders think there are rows that between -1 and -10!!! 😛

What you have here is known by some as a triangular join. It is in fact horribly slow and inefficient. Take a look at this article that explains what you...

A 2012 instance can restore a...

mike.dinnis (6/12/2013)

---

Hello,

I have a table with five fields used to hold address data. Due to poor practices the users have been able to enter any data in any field. They...

rick_markham (6/11/2013)

---

There must be a way to drag a table into the design diagram pane of a view. What is the configurate setting to allow this. currently in...

Sample data as outlined by reading the article found at the first link in my signature. Additionally you really should start...

Or you could use the DelimitedSplit8K.

SELECT *

FROM( VALUES('LC,AMB'),('LCAND, CMB'),('ABC, LC'),('LC'),('Welcome')) x(String)

cross apply dbo.DelimitedSplit8K(replace(String, ' ', ''), ',') s

where s.Item = 'LC'

You can find that code by following the article in...

"Overhead" in encryption is referring to the...

Paresh Motiwala (6/11/2013)

---

Hi Sean

Thanks for your response.

But the query runs fine in 47 seconds.

It just doesn't run in SSRS or Report Builder.

It used to work before.

So if you can help,...