Knowledge Draftsman (4/18/2013)

---

I think that would introduce concurrency issues unless you get really creative with the naming here. I don't understand why you care what the name of a default...

You are welcome. You should check some of her other posts too. She...

Knowledge Draftsman (4/18/2013)

---

Lowell, thanks for the reply.

You can create default constraints, but it doesn't appear that you're allowed to name them....

A couple of things are going on here. First the reason the numbers are not sequential is because an IDENTITY column is really the number of attempted inserts. You had...

patrickmcginnis59 10839 (4/18/2013)

Time and again I've read in the news folks absolutely ruin their own lives over dumb forum stuff even when posting under what they perceive as an anonymous...

It really doesn't matter which order, it...

I know I am bit late to the game on this one but since nobody else mentioned it, you need to be careful that NOLOCK hint. Do you know why...

Well you certainly don't need 4 updates for this. Not quite sure why in your original you used some many updates. This can be done a lot faster (at least...

You can't. No big deal. It is best if somebody lets other know it...

BOL = Books Online.

http://msdn.microsoft.com/en-us/library/ms130214.aspx

This should be in your arsenal of things you look at daily. The topic of SQL server is just entirely too large and complex to remember...

patrickmcginnis59 10839 (4/18/2013)

---

Sean Lange (4/18/2013)

---

patrickmcginnis59 10839 (4/18/2013)

---

Also, keep in mind, many of the "highly rated" posters actually get points for posting rote replies like "see this post for instructions on...

Duplicate thread. direct all replies here. http://www.sqlservercentral.com/Forums/Topic1443974-391-1.aspx

You are welcome. You might take a look at BOL for DATEPART. There a number of things you can check for.

Stephanie Giovannini (4/18/2013)

---

Interesting idea...

We use SqlDataRecord and SqlMetaData to populate the rows of the table type in C#. I suppose the C# could look up the columns and...

venkyzrocks (4/18/2013)

---

The question is the last part . The fact table needs to updated with the news ids.

Please see the last table. That is the result form I need...