sqlfriends (3/16/2015)

---

I found this article.

But I don't know how to make the order of table the same, for if there are multiple developers, it is hard for them to know...

adam.lawrence (3/16/2015)

---

Not an overly useful comment!

I have a very similar issue but to do with the Height of the report. Again SSRS generates an error stating 'height must be between...

While all this Bit Bobbling, and Digit Dicing is fun and groovy :cool:, isn't the problem that you are storing your RGB values as a CSV string?

If they were separate...

Scenario 1

------------

I want A and B

You want A and B

You take A

I take B

You try to take B, but I have it

I try to take A, but you have it.

We...

markjholmes (3/13/2015)

---

I'm guilty of a number of bad comments in my code. Some of my favorites are (all paraphrased):

Per {executive}, doing it this way.

This is a really bad idea...

You could just set up a subscription for the report and have that send the email or is that not suitable?

Grant Fritchey (3/10/2015)

---

Anyway, the best solution is to use OPENQUERY and do as much of the filtering work on the remote server as possible. Since you can use OPENQUERY as...

JeeTee (3/9/2015)

---

I am basing this assumption off the agregate of several articles on MSDN, Stack overflow and SSC

http://www.sqlservercentral.com/Forums/Topic344649-149-1.aspx

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/fbc52b71-a084-4315-9bb5-ebcb8e745c0a/with-nolock-across-a-linked-server?forum=sqldatabaseengine

http://stackoverflow.com/questions/9268438/cannot-specify-an-index-or-locking-hint-for-a-remote-data-source-sql-server-2005

plus the article in my OP.

I could be wrong; everyone on these posts...

JeeTee (3/9/2015)

---

Hi All,

I have two servers (lets call them sA and sB) connected from sA -> sB via a linked server (i.e. sA pulls data across from sB).

I'm building a...

Wow, I appreciate the kind thought, but I really...

What is the column specification for the date?

Hi Brandie,

You can add a ToolStripTextBox to the menu and bind it's Text property to an application setting, if that is what you mean?

Never had that problem, but I wonder is it the label that is 51 characters or the value?

bcp out/bcp in

MaggieW (2/25/2015)

---

Dear all:

I encountered a werid bug that I can't figure it out in my stored procedure.

Here's some sample code the can represent the scenario

Create Proc sp_test

@DeptID Int

as

Begin

...