Viewing 15 posts - 1,651 through 1,665 (of 5,504 total)
You might want to ask your question in a dedicated Oracle forum...
April 23, 2011 at 1:38 pm
... or even within one page:
Did you folks notice that the "Add to briefcase" button is now available for forum posts, too?
THANK YOU STEVE!!!
Makes SSC even more convenient to...
April 23, 2011 at 1:35 pm
GilaMonster (4/23/2011)
Jack Corbett (4/23/2011)
So now we have someone saying don't REORG indexes only REBUILD and you don't need to do statistics maintenance.http://www.sqlservercentral.com/Forums/Topic1094168-146-3.aspx
Want to swap? I'm having some amusement with someone...
April 23, 2011 at 1:15 pm
I think SSIS is "just" an alternative to some of the tools Jeff mentioned. Nothing more, but nothing less either.
There are two tasks I prefer using SSIS:
a) export to...
April 23, 2011 at 12:29 pm
First of all it seems like it's a "catch-all-query"[/url] type.
I'm confident this query will (almost) always end up using a table scan...
Furthermore, what do consider being the difference between parameter...
April 23, 2011 at 4:37 am
Would the following snippet do the trick?
-- Drop information into a temp table to...
April 23, 2011 at 4:05 am
@Phil: the way I read it is that the OP needs Excel to add the column names manually and (guessing starts here) will import it into SQL Server based on...
April 23, 2011 at 3:52 am
How about using
ROW_NUMBER() OVER(PARTITION BY homepage ORDER BY highest rank desc) as pos
and select the top 10 rows with pos=1 ORDER BY highest rank desc?
April 22, 2011 at 4:40 pm
Would you please be a little more specific what you're trying to do?
Do you have to import the data into SQL Server? Does the target table already exist?
What method do...
April 22, 2011 at 4:33 pm
As I mentioned earlier it looks like you try to partition by date.
So, let me ask again: why do you have a CHAR(20) column to store an 8 charachter date...
April 22, 2011 at 2:00 am
The description is kind of vague...
Is the column used to partition the table identical to the column used in your WHERE clause?
Based on what I see I'd guess the partitions...
April 21, 2011 at 9:49 am
To answer your question in a PM that you've...
heard that the usage of the column number is the perfect choice instead of using alias name or column name in...
April 21, 2011 at 2:16 am
Regarding the solution you added to your original query:
select ISNULL(a.eno,b.eno) as eno,a.no,b.no
from ep1 a full outer join ep2 b
on a.eno=b.eno
should return the expected output.
Another option would be a table holding...
April 21, 2011 at 1:26 am
GilaMonster (4/20/2011)
LutzM (4/20/2011)
April 20, 2011 at 3:33 pm
Viewing 15 posts - 1,651 through 1,665 (of 5,504 total)