Viewing 15 posts - 31,936 through 31,950 (of 59,102 total)
First, please see the first link in my signature line below before your next post. Thanks.
I'd also recommend that you avoid reserved words for column names.
Here's the code for...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 19, 2011 at 11:48 pm
Dev (11/19/2011)
SSIS would be a very simple setup:
And this is why I don't like it. It stops the learning curve for DB Developer.
The ONLY argument in favour of...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 19, 2011 at 10:12 pm
Clarence R. Assey (11/19/2011)
If table has primary/unique key and SELECT has not ORDER BY clause thenthe result will be sorted by key. Otherwise no guarantee of sort order.
Although the optimizer...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 19, 2011 at 10:06 pm
First, nicely done there Cold Coffee. I came up with an almost identical solution and saw yours when I was getting ready to post it. Your solution uses...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 19, 2011 at 9:54 pm
Never mind... I see it now.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 19, 2011 at 6:56 pm
texpic (11/18/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 19, 2011 at 6:54 pm
Very cool feedback. Thanks, David.
As a side bar, if you meant for both dates in your example to be inclusive, you'll need to add "1" to the DATEDIFF.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 19, 2011 at 1:03 pm
GilaMonster (11/19/2011)
SSIS would be a very simple setup:
And this is why I don't like it. It stops the learning curve...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 19, 2011 at 12:54 pm
No, the output of a spectrometer isn't what most people would consider to be "OLTP". It's just a wad of data much like call records or any other "wide...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 19, 2011 at 12:28 pm
Dev (11/19/2011)
Pros: the sample reading is held together in the database.
Itβs possible with Wide Tables.
A wide table...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 19, 2011 at 8:16 am
There's likely going to be a huge difference between consultants and FTEs and the Poll makes no differentiation.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 18, 2011 at 7:22 pm
Dev (11/16/2011)
It's not possible.
Ladies and Gentlemen, please place your bets. π
--Jeff Moden
Change is inevitable... Change for the better is not.
November 18, 2011 at 7:08 pm
John Mitchell-245523 (11/17/2011)
The only thing I can think of is that a trigger on table A is deleting some of the rows, or modifying what is copied to table A.John
Lookup...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 18, 2011 at 7:07 pm
sami.sqldba (11/17/2011)
There is no way that records are not getting inserted into other table.
Read my post immediately above this one. You'll soon change your mind. π
--Jeff Moden
Change is inevitable... Change for the better is not.
November 18, 2011 at 7:06 pm
Walton (11/18/2011)
It was an interview question. And no other information was provided.
I'm not going to give you the answer but I will tell you where to look for the answer....
--Jeff Moden
Change is inevitable... Change for the better is not.
November 18, 2011 at 7:05 pm
Viewing 15 posts - 31,936 through 31,950 (of 59,102 total)