No problem. The key to this one is the derived table. If you're not real familiar with derived tables, I suggest searching SSC and reading up on them. There's also...

No problem. The key to this one is the derived table. If you're not real familiar with derived tables, I suggest searching SSC and reading up on them....

Here you go......

DECLARE @ItemTypes TABLE (ItemTypeID int, ItemTypeName varchar(10))

INSERT INTO @ItemTypes

SELECT 1, 'One' UNION ALL

SELECT 2, 'Two' UNION ALL

SELECT 3, 'Three'

DECLARE @sales TABLE (ItemTypeID int, SaleID int IDENTITY(1,1))

INSERT INTO @sales...

I'm not real clear on what you are asking for here. It sounds to me like you want to run a nested stored procedure call to the second stored...

This approach should work. Keep in mind that from your description, I have no idea what your table DDL looks like. This is a wild stab in the...

This should work for you.

DECLARE @TableVar TABLE (MyDate datetime, Col2 varchar(10))

INSERT INTO @TableVar

SELECT '2008-02-01 10:00AM','ASX1' UNION ALL

SELECT '2008-02-01 10:30AM','ASX1' UNION ALL

SELECT '2008-02-02 10:00AM','ASX1' UNION ALL

SELECT '2008-02-02 10:30AM','ASX1' UNION ALL

SELECT...

Limiting the subqueries on event_id won't help. The problem with the subqueries is that they return results for all people_code_ids. The subqueries need to be correlated back to...

Of course, if you want to do it in SQL Server 2000, there's still a way. This may not be the cleanest way to get there, but it works...

You are getting that error because the sub queries in your SELECT are returning more than one value. SQL Server will not allow obviously not allow this for good...

Chad's solution will only work on SQL Server 2005 and this appears to be a 2000 forum. Chris, which versio of SQL Server are you using?

Also, the...

TJK,

You may already know this, but I think it needs said anyway. This is one of the many reasons why you don't stored datetime information in varchar columns.

Please don't cross post.

Continue this thread here:

http://www.sqlservercentral.com/Forums/Topic452328-338-1.aspx

SELECT LEFT(REPLACE(REPLACE(REPLACE(REPLACE(CONVERT(varchar,GETDATE(), 121),'-',''),':',''),'.',''),' ',''),16)

I think it would help if we had a little better explanation of why you are doing what you are doing? What is the end purpose that you are...

Multiply by -1.