If there are 20 days that they did not logout, you need all of those 20 days? and u need it for all employees?

Or u need those days that the...

This?

DECLARE @TableA TABLE

(

EmployeeIDINT

,EmployeeLoginDateTimeDATETIME

,JobFunction VARCHAR(25)

)

INSERT @TableA

SELECT 123,'2012-02-01 01:00:24','Coding'

UNION ALL...

Take 2! 😀

; with cte as

(

SELECT

[sort]

,[InventoryItemId]

,[WebOptionName]

,[WebCategoryId]

,[WebSubCategoryId]

,AnchorRN = ( ROW_NUMBER() OVER ( PARTITION BY T.WebCategoryId ORDER BY T.WebCategoryId , T.WebSubCategoryId ,...

Yes sure ! ( A + B )2 = A2 + B2 + 2AB! 😀

On the other hand, convert to time = what?? time can be specified in...

Thanks for setting up the data

Here is my 2-cents 🙂

; WITH CTE AS

(

SELECT

[sort]

,[InventoryItemId]

,[WebOptionName]

,[WebCategoryId]

,[WebSubCategoryId]

,AnchorRN = ( ROW_NUMBER() OVER ( PARTITION BY T.WebCategoryId...

Sure. But help us first!

There is menu card in that hotel! I want you to buy me a lunch from that menu card! Can you?

How about this?

Sample data

DECLARE @Table TABLE ( DatetimeasVC VARCHAR(30) );

INSERT @Table

SELECT '10/28/2011 11:47:55.686455 AM'

UNION ALL

SELECT '9/28/2011 11:47:55.123455 AM'

UNION ALL

SELECT '11/12/2011 11:47:55.789455 PM'

UNION ALL

SELECT '10/9/2011 11:47:55.9996 AM'

UNION ALL

SELECT '1/26/2011 11:47:55.3456 PM'

UNION...

Lynn Pettis (3/14/2012)

---

Or, if all things being equal:

DECLARE @DatetimeasVC VARCHAR(30);

set @DatetimeasVC = '10/28/2011 11:47:55.686455 AM';

select convert(datetime,

substring(@DatetimeasVC, 7, 4) + substring(@DatetimeasVC, 1, 2) +...

in the link i posted for DATETIME and DATETIME2, look at the Element Range explanation. That will tel u why ur string is not getting converted. Basically u had more...

That...

No problem, Gian!

Gianluca Sartori (3/14/2012)

---

This should do the trick:

SELECT *

FROM (

SELECT PartId,

value,

attribute = attribute + CAST( ROW_NUMBER() OVER(PARTITION BY PartId, attribute ORDER BY PartId, attribute) AS varchar(10))

FROM (

SELECT PartID,

value =...

This?

DECLARE @DatetimeasVC VARCHAR(30) = '10/28/2011 11:47:55.686455 AM'

SELECT CAST ( @DatetimeasVC AS DATETIME2) UsingCAST ,

CONVERT(DATETIME2, @DatetimeasVC) UsingConvert

You yourself said u want to convert, why...

FROM @TempComments p1 ) D ( R_FK_HeaderID, CommentDesc, seq )

D is called table-alias.. This is dynamically assinging a name to a sub-query so that i can be referenced elswhere in...

There are lot of tables in the mix. I'm confused. But here is the code i use when i need to concatenate multiple rows into one single row.

IF OBJECT_ID('TEMPDB..#CONCAT_COLUMN_VALUES') IS...