Viewing 15 posts - 106 through 120 (of 160 total)
EdA ROC (9/27/2012)
Stop The Presses... My Thread has been hijacked. 🙂Would you please take this REFERENCES conversation to another thread?
Sorry about that. :blush: We don't need a new...
September 27, 2012 at 11:42 am
Jeff Moden (9/27/2012)
LightVader (9/27/2012)
CELKO (9/27/2012)
The only REFERENCES keyword I know is in creating foreign keys and since foreign keys can be NULL, I'm not sure how that would eliminate the...
September 27, 2012 at 11:03 am
CELKO (9/27/2012)
The only REFERENCES keyword I know is in creating foreign keys and since foreign keys can be NULL, I'm not sure how that would eliminate the LEFT OUTER JOIN....
September 27, 2012 at 10:50 am
CELKO (9/22/2012)
For example, when you say “LEFT OUTER JOIN Grade_File AS GF ON GF.grade_cd = S.grade_cd” probably should have been done with a REFERENCES in the DDL and not with...
September 24, 2012 at 8:47 am
We try to stick with stored procedures. All the logic is contained within the stored procedure, plus IMHO, it's much easier to edit the script in SSMS then in...
August 3, 2012 at 6:15 am
Arjen Krap (7/29/2012)
sqlnovice2001 (7/24/2012)
Thanks for the quick reply. As to the install question. Does it matter that SQL 2008 is already installed prior to installing SQL 2005? Any gotchas?
...
Beside this...
July 30, 2012 at 10:40 am
I read Wired and it's sequel Amped by Douglas E. Richards. Both were excellent although I enjoyed Wired a bit more. I tend to stick to sci fi...
July 19, 2012 at 5:57 am
bobt 46978 (6/15/2012)
A memory stick.It's been 5 years and I haven't seen the 'HR lady with a box' yet, but if I do, the memstick gets stashed away, first thing.
Make...
June 19, 2012 at 7:25 am
A few of my coworkers organize office parties a few times of year. We'll order in for Cinco de Mayo, decorate for halloween and Christmas. And then there's...
June 19, 2012 at 7:23 am
ronmoses (6/14/2012)
L' Eomot Inversé (6/14/2012)
June 14, 2012 at 6:40 am
On Report Server 2008, you can hide the parameter area. Take a look at the picture I attached. In the dark blue bar below the report parameters, there's...
June 14, 2012 at 6:33 am
michaeljharper (6/5/2012)
June 5, 2012 at 11:53 am
michaeljharper (6/5/2012)
ACinKC (6/5/2012)
June 5, 2012 at 9:38 am
Lynn Pettis (6/5/2012)
LightVader (6/5/2012)
Michael Valentine Jones (5/24/2012)
Brevity and obscurity
declare @ char(3)
set @=0
while @<100
begin
set @=@+1
case when @%15=0 then 'FizzBuzz'
when @%3=0 then 'Fizz'
when @%5=0 then 'Buzz'
else @ end
end
I didn't realize that you...
June 5, 2012 at 6:59 am
I'm in US. I went right from my Bachelor's degree to the working environment. To be honest, I wasn't entirely sure what kind of Master's degree I wanted....
June 5, 2012 at 6:31 am
Viewing 15 posts - 106 through 120 (of 160 total)