Lun

simple question.  have client needs sql 2005 standard installed now, , cannot wait media arrive.  know can download 180 trial of sql 2005 enterprise, can licensed standard when purchase?   you'll able transfer db's 1 edition other, cannot update product key once product has been installed.  in pinch, can install trial version going, backup/detach , reinstall product new key when media arrives. thanks, sam lester (msft) SQL Server  >  SQL Server Setup & Upgrade

hi all, i'm toying using virtual earth silverlight map control ctp build gis-based web application.  wanted make use of silverlight's cross-browser support, 1 of our clients sticking resolutely internet explorer 6. the trouble i'm having whenever load app ie6, see no virtual earth maps @ - message: "unable contact server.  please try again later".  map zooming functions appear operate correctly, can add own polygons map, , 'zoom in' them (the scale line @ bottom-right changes too).  it's don't see maps, in either road or aerial view. when use interactive sdk page ( https://sharepoint.connect.microsoft.com/silverlightmapcontrolctp/isdk/default.htm  ) not see map images. it's fine in other browsers, not ie6...  can shed light on might wrong? thanks   after dissembling microsoft.virtualearth.mapcontrol.dll using redgate's net reflector (very cool tool http://www.red-gate.com/products/reflector/ ), appears issue related p

hi i have daily job load millions of records oracle database.  but before loading them main table records loaded staging table. after loading them staging table have 1 query delete duplicate records it. problem is taking 3-4 hrs complete task. there alternative delete duplicate records , impove performance of package thanks in advance sri sri here techniques removing duplicates using ssis (although t-sql solutions may better you). talk me on SQL Server  >  SQL Server Integration Services

hi , load out entities daily @ end of day inserting transactions tblstgmember , tblstgmemberattribute tables. of not have issue. long service broker on, batches processed.  we looking change schedule batch process, run during business hours. question when batch process happening , updating entity, if user tries edit same member in entity, change saved ? or overwritten batch ? there deadlock ?  i tried replicate scenario, wasnt having issues, inserted 1 transaction , before click save in ui, batch completing.  are there chances of issues if move batch process run during business hours ? in sql server 2012 or sql server 2014, last modify win. ever modify entity/attribute later, wins. in sql server 2016, enabled merge conflict support on ui manual modification. when user modify same attributes other users or background staging process changed, ui dialog popup let user resolve confliction. for example, 1. original value of entity1.attribute1 a. 2. user load data in we

hi i making moon phase calculator. have variable called (total) total number of days passed since 0bc variable changes every day. want subtract variable (newmoon) same number time. wondering how subtract chenging everyday (total) fixed number (newmoon). want call new total (daysince). have tryed:     toal-newmoon=daysince      doesnt work not sure how it. thanke in advance advice. try this: daysince = toal - newmoon so result of "toal" substruct "newmoon" in "daysince". i hope can help you.   best regards martin Learning  >  Small Basic

i have read numerous previous posts on similar errors.  far i've ruled out: 1. have athlon processor cache prefetching xp 1700+ 2. have tried installing advanced options , selecting local sytem , local service. none of these solutions solved problem.  still same install error , it's quite maddening, since install program verifies of hardware , software meet install conditions.  running xp home, i'm in workgroup, not domain..  attach log install below. any more suggestions? thanks, gtc. microsoft sql server 2005 9.00.2047.00 ============================== os version       : microsoft windows xp home edition service pack 2 (build 2600) time             : thu sep 14 19:48:26 2006   machine          : thomas product          : microsoft sql server setup support files (english) product version : 9.00.2047.00 install          : successful log file         : c:\program files\microsoft sql server\90\setup bootstrap\log\files\sqlsetup0

