Viewing 15 posts - 6,211 through 6,225 (of 7,484 total)
Craig Farrell (2/8/2011)
*sighs* I've failed sainthood. I leave this gentleman in your hands, he can't even debate well, and my patience is stretching to the unprofessional realms.http://www.sqlservercentral.com/Forums/Topic1059167-145-1.aspx
I've joined in...
February 8, 2011 at 7:22 pm
nadabadan (2/8/2011)
The algorithm I was referring to is the simple algorithm every computer science student has to solve. Given a set, finding the max or min value.
The algorithm which...
February 8, 2011 at 7:11 pm
mister.magoo (2/8/2011)
Tom.Thomson (2/8/2011)
February 8, 2011 at 6:49 pm
nadabadan (2/8/2011)
February 8, 2011 at 5:48 pm
jcrawf02 (2/8/2011)
Tom Brown (2/8/2011)
Ivan the bost of us gits our wucking mords fuddled now ind than.'Twas brillig, and the slithey toves did gire and gimble in the wabe...
Which naturally...
February 8, 2011 at 4:18 pm
crookj (2/8/2011)
Tom.Thomson (2/8/2011)
CirquedeSQLeil (2/8/2011)
crookj (2/8/2011)
WOTD - DynamicJoe
Cursor
Dynamic Cursor? Usually when I see one of those I curse the person who wrote it. 😉
Does that make me a Dynamic...
February 8, 2011 at 2:24 pm
Nice interesting question, thanks.
Maybe the explanation could have mentioned the limitations: no interactive commands, behaviour of a query in SSMS may be different that for the same query in SQLCMD...
February 8, 2011 at 2:20 pm
CirquedeSQLeil (2/8/2011)
crookj (2/8/2011)
WOTD - DynamicJoe
Cursor
Dynamic Cursor? Usually when I see one of those I curse the person who wrote it. 😉
Does that make me a Dynamic Cursor Curser?...
February 8, 2011 at 1:59 pm
crookj (2/7/2011)
At our office we are discussing our favorite movie of all times. I stated that it was the Lord of the Rings. They said which...
February 7, 2011 at 10:16 am
Jason Coleman (2/7/2011)
That needs the row_number over (partition, order) feature, and I don't know if MySQL supports it.
Unfortunately it doesn't. This is really starting to get me stuck....Another option...
February 7, 2011 at 6:16 am
There seem to be a number of different things happening here.
1) The cust field may not be matched (the code you posted doesn't address this, although the issue was mentioned...
February 7, 2011 at 5:15 am
Nice question, but very easy indeed for those of us who have been moving databases from server to server for more than a decade.
February 7, 2011 at 2:36 am
I think that the answer given as correct is correct only in the case where there is no existing checkpoint file (eg when the previous run of the package completed...
February 6, 2011 at 1:32 pm
Looks like one of those questions where there's more than one right answer.
Here's what MS has to say:
SMO is the primary tool for developing database management applications using .NET Framework....
February 6, 2011 at 12:04 pm
In select t.department,a.account_id from
pt_time_project_tasks t inner join pt_time_projects a
on t.time_bill_id = a.time_bill_id
if
a.account_id <> '1562E82F-6852-DF11-A29C-00155D1E165E' and t.department = 'S_Org'
Begin
the table aliases a and t are only defined in the select statement...
February 5, 2011 at 10:31 am
Viewing 15 posts - 6,211 through 6,225 (of 7,484 total)