Search results for query: *

Yes, create a pass-through query with SQL similar to this: EXEC SPname parameters eg EXEC SPclosedcases '01/07/2002', '31/07/2005', -1 Hope this helps

Sorry, I've just noticed in Books Online: "Data Definition Language statements (such as CREATE, ALTER, or DROP statements) are not allowed against linked servers. " Back to the drawing board...

I am writing a stored proc on our financial data warehouse, during which I need to repopulate a table in a system server. Both servers are SQL Server 2000. My plan for this part was to: 1. populate a local temp table 2. TRUNCATE the live system table, "CDRSOS" 3. DROP INDEX on the live system...

I need to import an Excel 97 spreadsheet into SQL 2000. Most columns import correctly. However, one column which has a combination of text, numeric entries and NULLS refuses to import the numerics - they just show as NULL. I have set up the destination table to be "Varchar(30) NULL&quot...

Sorry, we've found what was wrong - the ODBC driver had the "Use Regional Settings" option selected. Deselecting it fixed the problem. Thanks

We have some Access 97 reporting databases which use pass-through queries to access some SQL Server 2000 databases. The databases have historically been accessed through Win 95 or 98. We have been upgrading some servers to Win 2000 which is when the problem started. We have come across a...

If you need zeros I would probably use the SQL CASE statement. It would be something like ( I can't check at the moment as I don't have SQL on this PC ) SELECT COUNT(CASE WHEN DATEPART("h",starttimeofcall)=0 THEN 1 END) AS AM12till1, COUNT(CASE WHEN...

Hi I work for a European firm with over 15 offices. Having effectively worked as separate businesses in the past, we are trying to standardise our software packages, one of which is Crystal Reports. In our various offices we have versions 6, 7, 8, 8.5 and 9 although the most used is 8. We have...