Looks like your already on the right track.

Don't think theres's a way.

http://www.sqlteam.com/item.asp?ItemID=744

Perhaps write an app in an easy to use language like vb.

Whats not working?

Without sample data from the harvardclub.dbo.fiscalMonths table, its hard to say what the issue is.

I get these values for the parameters.

thismonth   thisYear    FiscalYear  TestDate               

----------- ----------- ----------- ------------------------

7          ...

Opendatasource can only be used for querying another server.

you can try to use dynamic sql, but there are always challenges doing so.

http://www.sommarskog.se/dynamic_sql.html

But using a stored procedure to create another...

sp_executesql requires that the sql statement to be executed is of datatype 'ntext/nchar/nvarchar'

Changes in Bold the Capitol 'N' tells sql to convert string to binary, but the conversion is implicit...

update clients

set age = datediff(yy, DateOfBirthColumn,getdate())

Instead of persisting the age in the db, why dont you just use the calculation in the presentation layer?

anyways that will work

to an external application a view looks and acts like a table.

It can be queried against just like a table.

You should be able to do Selects from it in the...

Well its used to display a list, but the group definition is causing only 1 row to show.

Since its a one time job.

The absolute easiest way is to define a temp table with the fields being char and the size requred by the client.

Then insert your records...

you gotta create a grouping for each name.

Drop a listbox on your form, right click properties General tab, Edit Details group, and create a group. Not sure what constitutes a...

my gut reaction would be to make sure there are no open transactions.

you may have long running transactions also. (Transactions are taking way too long to complete)

I don't know that...

Post the code you used to get your data set.

if you did your data set correctly you can just do a grouping in your table, or matrix

and it will be...

and whats with the '' + ,

Is this part of a dynamic sql select?

executing this

SELECT *

FROM @a

WHERE CTimeStamp BETWEEN '' + @DateFrom + '' AND '' + @DateTo +...

Anything for my peeps

Between will return different rows than < and >

the between operator is actually >= and <=

I find between problematic, especially when querying for a day. Your example

Set @dateFrom...

Can you please post some example Create table statements, Some sample data, your code, and what you want the results to look like.

In looking at your question, It does not appear...