My fan

have posted on administration forum, thought i'd try here well. i'm trying install sp1 tfs 2008 on single server. after working through several issues, install seems hang if it's waiting not giving prompt. have looked @ install log, , on last 3 attempts install, log stops @ .."add acl vcdata". there no errors in log, no errors in event manger, , no errors in sql logs. occurs 2 minutes installation according logfile, however, after leaving installer running 45 minutes, still not finish. a few notes on installation attempts: 1. using tfssetup account. 2. single server install on server 2003, sql 2005 2. have turned off ssl. 3. have changed fqdn of reportserveruri netbios name using tfsadminutil changeconnections command. 4. turned off versioncontrol log backup job in sql, recieving errors unable connect during installation. (we use 3rd party tool backups) any ideas on causing installer hang? hi matthew, are still having problem? sorry dealy, --aaron

hi all, sometimes getting same error, nothing has been changed in structure of cube. do have idea be? <return xmlns="urn:schemas-microsoft-com:xml-analysis"><results xmlns=" http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults "><root xmlns="urn:schemas-microsoft-com:xml-analysis:empty"><exception xmlns="urn:schemas-microsoft-com:xml-analysis:exception" /><messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception"><error errorcode="3238002695" description="internal error: operation terminated unsuccessfully." source="microsoft sql server 2008 analysis services" helpfile="" /><error errorcode="3238068224" description="the following system error occurred:  unspecified error ." source="microsoft sql server 2008 analysis services" helpfile="" /><error errorcode="3240034318&

hi , sql agent job failed , script component package in step. need help. description: system.reflection.targetinvocationexception: exception has been thrown target of invocation. ---> microsoft.sqlserver.dts.pipeline.doesnotfitbufferexception: value large fit in column data area of buffer.     @ microsoft.sqlserver.dts.pipeline.pipelinebuffer.setstring(int32 columnindex, string value)     @ microsoft.sqlserver.dts.pipeline.pipelinebuffer.set_item(int32 columnindex, object value)     --- end of inner exception stack trace ---     @ microsoft.sqlserver.dts.pipeline.scriptcomponenthost.handleuserexception(exception e)     @ microsoft.sqlserver.dts.pipeline.scriptcomponenthost.primeoutput(int32 outputs, int32[] outputids, pipelinebuffer[] buffers)     @ microsoft.sqlserver.dts.pipeline.managedcomponenthost.hostprimeoutput(idtsmanagedcomponentwrapper100 wrapper, int32 outputs, int32[] outputids, idtsbuffer100[] buffers, intptr ppbufferwirepacket)  end error  error: 2016-0

hi, when try open .docx file ie 9 getting pop-up open / save / cancel buttons. when click on open button throwing pop-up window save / cancel options. i need open file in word 2010 not happening. have save file desktop , can open it. tested google chrome , mozilla , good. any on this...appreciated. hi chiratla, please try 1 or more of following methods: try reset ie settings , check issue again; try repair office , check issue again;. . for reference: how reset internet explorer settings‎ http://support.microsoft.com/kb/923737 max meng technet community support Microsoft Office  >  Word IT Pro Discussions

hi, i running windows server 2003 sp2 database server (sql server 2005 sp3) and have noticed following error message on console: windows - exception possible deadlock condition (i not find additional info about this error in system , application logs) i have found out error has nothing sql server. how can find out cause of error? thank time evgeniya hi, i running windows server 2003 sp2 database server (sql server 2005 sp3) and have noticed following error message on console: windows - exception possible deadlock condition (i not find additional info about this error in system , application logs) i have found out error has nothing sql server. how can find out cause of error? thank time evgeniya Windows Server  >  Windows Server General Forum

hi trying script in powershell , pretty sure close. need on finish line. not great @ scripting able tell here goes. have loads of .zip files in deep folder structure. zip files contain folders , within them 1 pdf or 1 doc or 1 xls etc. example: \folder1\04.zip contains \users\gil\desktop\accounts.pdf example: \folder29\15.zip contains \users\bob\mydocs\etc.docx want grab single file form zip , extract (ignoring irrelevant folders in zip) same location zip file is, renaming extracted file same name zip retaining extension of file. once done, zip can deleted.  thoughts find zip file, extract temp folder, move or copy file location of zip file , rename zip file name. delete contents of temp folder before moving onto next zip etc etc. here script. except can’t figure out how include extension in moving/renaming phase. if change ($_.basename) ($_.name) name , extension of zip in previous step.i think need capture name of file in get-childitem step? have no

