I see what you're saying. I tried it with the below example, and it returned 1 for placevalue of first tab.

DECLARE @REALNAME varchar(255)

SET @REALNAME = 'Ricki Ricardo'--where the leading space...

ach, sorry, I meant leading white spaces. NOT zeroes.

like this:

/****** Script for SelectTopNRows command from SSMS ******/

DECLARE @REALNAME varchar(255)

SET @REALNAME = ' Ricki Ricardo'

select LEN(@realname)

select len(RTRIM(ltrim(@realname)))

in this...

OK, coincidence that my last query should have been a SELECT INTO.

Yes, Bhuvnesh, I think restarting SQL Server should have reset the numbers for SPID 54. Besides, I wasn't...

I'm concluding that session 54...

Chris/anyone, will you kindly explain to me the factors that require one to use CROSS APPLY for the above 3 queries of the CTE?

parulprabu, Thanks for the help.

I am making a permanent table. But I need the datetime without the zeros on end.

just

2009-10-20 21:45

not

2009-10-20 21:45:00.000

for bonus bonus, can you show me how to get just the date and minutes? eg. 2011-10-20 21:45

well, this gives me a table with one row containing two values:

2011-10-07 16:11:56.3432023-10-04 16:14:56.343

I changed to Select *.

Thanks for the answer with the bonus mini - puzzle Luis. I...

Alan and Lutz, very glad for reply. Thank you for showing me syntax that'll do the job. I will work on this tonight.

Chris. It's Magic.

I have a lot to learn about OUTER and CROSS APPLY.

When I join to the Dates table, I am now successful in creating placeholders for those dates missing. The values for all the columns from the CannedBackupJobs table are...

Thanks Scott, and everyone for replies & link.

YIKES, I see the error. The where should be d.d>=

and not dbj.starttime >=

This works:

select * from cannedbackupjobs dbj

full outer join _dates d on d.d = CONVERT(VARCHAR(10), dbj.starttime, 120)

where d.d...

OK. I've got a dates table using.

CREATE TABLE _Dates (

d DATE,

PRIMARY KEY (d)

)

DECLARE @dIncr DATE = '2000-01-01'

DECLARE @dEnd DATE = '2100-01-01'

WHILE ( @dIncr < @dEnd )

BEGIN

...