Nope. I'm not sure. This is the quote from http://www.4guysfromrolla.com/webtech/022801-1.shtml that lead me to the conclusion:

(If you are wanting to create Excel spreadsheets and graphs without requiring Excel's...

I'd never use parameters.refresh as a production method. I'm only trying to populate the parameters table mentioned in my second post. I need to get the values from...

Thanks guys, but I think I'll end up just using parameters.refresh in ADO. It's not as slick as doing it all in SQL, but it works and there's one...

UGH! I just typed an explination but lost it because I wasn't logged in.

We have a report application that builds itself based on tables.

Report

Parameters

Validations

ParameterValidations

Report - stored procedure...

The office web control, I believe, will instanciate an instance of Excel on the web server to create the object. That's not only resource intensive, but slow as well.

Let me...

I hope I'm not doing your homework for you Troy. This should get you to the first day of the week:

@@DateFirst tells you what sql server is set to use...

or try these:

ALTER FUNCTION dbo.FirstDay (@DateValue smalldateTime)

RETURNS smallDateTime

AS

BEGIN

select @DateValue = dateadd(dd, -(day(@datevalue)-1), @datevalue)

return @DateValue

END

CREATE FUNCTION dbo.LastDay

(

@DateValue SmallDateTime

)

RETURNS SmallDateTime

AS

BEGIN

select...

Here's a really slick control that'll do the trick and more!

http://www.softartisans.com/softartisans/excelwriter.html

If you're using the results from these two queries in ADO, use NextRecordset to loop through one then the second result set.

declare @sql nvarchar(1000)

declare @name varchar(10)

set @name = 'name'

select @sql = 'if exists(select * from syscolumns where name = '''+ @name + ''') begin select 1 end else begin select 0...

I was more concerned with IO performance when bringing in large (40 meg) files. This was my DBA's take:

<snip>

SQL server boxes should only contain database files, database log files,...

New question along the same lines... I'm still importing a text file. Now the debate is over where the file should be during the import. My instincts tell...

If users are going to update data in your table with Access, and you go with a bit field, it is important to set a default value on the field...

quote:

---

You can let users other than SA have access to xp_cmdshell. Not a good idea, but it is an option. Bulk insert...

I run bcp into a generic table:

@sql = 'create table tempTable + @@spid

(data varchar(1000))'

sp_executesql @sql

The whole text file gets dumped into the data field. How can I append...