True. I had not refreshed the browser screen before I posted my reply, so I...

So I guess Lori stepped back?

I can write something about it, but you could also check out this first; http://sqlblog.com/blogs/hugo_kornelis/archive/2007/03/29/can-you-trust-your-constraints.aspx

(The blog post itself uses a check constraint to illustrate the...

Here is some code that does what you request. However, I do find the requirement to be quite strange - this appears to be a reporting/formatting issue, and those are...

I used to love Visio before Microsoft acquired it. I never liked the direction they took with the tool, and I liked each newer version less. I also do not...

kavithaje (2/10/2016)

---

Hi Allen,

The query is returning duplicate rows. i have same MachineID and InstanceKey in both tables. only Account. Schema class and time key is different. I mean Work_Station_Admin_1 got...

sqlfriends (2/9/2016)

---

so is it going to be something like this?

Note table: Noteid, NoteDetail, NoteDate, CreateDate, createdby

NoteBridgeTable:

columns: NoteID, NoteTypeID, Objectid (cannot find a good name for it)

Data:

Noteid, notetypid, hearingid

Noteid, notetypid,...

If you don't see anything when opening the file with XML tools, then I suggest that you first try using non-XML tools to visually inspect what you have. Can you...

Reported as spam

What you are proposing is a very bad idea. Dynamic SQL in itself is already a security risk, but the risk is limited if you properly parametrize it. However, table...

Okay. In your first post you write that the tables need "a column of note". Apparently that was incorrect, each of them needs the ability to add mutliple notes.

In that...

If the amount of data is not overly big, I would recommend looking into RedGate's SQL Data Compare utility.

sqlfriends (2/8/2016)

---

We have a new .net application that using entity framework.

In the database, there are going to be many tables like hearings, conference, workshop etc that needs a column of...

All static and fast_forward cursors use tempdb to store the results of the query. Very similar to what you are now doing with an explicit temporary table, just more efficient.

Keyset...

The simplest solution, if you are sure that the number of instances will always be three, is to use identity with a starting value of 1, 2, or 3, and...

You still have not posted INSERT statements for the sample data. So the below is untested.

I must also add that I don't understand your explanation of the requirement, and that...