Viewing 3 posts - 1 through 3 (of 3 total)
it should be
select cast(fill as nvarchar(20))+'-'+ cast(number as nvarchar(20)) from tablename
April 6, 2011 at 2:30 am
#1307857
You can use the inner join and do the update,
something like...
UPDATE D SET InterNetConnectivity = ISNULL(CASE WHEN [HOME INTERNET CONNECTIVITY]='YES' THEN 'Y' ELSE 'N' END,'')
FROM (SELECT DISTINCT [EMPLOYEE ID],[HOME...
April 6, 2011 at 1:30 am
#1307835
can u please look on this
Physical RAM Target Avail RAM in Task Manager
< 4GB ...
April 6, 2011 at 1:23 am
#1307833