Viewing 15 posts - 2,611 through 2,625 (of 3,221 total)
Might I suggest you start / extend your education abut SQL Server 2005 by using the Search box at the top of this page and search on "Security"....
February 27, 2009 at 2:41 pm
I would recommend that your read this article by Jeff Moden
http://www.sqlservercentral.com/articles/T-SQL/63003/
contains enough sample code to do what you want to do
February 27, 2009 at 2:30 pm
February 27, 2009 at 11:26 am
Mike AAAUUUUUUUGGH for my first recomendatin, just one more wild possibility - set the cells so that text wraps. Note text with text containing a tab...
February 27, 2009 at 10:30 am
Mike
Not sure if this is what you are looking for, but try this in your next Excel report.
Manually
Select adjacent columns by clicking on the column headers(I selected 4)
On the main...
February 27, 2009 at 9:02 am
If you run just the SELECT statment
select distinct cod_artigo,
sum(qtd) as qtd,
sum(tpvp) as tpvp
from Daily_Sales
where (Cod_Forn=@Cod_Forn)
and (Cod_Familia=@Cod_Familia)
group by cod_artigo
How long does this take?
Can you post your table structure, indexes, number...
February 26, 2009 at 12:55 pm
I agree with Gsquared's suggestion but if you do not desire to use DTS Read about OPENROWSET in Books On Line
The following example can not be used to write...
February 26, 2009 at 10:04 am
Learning_Phase
My fault, please accept my apologies
forgot to tell you that
DefaultDir=F:\;'',
in place of the F:\; should be the path to your .csv for example
DefaultDir=C:\Test Data\myfile.csv;' ,
and that...
February 25, 2009 at 5:22 pm
Roy Ernest
With all due respect, I disagree. In SSC, yea you are right or maybe right. But not in your own DB at your work place. If you want to...
February 25, 2009 at 2:32 pm
Learning_Phase
The answer is Yes there is. The sample code below will do just that.
Each column in the table created will be VARCHAR(250) with the column names...
February 24, 2009 at 3:56 pm
Greg please do not take this as anything other than some friendly advice. Un install the company version. Go to AMAZON.COM and for less than $50 USD, purchase...
February 24, 2009 at 3:36 pm
Greg ... I have installed the Developer Edition on a desktop using Windows XP pro ... Be sure to check ALL the requirements, for example you needl dot net...
February 24, 2009 at 10:11 am
Yulichka
What is the objective of the Update T-SQL statement you are asking for assistance in creating?
What was the database setting for ANSI_PADDING when these particular columns were...
February 24, 2009 at 10:05 am
dphillips
On the history of questions, I think the potential frequency of duplication is very low, and would have no impact and user experience here... so I guess I will quit...
February 23, 2009 at 11:56 am
dphillips
Obviously there is not much QA vetting by an alternate person before the questions are deployed.
As to the question writing challenge: is there a way to know the potential question...
February 23, 2009 at 10:19 am
Viewing 15 posts - 2,611 through 2,625 (of 3,221 total)