Viewing 15 posts - 24,631 through 24,645 (of 26,490 total)
No. It means we have been doing our own work, or helping others whose problems/issues/questions were easily answered. I need additional time to look at your issue which...
June 11, 2008 at 4:28 pm
Matt Miller (6/11/2008)
John Rowan (6/11/2008)
June 11, 2008 at 3:08 pm
Once a SQL 2000 databse has been restored or attached to SQL Server 2005, you can't go back to SQL Server 2000 with that database, unless you use DTS/SSIS to...
June 11, 2008 at 2:48 pm
You are going to need a third party product to recover the data from the transaction log.
Then, you will need to setup a backup plan for regularly scheduled full, possibly...
June 11, 2008 at 2:43 pm
anjan.ashok (6/11/2008)
Its just an example thats it.It looks like this...
An example of what? It isn't even a valid query. We'd like to help you, but you have to...
June 11, 2008 at 2:38 pm
Questions.
Is the database using the Full Recovery Model?
Do you have a current full backup from prior to this event?
If so, you can take a transaction log backup now, restore the...
June 11, 2008 at 1:47 pm
I'd write it more like this:
DELETE FROM
dbo.tbItem
FROM
dbo.tbItem I
INNER JOIN dbo.tbProductionOrder PO
...
June 11, 2008 at 1:42 pm
Sorry to say this, but this doesn't even appear to be a proprerly written query.
select * from test.samp_id,test.b_id,
case when (test.case_active='N' and sample.case_te_date is null)
then 'In Active' when (not tbl_test.case_te_date...
June 11, 2008 at 1:33 pm
Matt,
Here is a link to Wikipedia that may help jog your memory on thier use:
http://en.wikipedia.org/wiki/Fast_Fourier_transform
Can I personally think of a database application that would use it, not off hand, but...
June 11, 2008 at 10:35 am
Big request with no information to work with. For better help fast, read the following article:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
😎
June 11, 2008 at 10:26 am
Just so you know; I have found an algorithm that works, and based on my testing, will work no matter the setting of DATEFIRST.
(That is a hint, and goes with...
June 11, 2008 at 9:54 am
To paraphrase what someone else once said on this site, "The proof is in the code." Here is the code:
set nocount on;
create table #fun(id int identity(1,1) primary key clustered,...
June 11, 2008 at 8:04 am
One query is returning a constant, the other a value from a table.
Where is the simularity between the queries?
Give it up. Neither of us is going to change the...
June 10, 2008 at 10:30 pm
Not even similiar. Let me know when you decide to give up trying to convince me otherwise.
😎
June 10, 2008 at 9:30 pm
Now, you should post what you did to complete your process so that others can see it also. You never know, someone else may have a similiar problem that...
June 10, 2008 at 7:44 pm
Viewing 15 posts - 24,631 through 24,645 (of 26,490 total)