That is rather strange but it should work fine.

Thank you for the motivation. I have been meaning to finish my article about using guids as primary keys. I have been swamped at work lately but I have also...

Luis Cazares (4/2/2014)

---

I believe that there's an error in the logic of the trigger since there's no change in the data. If the information hasn't changed, then the datechanged value...

asita (4/2/2014)

---

Hello Please help me,

i have a table with 500k rows, need to split into 3 sets(please assume need to insert 500k into 3 tables)

Segment column has 3 values SEG,MOR,CLN

Balance...

JoshDBGuy (4/2/2014)

---

I've run into issues in the past dealing with extremely poorly written queries with LINQ. I've been under the impression for awhile that LINQ is fine for very simple...

Your answer starts here. http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

You need to post details with your questions instead of vague scenarios with no information.

RonKyle (4/2/2014)

---

I'm sure this is true, but I haven't run into one yet. Once I thought I had, but...

Since you said you are new to sql I would like to offer some suggestions.

You should use ANSI-92 style joins instead of the older ANSI-89 style. It is easier to...

But it does enforce that everybody uses the same exact code style because the style is actually part of the syntax. No arguments over:

if(SomeCondition){

DoSomething();

}

vs.

if(SomeCondition)

{

DoSomething();

}

Still seems quite strange. I can almost imagine the discussions in a bug tracker. "Oh I forgot to add an empty line to end the IF statement".

Or..."just added a tab...

I thought the question was a good one. However I too was trying to guess the 5th choice. I reread the question and it says

You're about to test updates...

GilaMonster (4/2/2014)

---

To concatenate values together...

location = ''.join(['New','south','wales'])

"This will feel natural and elegant to the initiated."

and I thought readability was crucial.

Edit: The snide comments are more directed to the training course...

kevin_nikolai (4/1/2014)

---

I compared the functions DelimitedSplitN4K and SplitList for accuracy and speed:

Found that if you are calling the function Split in the where clause of many of your cte's as...

JoshDBGuy (4/1/2014)

---

Since he has 400 million rows, should this be done with one statement or should this be done in batches? Moving hundreds of millions of records is probably going...

Maybe you can aggregate your data into another table, drop the current table and rename the newly created one?

Since you can't rename a temp table I changed your sample code...