hi, could 1 provide steps replacing windows 2008 additional domain controller windows server 2012 additional domain controller keeping same name , ip address. currently have 1 windows 2008 domain controller , 1 additional domain controller. thanks, syed hopefully have more 1 dc in domain , site.  don't want rename dc follows: start decommissioning dc have http://blogs.dirteam.com/blogs/paulbergson/archive/2012/07/25/how-to-decommission-a-domain-controller.aspx shutdown server , aduc remove old computer object domain. depending on site topology have need ensure have replicated activity before promoting next dc. join new dc domain , if don't have current dc server 2012 make sure adprep domain , forest followed promotion process: http://msmvps.com/blogs/mweber/archive/2012/07/27/upgrading-an-active-directory-domain-from-windows-server-2008-or-windows-server-2008-r2-to-windows-server-2012.aspx paul bergson mvp - directory services mcitp: enterprise adm

hi all,   i used step step document on dhcp-nap deployement. had set things per document. nap not working. set rule firewall. though turn off firewall nap not pushing anything. system still works fine. appriciated.   regards inba i followed same step-by-step guide dhcp nap enforcement, if did every step configured auto remediation right? check client (event viewer -> applications logs -> microsoft -> windows -> nap -> operational) and server (event viewer -> windows logs -> system) event logs and see if find entries regarding auto remediaton of client, goes fast it's possible don't notice without checking logs. had same problem when turned off firewall, got switched on fast , didn't notice every time tried this. also, check if nap agent service started on client machine. did client machine request ip address again after configured nap, maybe try ipconfig /release , ipconfig /renew ?  

hi, i have 3 x  w2008r2 servers acting web servers in load balanced set up. one server is source , looking way replicate sites server - identically configured "empty" iis. some sites have own web.config files , not. i want write script enumerates web sites, exports each site , can import ("push") target server. all appreciated, especialy how read source site  and push a single site server? much obliged, roy roys99 hi roys99, thanks posting here. perhaps using iis built-in feature can achieve goal easily: synchronize iis 7 http://learn.iis.net/page.aspx/446/synchronize-iis/ for iis questions, please post iis forum in order professional responses: http://forums.iis.net/ thanks. tiger li tiger li technet community support Windows Server  > 

hi all, i have terminal server 2003r2 installed and running for on 2 years. suddenly users disconnected , can no longer reconnect. sounds license issue, check out license server management and error. after rebooting server seems working fine until next time. and licenses management works fine. any ideas ? hi, thanks post. what exact error message on client side? related event id generate on both client , server? can use performance monitor verify important measurements can cause low performance of terminal server. more detailed information, may refer following article. monitoring performance http://technet.microsoft.com/en-us/library/cc960963.aspx performance monitoring http://technet.microsoft.com/en-us/library/cc781265(v=ws.10 ) best regards, aiden aiden cao technet community support Windows Server  > 

hi all i attempting setup high available cluster server 2008 r2 enterprise. the hardware intel modular server 2 blades.  @ present, have 1 nic confirgured on each know issue shouldnt prevent initial setup ? the nics static ip's 10.0.0.41 , 10.0.0.40 gateways , dns enteredt.  netbios enabled on both. when asks cluster name, eneter cluster name , enter ip address not in use - 10.0.0.11 i have checked dns , there no entry ip 10.0.0.11 when attempt create cluster, completes , fails saying cleanup unsuccessful. the shared storage setup , ready go , took offline before attempted create cluster.  have 2 shared lun's, 1 1gb in size quorom , 1 400gb vhd files , storage passed config test ok. there not enough information here if can help, can provide whatever require. thanks mark did run validation ? , did every test complete ? Windows Server  > 

we have windows server running oracle web server.  it hosts https page.  that page presented through isa server.  our ssl certificate expire.  since wasnt 1 set up, dont know process.  it looks me certificate lives on isa server, , dont need on windows oracle server.  if case, open certificates in mmc , import renewed certificate, activate within isa? i'm sorry, none of above accurate.  to begin with, have add new certificate in certificates mmc on isa server.  however, important note have import full keypair file.  in order this, have create csr request on server.  once completed have apply new certificate , associated bundle generating server.  now has full certificate, have export certificate pcx file.  now can import on isa server , use web site being presented. second, not have have certificate on web server.  in case, nobody knew how open key locker on oracle server.  instead did above steps on iis within windows xp virtual machine.  everything worked fine.

