Both work for me, but then AdventureWorks database on my development server is using a case insensitive collation. It appears that your install of AdventureWorks is using a case...

Are you asking this because you are preparing to interview people for an SSRS position or to prepare for an interview for an SSRS position?

??????? :blink: ????????

Care to share your solution; and I mean the code, not just what you did?

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...

Nothing to do with the problem at hand, however, I would change master.dbo.sysdatabases to sys.databases for the following reason from SQL Server 2008 BOL:

Important: This SQL Server 2000 system...