can gmsa used sql server login? we using gmsa accounts our iis application pools , applications host need access sql server resources. each application accessing sql server gmsa account application running under. we've created logins , assigned appropriate permissions gmsa accounts appropriate databases. gmsa accounts work until gmsa password changed on default 30 day interval. after password change, seeing error 18456, severity 14, state 38. does iis authenticate kerberos, or ntlm? eg select session_id, client_net_address, auth_scheme ,* sys.dm_exec_connections ntlm authentication based on password hashes, if iis presents out-of-date hash, ntlm auth fail.  kerberos should work. does login problem go away if bounce app pool? david david http://blogs.msdn.com/b/dbrowne/ SQL Server  > 

i ask how can add & update extended properties in sql express 2008 database propertiesusing c#? jassim rahma using smo extendedpropertycollection http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.extendedpropertycollection_methods.aspx sankar reddy http://sankarreddy.com/ SQL Server  >  SQL Server Database Engine

hi all, i have strange requirement need advice.first of let me explain current scenario. 1> have ssis package schedule job , runs daily per schedules. this package generates files particular location , these files generated using procedure. now procedure been called in ssis package , executed.but requirement such have generate  data based on quarter. say q1,!2,q3,q4 passed parameter , executed. now new requirement whenever user tries execute job manually right cliking on job name. prompt has provided such user shud able select quarter , selected quarted must sent parameter ssis package. my question is possible generate prompt kind of thing whenever user tries excute job sql server manully ? please advice me on this. please have on comment i have code , iits wrking fine me public function promptforparams() scriptresults         dim response string         dim spidint string         ' default task output failure         dts.taskresult = scriptresult

how make folder part of build solution vs2010, automatically added part build process. suppose have 2 project in solution. 1 main project , setup project. main project has folder want make part of build solution vs2010 ide. whenever build setup folder , content added in setup project automatically. looking suggestion in detail. thanks hi mou_kolkata, if understand correctly, want create project template can used when add new setup project. this, can create bi project (such report server project) sample, , save it. then, copy project files (.rptproj file , .rptproj.user file) following folder: c:\program files (x86)\microsoft visual studio 10.0\common7\ide\privateassemblies\business intelligence projects after that, when add new bi project, custom template listed in bi templates list. furthermore, can place report server project files in reporting services folder in buisiness intelligence projects folder. way, custom template listed in reporting services templates list.

hi, i creating data flow load excel file sql server table. when try create excel connection manager source , select excel file sheet in "name of excel sheet" option, it's taking lot of time pull tab. there way can select tab , create excel connection manager source. please advise... thanks in advance... you can chooose "data access mode" sql command , write queries : select * [sheetname$] http://www.rad.pasfu.com SQL Server  >  SQL Server Integration Services

hi everyone, i'm new site don't know if i'm posting on right place. since sql site, thought might better ask question here. ok, here goes.. i'm having problems placing time values in database table. when place time value, includes date value. i've read post stating sql server 2000 not include time data type , sql server 2008 has data type. also, i've seen post stating in order have time value without date in database table, i'm going have create user defined data type or separate time value date value , place them on different columns. according comments i've read article, said such practice obtaining time values not acceptable. i've tried using method stated in article no luck @ since new using sql server. i've tried using sql server 2008 saw time data type 'time(7)' , don't know if can use since need time values , pm. , migrating sql server 2000 sql server 2008 doesn't seem working me since using sql serve

i'm configuring wmi event watcher task serve file watcher on unc share.  task configured follows: wmi connection: server name: \\devdb01 namespace: \root\edi_files windows authentication wmi event watcher task wqlquerysourcetype: direct input wqlquerysource: select * __instancecreationevent within 10  targetinstance isa "cim_directorycontainsfile" , targetinstance.groupcomponent = "win32_directory.name=\" \\?\unc\devdb01\\edi_files\ "" the task fails following error message: [wmi event watcher task] error: watching wql query caused following system exception: "invalid namespace". check query errors or wmi connection access rights/permissions. how configure task use unc share on server? you have map first: net use d: \\unc\devdb01\edi_files\  unc not work (afaik). please mark post answered if answers question | ssis blog: http://microsoft-ssis.blogspot.com | twitter

