Based on what I have read in BOL the behaviour you are seeing is by design. Not working for Microsoft or the SSIS team, I can't give you any...

I'm confused. I ran a query very similar to this one, Select Count(*) From Tbltracking where Year(DateStamp) = 2009, against a table in one of my databases and it...

Looks easy. So, what have you tried so far to solve this problem?

Direct from SQL Server 2005 BOL:

Note: In addition to the specified percentage, the Percentage Sampling transformation uses an algorithm to determine whether a row should be included in the...

kabaari (12/3/2009)

---

USE [productDetails]

GO

/****** Object: Table [dbo].[tbl_Assembly_Holds] Script Date: 12/03/2009 09:21:22 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tbl_Assembly_Holds](

[TagNumber] [float] NOT NULL,

[WorkOrder] [nvarchar](7) NOT NULL,

[WOUnit] [nvarchar](2) NOT NULL,

[WOYear]...

Okay, $50.00 for a book or $50.00 for Developer Edition? If, after 3 to 6 months you decide it isn't for you, then what? You're still out the...

Happened to me as well. Please test your scripts before posting them. We are volunteers and have our own work to do instead of testing and correcting your...

Sounds like a dynamic pivot may be required here. Please chack out the article references in my signature block below regarding Cross Tabs and Pivots.

Personally, if your serious about learning SQL Server, the $50.00 investment in the Developer Edition is well worth it. Plus, you don't have to worry about it expiring on...

May not be exactly what you are looking for but it works:

declare @time1 int;

set @time1 = 13715;

select stuff(stuff(right('000000' + cast(@time1 as varchar), 6),5,0,':'),3,0,':')

You should also note that the AVG value...

I'd skip using the Evaluation Edition of SQL Server, instead invest a little money in the Developer Edition as it only costs approximately $50.00 USD and gives you all the...

Glad to see that you were able to correct the problem.

Not only that, looking at the code Lowell is writing for you, there isn't enough info (tables or sample data) in your previous post to even work with as it...

Sorry, but I tried using the code you provided to setup a test environment and it is failing. You provided a foreign key reference that apparently doesn't apply, for...

I have aborted a transaction in the past that had been running for over an hour, and it took longer to rollback, so yes, it is possible that had you...