I posted this to microsoft.public.sqlserver.programming, but no one could answer my question. So I think it is a good place to re-post my question here. My question: I found that if you do not include any effective SQL statement between BEGIN/END block, SQL Server 2000 Query Analyzer will t...more >>

How to get data from cubes in analyses manager to MS access using for example ODBC ? Does existe any other posibilities to get data from cubes directly to the accees ? thanks Kris ...more >>

Hi I've not used SQL Server for a while, and I've forgotten how you hide all those system procedures (beginning with dt_) in Enterprise Manager. Could some kind person please refresh my memory? Thanks Captain Nemo ...more >>

Hi; I'm brand spanking new to sqlserver ( nice so far ). I need to make a simple data change across a list of tables. Basically replace an old date with a new date. However, the people I am doing it for want a program that produces logging of what it does. I thought I would write a ts...more >>

#temptable got order,fname and age. trying to find two high maxes per each order. query returns (1) but (2) is correct answer. supposedly, max(age2) < max(age1). **** select d.order,case d.t when 1 then s.fname else null end as fname, case d.t when 1 then s.age else null end as age1, case d....more >>

Hi, I would like to know if anyone out there really uses SQL Server 2000 (which edition?) to hold the data for a data warehouse? How much data does it handle efficiently? TIA Frank ...more >>

I have a shopping cart that will get full from time to time because customers click out of the site before they confirm their purchase, therefore leaving a full cart behind. I'd like to have a timestamp on this table, so that I can delete anything that I find is more than a day old. How can I...more >>

Is there anything I can put in a stored procedure so instead of proc falling over because of "String or binary data would be truncated" the offending records are just truncated? Thanks for any help! ...more >>

There's an SP that in effect returns a table -- it loops and executes statements like SELECT @field1, @Field2, @Field2 Can I capture its results in a table? I know that if it were a FUNCTION that returned a table, that would be simple: INSERT ResultsTable SELECT * FROM dbo.Function (@Param...more >>

How to dynamically and partially Update the webpage? The content of the part of the page is from the user's requerement and get data from the server side. The purpose is to speed up the page update. We have a page that most of content are static, only small part is changed per user's select and...more >>

I'm doing a data transfer from Access to SQL Server, I wish to keep the identity column (autonumber) values as all the data is already related. I tried the first table append query including the identity column, it worked. Was this fluke? Will it always work? I was under the impression that I wou...more >>

Hi all In a new installation, if the data directory is stipulated as d:\data, it installs all data in d:\data\MSSQL\data. I need to place the data in d:\mssql7\data to incorporate backsup from old data backusp Any ideas ? Cheers Ray ...more >>

Having decided not to use the undocumented checksum in SQL 7, we are now using SP_TABLE_VALIDATION to work out the checksum of a table. We have an issue in that we are calling it from a VB app and we get the message back stating how many rows were counted etc. but it also returns an error cod...more >>

I need to extract data from this table to find the lowest prices of each product as of today. The product will be listed/grouped by the name only, discarding the product code - I use SUBSTRING(ProductName, 1, CHARINDEX('(', ProductName)-2). I can get this result, but I had to use several view...more >>