arayametee (2/4/2014)

---

Hi, all:

I used Ling To Sql, OR Designer to drag-drop Employees table from Northwind.mdf and showed all the fields on vb. winform but the photo from the image field....

Dae (2/10/2014)

---

The message is as follows..

"Message

Executed as user: NA1\svc-sqlfact. The step succeeded."

It's just weird... Everything points to it running fine, you you know it didn't because it will run in...

The post seems to indicate that you are running a SSIS package in a job - correct?

When you go to Job Activity monitor, right click the "completed" job and click...

Never mind. This is master database. Retracted.

krypto69 (2/10/2014)

---

Hi,

I'm restoring to a remote DB for our DR testing.

After the restore I need to create come user mappings to certain DB's. For example we have a DB called...

dwain.c (2/4/2014)

---

This code gets me a non-clustered INDEX Scan on 2008 R2 and 2012.

CREATE TABLE #TempTab

(

ID INT IDENTITY PRIMARY KEY

,PhoneNum VARCHAR(10)

...

g.mclachlan (2/4/2014)

---

Hi

First time poster on this forum so I apologise if there is already a topic about this elsewhere or even if I have posted in the wrong place.

I am...

Golden_eye (2/4/2014)

---

0

down vote

favorite

I have a problem with my Merge statement (SCD type 1). I am getting the error: Msg 207, Level 16, State 1, Line 119 Invalid column name 'Sales...

James Millar-305032 (2/4/2014)

---

Hi there,

I need to join onto a table (Class_TB) twice because one of the conditions (Airline_FD) could be NULL, so there are 2 LOJ's but this has a...

service 87594 (2/4/2014)

---

I'm trying to convert an Access query to SQL and I've run into a few problems. Here is the first, I need to exclude records when a...

ronmoses (2/3/2014)

---

Hmmm... it...

My pleasure. This may...

djj (2/3/2014)

---

Thank you.

So it would be like?

WHERE PhoneNum not like '%1111111'

AND PhoneNum not like '%2222222'

AND PhoneNum not like '%3333333'

AND PhoneNum not like '%4444444'

AND PhoneNum not like '%5555555'

AND PhoneNum not like...

Hi.

Your code will inevitably result in a table scan.

So would my only candidate replacement, which would replace the RIGHT function with a NOT LIKE '%1111111'

Thanks,

John.

Chris has the solution unless you only want the distinct values (in other words, if you have 7600 records from Calgary, you only want one result row for the city),...