i can't install sql server express. when try @ end setup says installed when go remove software not there. have vista think going xp can solve lot off problems. sugestion ? it related admin permissions if don't have admin permissions try thread below , make needed changes.  thing vista ultimate vista home edition can use install reporting services because comes iis7 window authentication.  hope helps.   http://forums.microsoft.com/msdn/showpost.aspx?postid=1901664&siteid=1   SQL Server  >  SQL Server Express

i trying install default instance of sql server express on machine running windows xp. when selected "default", instance name field got grayed out, instance id still showed "sqlexpress". after installation completed, realized instance installed in fact "sqlexpress". i un-installed , tried re-installed using default , "mssqlserver" instance id, , still installed "sqlexpress". i gave , decided install sqlexpress instance, install default instance afterwards, , uninstall sqlespress. when tried install default instance, i'm getting error: "the sql server instance 'sqlexpress' has instance id 'sqlexpress' different specified instance id 'mssqlserver'. specifying more 1 instance id same sql server instance not supported." this has happened in 2 different computers, wonder if problem installation, not computers. any vastly appreciated. hello varsham papikian, you right reply. in fact, corrected bug sp1 s

to all,      having heck of time on sql 2k5 migrationwizard.exe.  following ambiguous message:  exception type 'system.outofmemoryexception' thrown.   the typical "life-lines" of searching ms have provided no help.  wizard migrating 35 dimensions and about 40 cubes.  sql 2k5 handle?   kenny   after generate ddl script cube creation, search first <databaseid> element, should in first lines of script, in fragment one: < create xmlns = " http://schemas.microsoft.com/analysisservices/2003/engine " > < parentobject > < databaseid > foodmart 2000 </ databaseid > </ parentobject > < objectdefinition > < cube xmlns:xsd = " http://www.w3.org/2001/xmlschema " xmlns:xsi = " http://www.w3.org/2001/xmlschema-instance " > < id > budget </ id >   then change value of <databaseid> (the "foodmart 2000" string in our example) id of big as2005 data

hi guys,  this query   select convert(varchar(12), dateadd(ms, datediff(ms,'24:00' , '27:1' ), 0), 114)  i facing error : conversion failed when converting date and/or time character string.  i need result in hh:mm:ss format  please me out on issue.  thank you, arjun. arjun, the error comes '24:00' & '27:1'. must date or time types. here's solution: declare @start time; declare @end time; declare @null time; set @start = '09:06:00'; set @end = '21:27:00'; set @null = '00:00:00'; select convert(varchar(8),dateadd(ms, datediff(ms, @start,@end ), @null), 114) this solution inspired link: https://social.msdn.microsoft.com/forums/en-us/5a259b55-a2aa-4c3c-a73d-afa44d455f5c/difference-between-2-time-columns-in-sql-server-2008?forum=transactsql please click "mark answer" if post helped. SQL Server

i've been trying restore database several times, , tried reinstalling program well. after hours, restoring still "executing". i've been thinking computer couldn't handle cause happen. turned off firewall , tried restore database, unable complete restoring. ideas on why happening? (i apologize in advance lack of knowledge.) please contact me soon. thank you, xlinhx. you can executing queries using query in blog. http://sqlserver-help.com/2014/07/17/script-find-currently-executing-queries-blocking-waits-statement-procedure-cpu/ balmukund lakhani please mark solved if i've answered question, vote helpful other users find solution quicker -------------------------------------------------------------------------------- posting provided "as is" no warranties, , confers no rights. -------------------------------------------------------------------------------- my blog | team blog | @twitter | facebook author: sql server 2012 a

