Viewing 15 posts - 25,321 through 25,335 (of 26,487 total)
There are a lot of good books out there. I'd hit Borders to start with and just start looking at them. I'll put together a list of books...
January 16, 2008 at 1:00 pm
You may also want to read this article: http://www.sqlservercentral.com/articles/Best+Practices/61537/
It would help if you posted your code, provided the DDL for the tables involved, and some sample data.
😎
January 16, 2008 at 12:56 pm
Also, it would help if you could provide the DDL for the tables and some sample data. This would allow us to test what we come up with.
This article...
January 16, 2008 at 12:43 pm
I think I may see the problem. Here is the code as I have reformatted it;
SELECT TOP 100 PERCENT
dbo.CheckingAccountTransaction.CheckingAccountTransactionId,
dbo.CheckingAccountTransaction.CheckingAccountId,
...
January 16, 2008 at 12:39 pm
I think there is a problem with your code. It looks like in the posted code you may be missing a '(' in the first subquery in your select...
January 16, 2008 at 10:35 am
I didn't even catch the misspelling of Full Text Indexes until I started reading these posts.
😎
January 10, 2008 at 10:06 am
I would also recommend buying a book on SSIS. Wroks has a very good book that would be helpful: Profession SQL Server Integration Services 2005 (I hope I got...
January 10, 2008 at 7:56 am
Try this:
create table #TestTable (
ItemID int,
StatusDate datetime,
Status varchar(6),
Description varchar(25)
)
insert into #TestTable (
...
January 9, 2008 at 12:38 pm
He's Sergiy. Enough said about that.
January 9, 2008 at 8:27 am
Wrong because I use a correlated subquery or wrong because I didn't take into account you may have more than one order for a given day by a customer (I...
January 8, 2008 at 7:38 pm
Sergiy,
I really don't care what you have to have to say. I am fully aware of all the things you mentioned, I worked for 11 years with a company...
January 8, 2008 at 4:50 pm
To do it where OrderID may not be the max based on orderdate, this would work. It does not take into account if two orders are entered on the...
January 8, 2008 at 4:40 pm
Code suggested was based on AdventureWorks database. OrderID is an identity column, therefore (and I checked) the maximum OrderID is associated with the latest order for each customer.
I looked...
January 8, 2008 at 4:24 pm
First, are you applying both transaction log backups after you restore the full backup? Second, if you are restoring to the point in time of the second transaction log...
January 8, 2008 at 4:00 pm
How about this:
select
CustomerID,
max(SalesOrderID)
from
Sales.SalesOrderHeader
group by
CustomerID
order by
CustomerID
😎
January 8, 2008 at 3:31 pm
Viewing 15 posts - 25,321 through 25,335 (of 26,487 total)