I have the following table:
create table test (
id int identity,
base sysname not null,
login varchar(255), -- actually it is "uid int FK refs staff(uid)"
date datetime not null,
value int not null
)
How select rows from this table having single row per login and
1. where base=<constant>
2. date=MAX(date)
Notice that...
crusoe
Last Activity: Dec 10 '07, 11:22 AM
Joined: Apr 4 '07
Location: Ivanovo, Russia
-
How to reduce the table
-
Reports based on queries
I have some queries which return rowsets. I want to make XHTML tables from these sets in a single report file.
My preliminary solution is a procedure, which returns varchar(8000) containing XHTML built row by row, using a cursor for each query. BTW, there are two cursors one nested in the other. The outer cursor builds a summary table, while the inner cursor builds "More Info..." table for each row. However the report now... -
Resolved.
When I run a script by hands I do it as domain\user. When SQL Agent does run the script it does it as nobody.
After my server computer was granted full access to the network share, everything went fine. -
WinCMD job
I'd like to copy a backup file to a network share.
I have two computers inside the NT Domain:- sqlsrv - where backups are created and sql server runs
- backup - where I want to have a copy of files
At backup I have a share 'My' to which I (domain\user) have an access. Now If I log in to the sqlsrv (as domain\user) and in cmd execute a command: 'copy c:\file.dat \\backup\My' the file.dat appears at \\backup\My as I would... -
clone MSSQL server 2000
I'm new to MSSQL Server, and I can't figure out how can i clone a server to the other computer in network. The only solution I can see - is per database copying. But it does fail for some reason. Probably I should start with system databases like master.
Info: Both PCs are W2K server, both have Enterprise SQL Server 2000 SP4 installed.
No activity results to display
Leave a comment: