Viewing 15 posts - 676 through 690 (of 844 total)
For years we struggled with being able to identify where certain transactions came from. We finally added a field in the last year, to a few of our key...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
June 5, 2014 at 7:32 am
GilaMonster (6/5/2014)
Koen Verbeeck (6/5/2014)
GilaMonster (6/5/2014)
thomashohner (6/5/2014)
What is the preference on column aliases ?AS. Equals sign is for comparing values or assigning values. 😀
Yes, you assign the result of the expression...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
June 5, 2014 at 7:14 am
Sean Smith-776614 (6/2/2014)
below86 (6/2/2014)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
June 4, 2014 at 10:01 am
Evil Kraig F (6/3/2014)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
June 3, 2014 at 3:09 pm
Jeff Moden (6/3/2014)
My greatest pet peeve of all is what some people claim to be "best practices".
That's funny you would say that, we have been told we need to start...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
June 3, 2014 at 1:21 pm
I've played about 4 times so far, haven't lost yet. Come close to loosing, been down to my patrol boat but was able to sink the computers remaining two...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
June 2, 2014 at 7:43 am
below86 (5/30/2014)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 30, 2014 at 8:10 am
Formatting is my biggest pet peeve. This includes indenting code, spaces between column names or in the where clause. I'm trying to get in the habit of capitalizing...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 30, 2014 at 7:50 am
Sean Lange (5/29/2014)
SQLRNNR (5/29/2014)
Sean Lange (5/29/2014)
Luis Cazares (5/29/2014)
JOIN keywords on the right of the tables.
+1000 That one drives me nuts!!! (ok I know it is a short trip)
NOT a fan...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 30, 2014 at 7:38 am
It was good, the computer had three ships grouped close together, which helped my score. The other two where near by. The only thought I had was that...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 27, 2014 at 10:47 am
Sean Smith-776614 (5/27/2014)
Ah, same here. 🙂 I have 2008 R2 locally so I just run it off my machine. 🙂
I don't have anything loaded to my machine.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 27, 2014 at 10:37 am
Sean Smith-776614 (5/27/2014)
Which version of SQL Server are you running? 2005?
Yes, Our DEV server is still 2005, didn't want to run it on the prod server. 🙂
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 27, 2014 at 10:26 am
Also had to change the VALUES statements.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 27, 2014 at 9:12 am
Sorry for multiple post, keep getting error trying to post the whole thing.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 27, 2014 at 9:10 am
Doing the declare and set of the variables in one statement gets an error for me.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 27, 2014 at 9:09 am
Viewing 15 posts - 676 through 690 (of 844 total)