hello, i'm failing in inserting null value timestamp data type column in mssql server via sqlbindparameter. tried examples below. doing wrong ? of course, column nullable in database , henv set odbc 3.0: create table [test_table_rdd_odbcrdd] ( [date_lim] datetime null,    [sr_recno] numeric (15,0) identity,    [sr_deleted] char (1)  not null  ) sqlsetenvattr(henv, sql_attr_odbc_version, (sqlpointer) sql_ov_odbc3, 0); i've tried: ------------------------------------------------------------- sqlinteger nind = sql_null_data; sqlreturn res; res = sqlbindparameter( hstmt, 1, sql_param_input, sql_c_type_timestamp, sql_type_timestamp, sql_timestamp_len, 0, null, 0, &nind ); error diag: return code: -1, state: hy090, description: [microsoft][odbc sql server driver]invalid string or buffer length ------------------------------------------------------------- sqlinteger nind = sql_null_data; sqlreturn res; res = sqlbindparameter( hstmt, 1, sql_param_input,

i have s subfolder in clientbin, , wish directory on it.  suggestions appreciated.  yes yes... krasshirsch correct   just add wcf service(silverlight enabled) , add function like [operationcontract] public string[] getfiles(string path) { return directory.getfiles(system.web.hosting.hostingenvironment.mappath("~/clientbin/" + path)); }   and in client, add service reference, use like someclient sc = new someclient(new basichttpbinding(),new endpointaddress("your url/someservice.svc")); sc.getfilescompleted += (obj,arg) => { foreach(var v in arg.result) { //add v listbox } }; sc.getfilesasync(); Silverlight  >  Programming Silverlight with .NET – General

i'm curious others here. moving on large web project (.net 2.0, vs 2005) vss tfs. in vss there lots of smaller web solutions were a part of the larger web solution. allowed dev open smaller solution small web project , work - in turn made responsiveness in debugging , rebuild better. of course, 'partial' web project needed core parts primary web project. sharing being used here. allowed immediate chages replicated sub-solution mast solution.   as bring tfs sharing not, of course, option. 1 option having in 1 master solution , working master solution can slow load , build. option branching main solution create sub-solutions , getting load , build performance requiring merges.   how have others handled this? there plans refactor these sub-solutions can stand alone rely on various (different each sub-solution) parts of primary web solution.     using 'partial' solutions should work same in tfs did in vss.  long you've built prerequisites, , relative p

hi, im new sql server , im having trouble decide wich best way filter tables 1 user can read , write. for example table sales field named branch (smallint) values 1 or 2 (the store made sale). user "a" can see , write records branch = 1. im developing windows program shows purchased orders in datagridview. should make filters (permissions) in program or in sql server?. i hope made self clear (my english not good) you can use views restrict user's access data in table. views can function filters , users should granted no access base table, views corresponding access level. implementing kind of row level security can attempted in various ways. here's whitepaper describes more elaborate solution: http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx if search web "sql server row level security" should able dig more third party papers on topic. thanks laurentiu

we in process of evaluating pivotviewer our application. in watching the videos, looked of the images built live data. example, there products looked line charts within image. is possible? "how to's" have been reading, looks images need hard-coded in , preprocessed deep zoom file before they included in collection. in our application, of our data user-defined. not able hard-code in images. thanks! the videos , how-tos still talking original sl4.  in that, did have pre can images. in new sl 5 able build xaml templates.  i've heard @ least 1 person has had success in building in charts well.  going depend on how information needing.  can take advantage of semantic zoom load. let me know if run issues. Silverlight  >  PivotViewer Control with Silverlight

hi, i want know how can check if xp_cmdshell enabled or not , if enabled, users has right execute it? using sql server 2012 regards hello, you can check sp_configure if xp_cmdshell enabled: exec sp_configure 'xp_cmdshell' see msdn xp_cmdshell (transact-sql) regarding required permissions, sysadmins can run command directly. olaf helper [ blog ] [ xing ] [ mvp ] SQL Server  >  SQL Server Database Engine

we using tfs 2013 latest scrum templates , values 'effort' field in task work items past iterations or specific date. (like most) may have tasks carry on 1 sprint next capture real time historical data on past tasks.  is possible, if how? hi brian yes possible. can previous state of work item. to @ state of work item @ previous version can use following url in tfs web access: https : //<server>/<teamprojectcollection>/workitemtracking/workitem.aspx?artifactmoniker=<id>&rev=<revision> by changing revision can @ state of work item @ specified revision , don't need compare @ sequence of changed fields between desired revisions. if want retrieve information programatically need @ sample tfs api part 52 – getting work item history , customize specific need. please use mark answer if post solved problem , use vote helpful if post useful. Archived Forums V

hi all, is there anyway allow developers add new file/folder prevent them check in pending? i code reviewer check in pending new file/folder only. thanks, best regards, 1.  there no way separate permissions add & edit.  both governed pendchange.  you try cron job scanned directory existing files, granted pendchange on them, kept pendchange denied on parent folder...but sounds way work little gain.  i'd use code reviewer field kathirve suggested.  if want audit adding of new files, create small app subscribed checkin event, parsed new changeset adds, , reported them administrator. 2.  in ui, pendchange called "check out".  can see complete list here: http://msdn2.microsoft.com/en-us/library/ms252587(vs.80).aspx Archived Forums V  >  Team Foundation Server - Source and Versi

i trying configure reporting services.using domain\account (minimum privileged account) process goes @ "generating scripts" step , tries create database.there drive f: trying create database believe there no directory looking for.i tried creating 1 manually doesn't seem take effect.  any appreciated... thanks! i getting following error: system.data.sqlclient.sqlexception: directory lookup file "f:\program files\microsoft sql server\mssql12.mssqlserver\mssql\data\reportserver.mdf" failed operating system error 3(the system cannot find path specified.). create database failed. file names listed not created. check related errors.    at system.data.sqlclient.sqlconnection.onerror(sqlexception exception, boolean breakconnection)    at system.data.sqlclient.sqlinternalconnection.onerror(sqlexception exception, boolean breakconnection)    at system.data.sqlclient.tdsparser.throwexceptionandwarning(tdsparserstateobject stateobj)    at system.data.sqlcl

hi, if loadoperation done, datapager collection hold current page, or have downloaded entire collection of loadoperation. due loading time issues.     if use domaindatasource of ria service , datapager together, can set loadsize of domaindatasource control how many records downloaded 1 time. http://msdn.microsoft.com/en-us/library/system.windows.controls.domaindatasource.loadsize(v=vs.91).aspx Silverlight  >  WCF RIA Services with Silverlight

i'm working in sql server 2012 trying export data our database excel file. sql statement has 2 separate select statements. not joined union. when execute them inside of sql server management studio, results set go grid, 2 result sets back. two full tables of data . however, when use import , export wizard, excel sheet has first set of data. what need have both result sets show in excel file? if provide 2 queries, ssis consider first provided query , export result excel. 1) may run query manually in ssms , copy paste result set excel yourself. 2) may export data twice 2 excel sheets 3) may create ssis package extract data sql , load excel sheet1 , sheet2 1 time consuming. -vaibhav chaudhari SQL Server  >  SQL Server Data Tools

i getting timeout on following .net code: static void main(string[] args) { string sconn = "data source=myserver;initial catalog=mydb;integrated security=true"; using(var conn = new sqlconnection(sconn) ) { conn.open(); var cmd = new sqlcommand("dbo.sptest",conn); cmd.commandtype = commandtype.storedprocedure; cmd.commandtimeout = 1000; sqlcommandbuilder.deriveparameters(cmd); var par = cmd.parameters[1]; } } query timeout occurs stored proc added or altered after database restored test server. queries fail, eg cmd.executenonquery(). used deriveparameters example.  when testing procs untouched since before restore, queries work fine.  cause this? @joseph: nothing hints or stats. test failed on empty proc. i created new database scratch. set db options follows: set quoted_identifier on set arithabort on set numeric_roundabort off set concat_null_yields_null on set ansi_nulls on set ansi_padding

i event when surface book pen button (the 1 on eraser) pressed. does exist? i tried assigning page event to pointerpressed event, , looking @ properties of device.  can see nothing changing whether eraser button pressed or not, including barrelbuttonpressed, right, left, x1,x2, or erase.  tried looking @ righttapped event too, nothing. where's surface book pen button event or state hiding? thanks. hi chris_sirhc, have found solution capture event when top button of pen pressed? Other Forums  >  Surface Application Design and Development

hi, i error installing team foundation server on hyper-v windows server 2008 r2 sql server 2008 r2. during team foundation server advanced configuration 1 error , 0 varnings tf255356: following error occurred when configuring team foundation databases: error occurred while executing servicing step install catalog roots component install.tfsframework during install: tf14103: internal error: database procedure prc_savecatalogchanges returned wrong number of rows.. more information, see configuration log. error occurred while executing servicing step install catalog roots component install.tfsframework during install: tf14103: internal error: database procedure prc_savecatalogchanges returned wrong number of rows. any suggestions? best regards /patrik pla hi patrik, is issue occur after readiness check? could send me (v-ruizyi @ microsoft.com)the log find more detail infomation issue? best regards, ruiz msdn subscriber support in forum if have feedback on our s

hi, user control has property, currentcompound, contains value need display in hyperlink. however, when check value of property during user control constructor value null. how can properties value , use in content of hyperlink? my code below. the code invoked : <users:userctrl currentcompound="compound1" /> i have noticed @ line 24 property currentcompound empty , @ line 40 value contain correct string, since callback method static cannot access hyperlink's content property. 1 public string currentcompound 2 { 3 get 4 { 5 return ( string )getvalue(currentcompoundproperty); 6 } 7 set 8 { 9 setvalue(currentcompoundproperty, value ); 10 this .hypercmpdbtn.content = value ; 11 } 12 } 13 14 public static dependencyproperty currentcompoundproperty = 15 dependenc

i have error , how fix this   message [log] unable read local eventlog (reason: parameter incorrect)...   please let me know check below link unable read local eventlog (the parameter incorrect ) - msdn which edition & version of sql server working with? which os working with? SQL Server  >  SQL Server Database Engine

is there ssms (sql server management studio) - 64 bit download? when try import excel inside of ssms fails. i have go outside ssms , select import 64 bit shortcut. i using excel 2016 64 bit. thanks. if want download 64 bit version browse below link , click on download scroll down , fins both 32 , 64 bit version of ssms. link ssms 2014 https://www.microsoft.com/en-in/download/details.aspx?id=42299 cheers, shashank please mark reply answer if solved issue or vote helpful if helped other forum members can benefit my technet wiki articles mvp SQL Server  >  SQL Server Tools

hi, i have been asked develop hl7 file from 1 of sql server (2000) databases to send receiving party. i've seen biztalk has capabilities of building hl7 files biztalk i'm not familiar @ all. wondering if had experience this. i'm trying weigh-out wether it'll better write sql code output data in format, or learn how on biztalk scratch. both challenge it'd feel more comfortable writing script in sql server....depending on how hard learn biztalk. useful thoughts on topic appreciated. in advance.   guillermo g. guillermo garcia. guillermo, since doing a08 , a31's take few minutes , try make quick query it. parts going easy, header , control characters straight text. teh rest depends on database design how simple or complex query be, 2 events shouldn't complex, long (because of field , text concatination). once have query easy enough set job osql output file can picked up, or have interface (if using like cloverleaf [i think it sold by mckesson?

hi all, i trying enable encryption sql server.  thing trying application client-server based (iis webserver & sql server 2005 express databaseserver).  detailing process followed the same.  per theory, should work if settings mentioned below.  but, i’m getting error message while connecting sql server management studio encryption enabled. the error message - “a connection established server, error occurred during pre-login handshake. (provider: ssl provider, error: 0 - certificate chain issued authority not trusted.)” step 1 – create & install certificate (tried in both win 2003 & win 7) installed openssl tool & configured same generated private key using open ssl command (openssl genrsa -out server.key 1024) generated certificate signing request using openssl command (openssl req -new -key server.key -out server.csr) generates self-signed certificate using openssl command (openssl x509 -req -days 365 -in server.csr -signkey server.key -out server.crt)

hi! i make job executes stored procedures return stuff message tab. the content of message tab should sent email (or captured in table). i assume must possbile writing clr proc, how? in actual case want capture output 3. party (sourceforge) unit test stored procedure, deliveres report in message tab. thanks bjorn b. d. jensen sure bjorn, there example of using connection events (albeit oledbconnection, need use sqlconnection) here: http://msdn.microsoft.com/en-us/library/a0hee08w(vs.71).aspx  and examples of using "ordinary" connection strings , "context connection" connection strings (remember, won't work "context connection") in sqlclr here: http://msdn.microsoft.com/en-us/library/ms345135(sql.90).aspx  . need combine 2 concepts 1 sqlclr proc, and, because you're using "ordinary" connection string sqlclr, make assembly external access. just write if have issues. cheers, bob beauchemin, sqlskills

hi experts, i working on sql server 2008,need sql query display name of views and count of rows in each view  in database any help? try this: create procedure dbo.viewsrowcount as begin create table #temprowcount ( name varchar (100), row_count int ) declare @sql varchar ( max ) set @sql = '' select @sql = @sql + 'insert #temprowcount select ' '' + name + '' ', count(*) ' + quotename ( name ) + char (13) from sys.objects where type = 'v' exec (@sql) select name , row_count from #temprowcount end once procedure created; can use as: exec dbo.viewsrowcount - vishal sqlandme.com SQL Server  >  SQL Server Database Engine

i working on ssrs using ssas cube. in dimension dim1, have 3 members abc, pqr, xyz in attribute attri1 need create parameter on attri1 parameter values ‘yes’, ‘no’. if select parameter value yes, in report body abc, pqr, xyz data displayed. if select parameter value no, in report body abc , pqr data displayed. need implement on query parameter. appreciated. regards, ramesh create new dataset following query , use parameter. select distinct paramvalue ( select 'abc' attri1,'yes' paramvalue union all select 'pqr' attri1,'yes' paramvalue union all select 'xyz' attri1,'yes' paramvalue union all select 'abc' attri1,'no' paramvalue union all select 'pqr' attri1,'no' paramvalue ) x regards, rsingh SQL Server  > 

hi,  hopefully easy 1 answer. possible change displayed when silverlight not installed on client's pc. i'd show image ordinarily last view shown in silverlight animation appears more professional. i'd include sort of install link guide user necessary microsoft download page silverlight.  all appreciated.  thanks in advance,  grant silverlight default installation experience designed customized. guide , sample code official microsoft guidance on customizing installation experience http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=961e96e8-9a7f-4b70-947a-97f0973cb38c Silverlight  >  Getting Started with Silverlight

i have downloaded silverlight onto new computer, when try use on artscow.com, says not have it. have same issue on other computer figured older , may wouldn't download on 1 because of remnants of previous download. know can't case because first download on computer other came on computer. said "installation successful" don't know doing wrong.  i don't know doing wrong. not mentioning browser or operating system. . you "install silverlight" picture if silverlight plugin fails load. it's fallback. if you're on windows 10 use internet explorer 11 ( not edge ). can find typing "internet" in search web , windows box , it'll top of list. then follow instructions here: http://social.technet.microsoft.com/wiki/contents/articles/30387.silverlight-troubleshooting-installation.aspx#install_silverlight_when_already_installed and http://social.technet.microsoft.com/wiki/contents/articles/30387.silverlight-troubleshooting-