i'd able grant non privileged users (helpdesk staff) ability run commands remotely on terminal servers using powershell remoting.  our helpdesk has ability run simple "query session" while logged terminal server (giving them list of logged in users), cannot run remotely (error message below).  goal give them ability discover (and logoff if necessary) logged terminal server without having rdp in, load terminal server manager , connect session broker etc etc. as domain admin & server administrator, have ability run command - helpdesk not (they member of remote desktop users local group) command (from xp machine w/ powershell 2.0): invoke-command { query session } -computer server04 error message: [server04] connecting remote server failed following error message : access denied. more information, see about_remote_troubleshooting topic.     + categoryinfo          : openerror: (:) [], psremotingtransportexception     + fullyqualifiederrorid : pssess

hi there, got odd 1 here or maybe setup wrong? scenario - wsus server setup , used gpo set following last night: allow au immediate install (for no-intrusive updates explanation states) automatic detection interval enabled 10 hours configure au to: auto download , scheduled install every day @ 3am. specify intranet server (obviously :)) ok thought myself, come in today , 2 machines restarted following updates during working hours, 1 prompted 5 minutes shutdown etc... other can assume did same user locked system , went away bit, come , had done it. below excerpt second pc's windowsupdates log file: 2008-06-03    10:49:15:111    1076    bd4    au    setting au scheduled install time 2008-06-04 02:00:00 2008-06-03    10:51:47:431    1076    758    report    uploading 1 events using cached cookie, reporting url = http://server/reportingwebservice/reportingwebservice.asmx 2008-06-03    10:51:47:447    1076    758    report    reporter uploaded 1 events. 2008-06-03    10:53:38:321    107

i have issue service after reboot. ------------------------------------------------------- log name:      application source:        srmsvc date:          2/10/2012 12:01:44 pm event id:      8197 task category: none level:         error keywords:      classic user:          n/a computer:      ewrcltachsbs1.columbusltach.local description: file server resource manager service error: unexpected error. operation:    checking file server resource manager global configuration store.    starting file server resource manager service. error-specific details:    error: cglobalstoremanager::install(), 0x80070005, access denied. event xml: <event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">   <system>     <provider name="srmsvc" />     <eventid qualifiers="32772">8197</eventid>     <level>2</level>     <task>0</task>     <keywords>0x8

en mi servidor de domein cotroller se me estan bloqueando la cuenta de usuario y administrador tengo que usar un programa tipo scrip y dejarlo en automatico y siempre esta desbloqueando de forma automatica. esto que se debe virus o que ? tengo en mi servidor el anti virus mcaffe y no detecta nada de virus. tengo un problema que se me bloquea el dominio cuando el usuario se conecta la red. dice dominio o usuario bloqueado me pasa diario y con usuarios diferentes nivel nacional. como puedo solventar este problema ? el windows que estoy usando en mis servidores es windows server 2003 por los síntomas, sigues teniendo en algún lado el conficker y sigue reproduciéndose. con que quede en un sólo lugar la infección vuelve. guillermo delprato - mvp-mct-mcse-mcsa mcitp: enterprise/server administrator mcts: active directory/network/applications configuration --- este mensaje se proporciona "como está" sin garantías de ninguna clase. usted asume todos los riesgos. --- bue

 good day all, firstly, please excuse lenght of post, need explain issue in ddetail. i am having problem with window server 2008 standard edition (32-bit) installed on dell r200 server. at first joined server to a windows 2003 domain (which prepared windows 2008 - adprep /forestprep etc.) , attempted promote it as first windows 2008 dc, dcpromo failed following error: "failed install active directory domain services binaries. error was: requested operation failed. system reboot required roll changes." after rebooting server, nic icon displayed red "x" if not connected, the strange thing server still able ping other machines on network , still able on internet, other machines not able ping server @ all. when moused on nic icon following was displayed: "connection status: unknown. dependency service or group failed." also, following "automatic startup" services not starting: base filtering engine dhcp client diagnostic policy service ike , authip i

