Your technology certification is waiting. Enroll in Cloud Class ®
An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
create table #Tmp
insert into #Tmp select '14/02/2011',0
insert into #Tmp select '14:02:2011',0
insert into #Tmp select '14:02/2011',0
insert into #Tmp select '14/02:2011',0
declare @DateValue nvarchar(20)
while ((select count(*) from #tmp where validDate=0)<>0)
select top 1 @DateValue= datevalue from #Tmp where validDate=0
update #Tmp set validDate=1 where datevalue = @DateValue and convert(datetime,datevalue,103) = convert(datetime,@DateValue,103)
--select convert(datetime,date) from #Tmp
update #Tmp set validDate=2 where datevalue = @DateValue
select * from #Tmp where validDate= 2 --Error occured
drop table #Tmp
Open in new window
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.