|
|
You're in the
sql server programming
group:Need to Improve
sql server programming:
A change in management has forced me to re-interview for my own position, and now I am in a hurry to develop the skills that I had exaggerated on my Job Description Form 22b1993-a. I would like a *free* set of online Queries, along with explanations. A quiz-type environment would be acceptable to me. I am a Senior SQL programmer for that Huge Retail Chain that basically rules the world with a smiley face. It is imperative that I learn my job quickly. Pleae help.
I am not sure if this is a troll or a sincere request. Why? As a sincere
request, it shows immense lack of forethought. 1. Asking for examples of advanced queries can be done without directly mentioning your situation. 2. It is rather idiotic to openly admit you are lacking some skills necessary for your job in an open forum where your boss, or competitor, can search. They cannot, of course, prove it is you, but they can make sure you are hammered on anything you lied (exaggerated) about on your 22b1993-a. As far as questions, here are a couple of sites our DBAs have used to put together a technical interview: http://vyaskn.tripod.com/iq.htm http://www.techinterviews.com/?p=161 sswug.org is also a great spot for technical information. --- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA *************************** Think Outside the Box! *************************** [quoted text, click to view] "TargetBleigh" wrote:
> I need to improve my supposedly considerable SQL query skills. > A change in management has forced me to re-interview for my own position, > and now I am in a hurry to develop the skills that I had exaggerated on my > Job Description Form 22b1993-a. > > I would like a *free* set of online Queries, along with explanations. > A quiz-type environment would be acceptable to me. > > I am a Senior SQL programmer for that Huge Retail Chain that basically rules > the world with a smiley face. > > It is imperative that I learn my job quickly. > Pleae help. > > > > > >
You work for Walmart. Don't worry about it. The pay can't be that
great. Incompetence is always rewarded. You can't be any dumber than the greeters and stockers. [quoted text, click to view] TargetBleigh wrote:
> I need to improve my supposedly considerable SQL query skills. > A change in management has forced me to re-interview for my own position, > and now I am in a hurry to develop the skills that I had exaggerated on my > Job Description Form 22b1993-a. > > I would like a *free* set of online Queries, along with explanations. > A quiz-type environment would be acceptable to me. > > I am a Senior SQL programmer for that Huge Retail Chain that basically rules > the world with a smiley face. > > It is imperative that I learn my job quickly. > Pleae help.
You work for Walmart. Don't worry about it. The pay can't be that
great. Incompetence is always rewarded. You can't be any dumber than the greeters and stockers. [quoted text, click to view] TargetBleigh wrote:
> I need to improve my supposedly considerable SQL query skills. > A change in management has forced me to re-interview for my own position, > and now I am in a hurry to develop the skills that I had exaggerated on my > Job Description Form 22b1993-a. > > I would like a *free* set of online Queries, along with explanations. > A quiz-type environment would be acceptable to me. > > I am a Senior SQL programmer for that Huge Retail Chain that basically rules > the world with a smiley face. > > It is imperative that I learn my job quickly. > Pleae help.
I advise a career change. Try politics. You won't have to bother to
actually study or learn anything and your mendacity could be regarded as an asset. -- David Portas SQL Server MVP --
Just try the following book:
Microsoft® SQL Server™ 2000 Programming Step by Step http://www.microsoft.com/MSPress/books/4713.asp Hope this helps. [quoted text, click to view] "TargetBleigh" wrote:
> I need to improve my supposedly considerable SQL query skills. > A change in management has forced me to re-interview for my own position, > and now I am in a hurry to develop the skills that I had exaggerated on my > Job Description Form 22b1993-a. > > I would like a *free* set of online Queries, along with explanations. > A quiz-type environment would be acceptable to me. > > I am a Senior SQL programmer for that Huge Retail Chain that basically rules > the world with a smiley face. > > It is imperative that I learn my job quickly. > Pleae help. > > > > > >
[quoted text, click to view]
TargetBleigh wrote: Wait a minute. You said you were already fired.> I need to improve my supposedly considerable SQL query skills. > A change in management has forced me to re-interview for my own > position, and now I am in a hurry to develop the skills that I had > exaggerated on my Job Description Form 22b1993-a. > http://groups-beta.google.com/group/microsoft.public.sqlserver.programming/browse_frm/thread/8b3f4da5c27945ad/586d8495444f1f2a?q=&rnum=1#586d8495444f1f2a You actually tricked somebody into hiring you??? That is impressive. Oh, wait ... given the degree of dishonesty to which you just admitted, maybe the truth is that you were never really fired? And that was simply a ploy to gain sympathy ... ? Bob Barrows -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup.
He's baaaack.
I thought I recognized that name from somewhere. He left a lasting impression on me... not neccessarily the good kind... and it's not getting any better. [quoted text, click to view] "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message news:uyRmLJgNFHA.2736@tk2msftngp13.phx.gbl... > TargetBleigh wrote: >> I need to improve my supposedly considerable SQL query skills. >> A change in management has forced me to re-interview for my own >> position, and now I am in a hurry to develop the skills that I had >> exaggerated on my Job Description Form 22b1993-a. >> > Wait a minute. You said you were already fired. > http://groups-beta.google.com/group/microsoft.public.sqlserver.programming/browse_frm/thread/8b3f4da5c27945ad/586d8495444f1f2a?q=&rnum=1#586d8495444f1f2a > > You actually tricked somebody into hiring you??? That is impressive. > > Oh, wait ... given the degree of dishonesty to which you just admitted, > maybe the truth is that you were never really fired? And that was simply a > ploy to gain sympathy ... ? > > Bob Barrows > > -- > Microsoft MVP -- ASP/ASP.NET > Please reply to the newsgroup. The email account listed in my From > header is my spam trap, so I don't check it very often. You will get a > quicker response by posting to the newsgroup. > >
Ha! I do know the difference between a set of online questions (like I asked
for) and a book! Your advice is RE-jected.
And that, ladies and gentleman, is why the price on the shelf ***never***
matches the price at the register at Wal-Mart. Here's an example previously posted by Aaron: CREATE TABLE dbo.UnemploymentChecks ( SSN CHAR(9), dt SMALLDATETIME, Amount DECIMAL(6,2), PRIMARY KEY (SSN, dt) ) GO INSERT dbo.UnemploymentChecks SELECT '036555555', '20040101', 600.00 UNION SELECT '036555555', '20040201', 400.00 UNION SELECT '036555555', '20040801', 500.00 UNION SELECT '036555555', '20041201', 200.00 UNION SELECT '036555666', '20040201', 600.00 UNION SELECT '036555666', '20040801', 500.00 UNION SELECT '036555666', '20041201', 700.00 GO SELECT uc.SSN, uc.Amount, MinAmountIsLastAmount = CASE uc.Amount WHEN sub.Amount THEN 'Yes' ELSE 'No' END FROM dbo.UnemploymentChecks uc INNER JOIN ( SELECT SSN, dt = MAX(dt), Amount = MIN(Amount) FROM dbo.UnemploymentChecks GROUP BY SSN ) sub ON uc.SSN = sub.SSN AND uc.dt = sub.dt GO DROP TABLE dbo.UnemploymentChecks GO Any questions? [quoted text, click to view] "TargetBleigh" <ddsd*sadf.com> wrote in message news:nsWdnZfKiabDAdbfRVn-sw@comcast.com... >I need to improve my supposedly considerable SQL query skills. > A change in management has forced me to re-interview for my own position, > and now I am in a hurry to develop the skills that I had exaggerated on my > Job Description Form 22b1993-a. > > I would like a *free* set of online Queries, along with explanations. > A quiz-type environment would be acceptable to me. > > I am a Senior SQL programmer for that Huge Retail Chain that basically > rules the world with a smiley face. > > It is imperative that I learn my job quickly. > Pleae help. > > > > > >
Don't see what you're looking for? Try a search.
|
January 2003
March 2003
April 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
April 2008
| home · blog · groups | Questions? Comments? Contact the dn |