I'd also agree you're better off posting the execution plan rather than just removing elements of your query.

Admittedly, the more experienced you are, the more likely you will be able...

sqlguy-736318 (3/23/2015)

---

Hello, do you know how I can get the following dll?: Microsoft.SqlServer.Management.Common.dll

I have SSMS 2014 installed on my computer but the following search from the command prompt does not...

timthetraveler (3/21/2015)

---

Guys,

I'm trying to quantify the number of times folks use SQL Server Management Studio to change client data in one of our production databases. Does SQL Server keep...

sqldoubt (1/16/2012)

---

My intellisense used to work until yesterday. But it stopped working today.

There were no installations made on that server. Also I tried to enable it from tools->options and restarted...

Guras (3/18/2015)

---

Can we bulk insert only the desired column from a flat file to a table?

I am using SSIS to bulk insert from a file with more than 200...

Sure.

What I'm suggesting that you could do is add:

1. Add a new variable to your package called "FileExists"...

QQ-485619 (3/17/2015)

---

I need to create a script task in sql server 2008 R2 to check if a file exists in a directory. For example, to see if output.dat exist under...

Maybe this tool might help too...

http://www.apexsql.com/sql_tools_search.aspx#Features

It's free.

Katerine459 (3/16/2015)

---

Hi,

So, you know how if you right-click, say, a table object, in SSMS, and one of the options is, "Script Table As" and then you get a bunch of...

Jim5130 (3/12/2015)

---

Hi,

I am a newbie in creating SSIS package. The basic import of CSV files into our SQL Server 2008 DB is working fine but I have to set...

From the initial response to your question, it's clear that your question is quite vague?

You always want to help avoid people guessing at what your problem is as it takes...

do...

If you're new to all this, I think you might be better off familiarising yourself fully with the tools that come with sql server out of the box first.

Once you...

Radiance (10/23/2014)

---

Using SP_ALTER_MESSAGE.

My test: setting is_logged_message from 1 to 0, but the message still be in ERRORLOG when certain event occurs. It's like SQL Server bypassed ...

Maybe...

SELECTCity,

StuStatus,

CurrentValue,

COALESCE(NULLIF(week1,0), NULLIF(week2,0), NULLIF(week3,0), NULLIF(week4,0)) AS Week1,

COALESCE(NULLIF(week2,0), NULLIF(week3,0), NULLIF(week4,0)) AS Week2,

COALESCE(NULLIF(week3,0), NULLIF(week4,0)) AS Week3,

Week4

FROM #StuDetails;