hi, i wonder how make windows server in local lan accessed others on internet ? can 1 me above request , provide additional information required. please me. sanu hi, thanks post. based on experience, log onto windows domain access resources in domain external network(via internet), may consider:  1. may deploy vpn server, external domain client able log onto domain interactively when dial vpn connection before log on. 2. in windows server 2008 r2 , windows 7, new feature named directaccess introduced provide seamless, remote access method roaming domain client. similar thread reference: connect domain server outside of domain https://social.technet.microsoft.com/forums/windowsserver/en-us/32833e16-d52f-4a1c-8115-16b8277c4d5f/connect-to-domain-server-from-outside-of-the-domain?forum=winservermanagement best regards, alvin wang please remember mark replies answers if , un-mark them if provide no help. if have feedback technet subscriber support, contact

i running dell t430 windows 2016 server, backup exec 16, , have 5 seagate external usb 3 4 tb hard drives.  each day exchange 1 of hard drives out run full backup.  since installing new server setup each day when unplug drive , plug in new drive error in device manager. see unknown usb yellow marker, , properties say.  windows cannot load device driver hardware because previous instance of device driver still in memory (code 38).  in order usb work again have reboot server.  i have tried unload the driver before unplug going safely remove hardware , eject media, error on because believe backup exec holding drive letter up.  surely there fix or trick not have reboot on daily basis.   i'd check have latest bios , chipset installed. http://www.dell.com/support/home/us/en/04/product-support/product/poweredge-t430/drivers?os=wst14     regards, dave patrick .... microsoft certified professional microsoft mvp [windows server] datacenter management disclaimer: pos

