Viewing 15 posts - 3,031 through 3,045 (of 3,232 total)
I don't believe that SQL Server can handle what you are asking for. You would have to write that into your application. I've worked in shops where un-authorized changes to...
February 9, 2006 at 11:07 am
It may help to get your question answered if you post the entire query. Table DDL and sample data would also be helpful.
February 2, 2006 at 2:10 pm
I think that your table DDL and sample data would be helpful here.
February 2, 2006 at 2:07 pm
INSERT INTO OrderReceived
(OrderNumber,
DateReceived)
SELECT OrderNumber, min(DateReceived) FROM OrderDetail
GROUP BY OrderNumber
February 2, 2006 at 1:05 pm
If I'm understanding you correctly, you want to update the OrderReceived table with the earliest OrderNumber,DateReceived from the OrderDetail table.
Try this:
INSERT INTO OrderReceived (OrderNumber , DateReceived) SELECT TOP 1 OrderNumber, DateReceived FROM...
February 2, 2006 at 12:41 pm
On top of what Jo is saying, not only will verifying your backups tell you if you have corrupt backup files, it will also help identify media problems.
January 30, 2006 at 11:51 am
I can't speak much for SQL Server 2005, but if you do that in 2000, you're toast. Your files are gone forever, with the exception of taking your harddrive into...
January 26, 2006 at 2:22 pm
Can't you define a transaction through your application and call all 3 stored procedures from within that one transaction? I don't have alot of experience from the application side of...
January 26, 2006 at 1:14 pm
Whichever method you choose, you cannot be logged into the database that you are trying to set to single user mode. I said use master, not necessarily because you have...
January 25, 2006 at 9:26 am
You have to make sure that there are not any users in the DB first. If there are, you need to kick them out or run a script to do...
January 24, 2006 at 12:12 pm
I would suggest verifying the permissions by performing a manual copy using you SQL user. Log into your SQL box as the user in question, go to start>>run and type...
January 24, 2006 at 12:00 pm
Has your MyCompany\SQLServer user been granted full control over the target folder? Has the target folder been set up as a share?
January 24, 2006 at 11:46 am
You 'da man Jeff. That is an awesome post. I have been attempting to get some of our developers to understand the importance of writting set based code over cursors...
January 24, 2006 at 10:25 am
UPDATE updatetble1 SET updatecol1 = sourcecol2 FROM updatetble1 JOIN sourcetbl2 ON updatetble1.rowid = sourcetbl2.rowid
January 23, 2006 at 11:59 am
Viewing 15 posts - 3,031 through 3,045 (of 3,232 total)