hi, i'm sorry "ambiguous" subject way me describe topic :) i'll try , explain need in words , each statement i'll put below code have that.  the goal these queries merge 1 working script can of these things , generate output csv-file or whatever. so here goes: i have to: - query ad pc's in <ou> with a name '*-c' get-qadcomputer -searchroot <ou> | ?{$_.name -like '*-c'} -  from output want first verify if pc in question online or not, if not > write   "offline" or in output file <code> ? (i know several ways can't seem integrate nicely without f*cking output somehow) - next, if pc's online, script have check 2 things:                     - check ie version of host {[system.diagnostics.fileversioninfo]::getversioninfo("\\$_\c`$\program files\internet explorer\iexplore.exe") } but how do host variable to get pumped unc-path ? , how subsequently output decently outpu

just demoted old pdc , added , promoted new pdc.  dcdiag passed tests before promoting.  have not raised functional level 2008 yet. i believe scrubbed old pdc dns though have seen show in queries (can't remember which). dcdiag on pdc still has no errors. other dcs have error: warning: dcgetdcname(pdc_required) call failed, error 1355 primary domain controller not located. server holding pdc role down. on dcs netdom query fsmo list pdc roles. on dcs nltest /dclist:domain.com lists correct dc pdc. the pdc seems authoritative time server. in dfs management, when try list namespaces receive following error: \\domain.com\namespace :  namespace cannot queried. specified domain either not exist or not contacted. replication groups populate. i need troubleshooting.  thanks i think forgot delete entry of old dc dns following locations. manual steps dnsmgmt.msc [dns management]  a.expand forward lookup zones\_msdcs folder  i. make sure actual domain cont

hello, on server 2012 essentials windows 7 clients, files on network shares report locked program. this happens when user closes file , tries open shortly after. sometimes, takes considerable amount of time before file lock released. any appreciated. thank you dan merpc hi dan, the issue occurs on specific file type or files have same issue? we have faq thread troubleshooting network slowness issue. please see if help: http://social.technet.microsoft.com/forums/windowsserver/en-us/7bd9978c-69b4-42bf-90cd-fc7541ccb663/forum-faq-troubleshooting-network-file-copy-slowness?forum=winserverpn if have feedback on our support, please send tnfsl@microsoft.com. Windows Server  >  File Services and Storage

hi,   i've created certificate on ts gateway , installed certificate (import) localy on computer. now, regardinig ts cap , rap can connect servers on internal network through rdp.   my questions: - how skip local installation of certificate , publish computers on domain? - don't have separate ip address sll listener. possible user existing sll certificate (for example exchange/owa , use ts service). in way can create additional rule on isa server. how publish ts gateway service existing ssl certificate? - real advantage internal/external users use rdp on ts gateway? external - don't need use vpn connection anymore. else?   thnx!   >1. can please explain type of certificate must generated on enterprise ca? web server/computer do.   >2. yes, mean ssl certificate, used owa. can use same cerficate ts exchange or must new one?   if want cer without private key , should create new 1 gateway machine. if have pfx exchange can use that.   sa

i've been having issue since 9926 preview build update computer updating , restarting. know it's part of technical preview , such right it's crossing point of being overly excessive. 5 minutes ago updated , had me restart, second restarted got popup stating needs restart. ignore , that's fine ignored long until tries restart after 15 minute timer counts down. normal, happening everyone? it's frustrating trying figure out because can find people having issues applications, booting up, or annoyance turning off auto-updates build. wouldn't lose complete reformat or i'd rather not have to. i not entirely sure how reinstall specific preview, happen provide guide in order so? your post not indicate dual booting, , using win 10 tp 9926 operating system in computer. yes ? if yes, use following link download 9926 iso file. pro ( non-enterprise ) version. http://windows.microsoft.com/en-ca/windows/preview-iso make sure choose language have been

i have 5 offices, each own child domain, , parent domain keep namespace.  1 of children had ad domain controller issues , domain controller replaced.  when domain controllers running, fine.  can reboot either domain controller , still, fine.  then, office these in have had several power events (post hurricane sandy recovery), requiring power down equipment.  when domain controllers come up, takes 15+ minutes login screen.  once login screen, if trying rdp domain controller, message domain doesn't exist!  if can physically log server console, resumes normal.  member servers can authenticate , can have end users log in again.  well, have shut down next 4 weekends in row, , i'm afraid isn't going come right.  don't want 1 can things running again, other coast!  i suspect dns issue.  can tell, forward zones fine.  reverse zone network not.  network, have 20.172.in-addr.arpa, , 20.172.in-addr.arpa/1.  under 20.172.in-addr.arpa, see ns records , soa.  under 20.1

i have scripts prune operating logs date, in case need delete 1 file among group. doesn't matter one, 1 of files. paint picture, use files on shared volume artifically fill volume. space presented our san , when our users run out of space remove 1 of these large files stop denial of service due disk space. want create powershell script remove "one" of files elleviate disk space issue. any thoughts? in advance!   try this:   get-childitem m:\ | sort creationtime | select -first 1 | remove-item gets list of items, sorts them creation date, grabs last 1 in list (oldest) , deletes item.   rich prescott | infrastructure architect, windows engineer , powershell blogger | mcitp, mcts, mcp engineering efficiency @rich_prescott client system administration tool ad user creation tool Windows Server  > 

hi all, i know how can grant internet access dc has been configured in vmware platform in test environment. also know prerequisite configured it.  scenario : have 1 domain , 3 dc (windows server 2008 r2) , connected static ip address, need provide internet connection domain , through domain can shared other dc , can able access internet in servers. also, don't have router possible achieve scenario.  i glad if can me requirements , tools needed accomplish above scenario. please let me know if else required. thanks atul srivastava you enable rras (see there example : using rras share internet connection within private network ) on other side dont have small soho router dlink or linksys ? make job too.  regards, philippe don't forget mark answer or vote helpful identify information. ( linkedin endorsement never hurt :o) ) answer interesting quest ion ? create wiki article it!

 windows 2012 r2, wsus, patch clients not able download updates. 1.from an  admin login, can download cab file. http://<wsusservername>/iuident.cab; however, cannot download standard user account 2. selfupate folder not exit in default website. exit in wsus administration website 3. :\program files\microsoft windows server update services\setup\installselfupdateonport80.vbs... not exit update log: there error communicating endpoint @ 'http://encsdwsus:8530/clientwebservice/client.asmx'. 2016/04/25 15:48:30.9381701 788   2204  webservices     ws error: given proxy cannot reached. 2016/04/25 15:48:30.9382181 788   2204  webservices     web service call failed hr = 80240438. 2016/04/25 15:48:30.9382185 788   2204  webservices     current service auth scheme=0. 2016/04/25 15:48:30.9382185 788   2204  webservices     current proxy auth scheme=0. any appreciated hey. reply. resolved it. permissions issue. took ownership of selfupdate folder ,

i have iscsi mounted volume redirect vss snaps on file server. need replace iscsi target server moving block device new 1 trivial, how can force vss on win2008r2 utilize new volume without causing purge existing snapshots in meantime? could disable vss service, reboot, remount, correlate drive letter original, enable vss service , reboot? or vss internally remember volid etc? thanks! hi, we may not able configure vss use old snapshots on new volume, or transfer snapshots new volume. after replacing hard disk, error "the disk contains backup either not online or not accessible". Windows Server  >  File Services and Storage

convenient make certificate request via web service, new feature comes windows server 2008 r2. , have done c++ code when found icertrequest3 on msdn. possible revoke certificate via such kind of web service? referred documents , found icertadmin2::revokecertificate api. icertadmin2 can work on ca server , not supported work on client side. > means more work , more error-prone. i don't see other ways. you. > mean after installing can call icertadmin api programmatically , locally on client machine? yes. adcs rsat components installs server side components (icertadmin, icertview, iocsp*, etc.). > possible me pach windows server 2008 r2? sure. in server manager, open feature called remote administration tools , select desired tool set, adcs in case. my weblog: en-us.sysadmins.lv powershell pki module: pspki.codeplex.com powershell cmdlet editor pscmdlethelpeditor.codeplex.com check out new: ssl certificate verifier check out new: powershell f

hi, i migrated file server windows 2003 r2 standard windows 2008 r2 standard. virtual machine on vmware built new 2008 r2 box, shut them both down, reattached virtual disk new vm, rebooted , loaded file services role fsrm. seemed go , quotas with notifications etc appeared in fsrm. the problem when 95% quota thresholds reached, administrators receiving thousands of email notifications a day. i have set notification limits in options 240 minutes doesn't seem make difference. have had uncheck send email following administrators check box because getting lots of calls angry department administrators saying had received 3000 emails notifying them quotas had  been exceeded. i have 2 more file servers migrate , don't want same problem happening again on these advice appreciated. many thanks egg eggzter have test turn off quotas , turn on check result. Windows Server

hello everyone! can tell me ports need configured between powershell dsc pull server (https) , dsc clients? surely ports define ports define web server during configuration have reachable clients... there else opened in (hardware) firewall? thanks, jens jensit.wordpress.com protip: clients called nodes in dsc. honestly, don't believe you're going need anymore ports opened port used dsc pull server website, , compliance server website. if take @ powershell.org's, the dsc book , they've used 8080 , 9080 respectively. port reference part of configuration script, , mof, used build out dsc pull server. if you've built dsc pull server, open iis manager , check bindings on sites -- make sure ports opened. if you're using powershell, can use get-website cmdlet, returns website names , bindings. if you're worried there's more , end having problems, have network team watch firewalls in real time drops between ip of dsc pull server , dsc node.

hello everybody, i have encountered issue when tried overrule "home" level access rights on ssrs (verion 2009.0100.1600.01). the situation there third party company has setup , edit reports. created folder them , edited security settings there. confirmed have different security settings on parent "home" level third party should not have access other reports. i added user , assigned "content manager" role. after able access folder, upload reports , data sources. but: not able edit reports or sources. gets message: the permissions granted user 'xy' insufficient performing operation. (rsaccessdenied) online help i assigned roles did not help. test showed if user has rights inherited "home" (added there content manager role) can edit reports uploaded. in case has access other folders (as inherit security settings "home"). is not possible ssrs set way planned? in advance help! br, karsten hi karsten,

i create hyperlinkbutton has "selected" type state. mean this, color of link should changed when it's selected. i've been trying modify template hyperlinkbutton, has not come strategy this. the behavior similar silverlight 4 beta facebook app, active page highlighted different color. done such thing? i either use togglebutton (that has selected state), or create custom control inherits hyperlinkbutton , add selected state property , visual state manager Silverlight  >  Designing with Silverlight

hi , i looking below solution using sql . create table #temp ( id varchar(10), value int ) insert #temp values('a',-9),('a',1),('b',-5),('b',3),('c',12),('c',-2) input                       output id value id pos value neg value a -9 a 1 -9 a 1 b 3 -5 b -5 c 12 -2 b 3 c 12 c -2 thasnks in advace regards, vipin jha thankx & regards, vipin jha mcp try below: create table #temp ( id varchar(10), value int ) insert #temp values('a',-9),('a',1),('b',-5),('b',3),('c',12),('c',-2) select id, max(case when value >0 value else null end), max(case when value <0 value else null end) #temp group id drop tab