.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Create view

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
I need to create aview like this. Field1        Field2 James         Here it will be a SELECT from various tables where name='James' Helen          Here it will ............................................    where name='Helen' How to create this view.  Field1 is also from some table. NSG12

View Complete Post

More Related Resource Links

How to create scrolling table for columns in a SharePoint Designer Data View


I have a fairly complex SharePoint Designer 2007 Data View they have added two more requirements.

1. Have the columns on the right side be able to scroll left to right as there is a large number of columns, while the first 3 columns on the left side stay locked in place.  This is only one list not two, and because of some other requirements I have it must remain to be just one list.

2. Then they also need to have scrolling up and down of the entire list with the headers locked in place.

The first requirement is more important than the second, but preferrably I need to do both.

I am new to XSL so not familar with the syntax. Is this something I can do on a custom Data View? Does anyone have any examples of how?

I have a drawing that show how it needs to look but I don't see an option here to upload a graphic.

So here is a link to my graphic example uploaded to my blog area: http://lindachapman.blogspot.com/  or just the image here: http://4.bp.blogspot.com/_aB01ue__NvQ/TGL42MOvrGI/AAAAAAAAAA4/c3xP4uCy4BU/s1600/Scrolling.png

I failed to mention that 3/4 of the columns are HTML Calculated fields wh

create a dynamic view on code

How i can create a new view on code (on runtime) if this view dont exits?   Thanks

How to create a view in my database from a table in another server/database

Is there a way to create a view in my database referencing a table in another server/database if I have the connection information.  I know how to do it in Oracle, simply create a database link, but have never done so in sqlserver.

how to create jquery tree view

A Simple Query Pass to connection String 1 My Query is SELECT a.HD, a.HEAD, a.SH, a.SUBHEAD, a.TRK, a.TRACK, a.TGT, a.TARGET, a.PDC, a.DT_RELEASE, a.STATUS, a.COFROM V_HIERARCHY1 a2,My Data isHD    HEAD    SH    SUBHEAD    TRK    TRACK    TGT    TARGET    PDC    DT_RELEASE    STATUS    COHR    HR    Rec    Records    Leave    Leave Records    HRL.0002    Quarterly Review    01.07.2010    04.07.2010    Planned    EdlinkHR    HR1    DB    Database    SAL    Salary    DDS.0001    Calculation of Monthly salary    08.08.2010    09.08.2010    WIP    EdlinkHR    HR    Rec    Records    Ind    Induction Records    HRI.0001    Completion of dossiers.    08.07.2010    10.07.2010    WIP    EdlinkHR    HR    DB &

cannot create an index on a view

Hi All, Can I create an index on the following view? Create view myview with schemabidning as select id, date, value from tablea a right join (select id,min (date) as mindate, value from tablea ) b on a.id = b.id and a.date = b.mindate GO CREATE UNIQUE CLUSTERED INDEX IDX_1 ON MYVIEW(ID)     Right now i am getting an error.   Cannot create index on view "myview" because it references derived table "B" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view. shamen

Create a new list View Style

Hi, In SharePoint 2010 for XSLT List View Web Part you can assign different view styles using SharePoint Designer. For example "Basic Table", "Boxed" or "Shaded" etc. These styles just don't fit my needs. So my question is how can I create my own View Style which I can apply to any list? I came across "Customize XSLT > Customize Entire View" option under Design tab in SharePoint Designer which allows me to change the XSL stylesheet and control the rendering for a list. But how can I create my own list "View Style" which I would like to reuse with other lists too? Thanks, Hitesh  

How to create SQL-login with permissions for view-only SQL-Agent-Jobs?

Could you please help me with resolving next problem: How to create SQL-login with permissions for view -only SQL-Agent-Jobs (he cannot create, modify or delete)? I am using MS-SQL-Server version: 8.00.194 In other words : how to create in version 2000 (8.00.194) the same as 'SQLAgentReaderRole ' in version 2005 (for more details see http://technet.microsoft.com/en-us/library/ms188283.aspx).

i have a XML File how to create a Tree View and how to get & post xml to cgi

<?xml version="1.0"?><Hierarchy>  <HD id="Acct">    <SH id="Books">      <TRK id="Annual">        <TGT id="ABA.0001">Closure of accounts for 2009-10</TGT>      </TRK>      <TRK id="Monthly">        <TGT id="ABM.0003">Finalization of expense accounts for Jun</TGT>      </TRK>    </SH>  </HD>  <HD id="Admin">    <SH id="GH">      <TRK id="Eqpt">        <TGT id="AGE.0001">Shifting of BSNL Landline.</TGT>      </TRK>    </SH>    <SH id="Offc">      <TRK id="Eqpt">        <TGT id="AOE.0002">Routine Maintenance</TGT>        <TGT id="AOE.0003">Electrical Eqpt Procedures</TGT>      </TRK>     

speed Performane i create a web site but it very slow run i use tree view and grid view

speed Performane i create a web site but it very slow run i use tree view and grid view but i do it run very fast

how to create a Tree View using passing one sql query

(1)  SELECT a.HD, a.HEAD, a.SH, a.SUBHEAD, a.TRK, a.TRACK, a.TGT, a.TARGET, a.PDC, a.DT_RELEASE, a.STATUS, a.CO  FROM V_HIERARCHY1 a(2) and Data isHR    HR    Rec    Records    Leave    Leave Records    HRL.0001    Policy and Process for leave record.    27.06.2010    30.06.2010    WIP    EdlinkHR    HR    Rec    Records    Leave    Leave Records    HRL.0002    Quarterly Review    01.07.2010    04.07.2010    Planned    EdlinkHR    HR    DB    Database    SAL    Salary    DDS.0001    Calculation of Monthly salary    08.08.2010    09.08.2010    WIP    EdlinkHR    HR    Rec    Records    Ind    Induction Records    HRI.0001    Completion of dossiers.    08.07.2010    10.07.2010    WIP    EdlinkHR    HR &

How to create a custom view in SharePoint 2010?

I can't find a good answer for this with the 15 minutes of searching I have done. Makes me think that there might be some roadblocks here.  I want to create a custom view for a list in sharepoint. Basically, I want to conditionally apply some custom table row formatting based on a value of a column in that row  conditionally add an image along with a text in a column (again based on a column value) I am thinking that a custom view is the way to go...any direction on this? maybe a link to a good example? Thanks, Jake.

Create view that amins to tables of another database on the same sql server instance

Hi to everybody, I found a situation ever met before. I develop on Dynamics NAV 5.01 and I have developed a method to be able to see some particular tables of an external database. In substance it deals with a property of tables of Dynamics NAV. When I create a table in NAV, I can create it in 3 different ways: table common to all the companies table  for company or table linked to a view.    This last case is mine, on the same db of NAV I have created a view with some fields, I have created in NAV a table linked with equal fields and types. Until here all normal.    The view, however, aims to another database that doesn't center anything with NAV but that it is on the same intance of SQL server.    The consumer that accesses NAV is a consumer type database SQL Server and has the permitted db_public and db_datareader on both the database. Then he can read the views on the db of nav both on the db of the other database.    When it tries to enter from the console of sql server, with the consumer database, all it works, if I do it by NAV, it show me an error "The server principal "username" is not able to access the database "some_database_name" under the current security context. (Microsoft SQL Server, Error: 916) "    If I add on the database NAV to the consumer, the role db_owner,

Unable to create index for view

Hi, I'm including the script for my ProductCategories table but I think it might be very beneficial for you to understand what I'm doing first: As the name implies, the ProducttCategories table is where I store all product categories for an ecommerce site. Furthermore, the CategoryHierarchy column uses the HierarchyID datatype in SQL Server 2008 so that I can have a hierarchy and make suggestions to users who are looking for a product in a category along with all its child categories. Also, in order to make the site as user friendly as possible, I've implemented friendly URLs. Therefore, I need to do a reverse look up when someone requests: Electronics-DigitalCameras-DigitalSLRs to figure out the CategoryID (int) for the Digital SLR's category. I wanted to create an index in the database to make sure these look ups would have pretty good performance and that's where I got stuck. First, I got a message that told me that I couldn't create an index because my view was not bound to schema. And when I tried to do that, I got another error saying "Cannot schema bind view 'dbo.vwProductCategoriesAndPathsOrdered2' because name 'ProductCategories' is invalid for schema binding. Names must be in two-part format and an object cannot reference itself." The view simply creates a category path that looks like this: Electronics > Digital Cameras > Digital SLRs I'd

How to avoid "'CREATE VIEW' must be the first statement in a query batch" when I need to use SET Q

I have a problem that I have been unable to solve.  I have a stored procedure in a database on server A that needs to create an indexed view in a database on server B.  (The environment is SQL Server 2005.)  The procedure on server A does the following:  (The EXEC statement inside the quotes is really a variable in my procedure, I've just substituted the value to make the example understandable.) EXEC sp_executesql 'EXEC [ServerB].[Database].dbo.sp_executesql @sqlStatement;' The "outer" sp_executesql causes the "inner" sp_executesql to be execute within the database on server B.  (@sqlStatement contains the CREATE VIEW syntax.)  I am able to create the view that I want to index with no problem.  However, when I attempt to create an index on the view in a subsequent step, it fails with the message "Cannot create index. Object '_dta_mv_51' was created with the following SET options off: 'QUOTED_IDENTIFIER'".  Fair enough, but if I attempt to precede my CREATE VIEW statement with the required QUOTED_IDENTIFIER, I receive an error to the effect that "'CREATE VIEW' must be the first statement in a query batch".  I'm not sure how to get around this problem.  Does anyone have the answer? SQL Server 2008 doesn't object to indexing a view that was created with QUOTED_IDENTIFIER

How to Create a Tab View in sharepoint page

Hi All, I want to create 5 tabs in sharepoint page please tell me how can I do that and what controls I must use? see the sample example here: http://www.transport.govt.nz/   thanking you

Report Builder 3.0 issue - can view existing rdl files but cannot create new reports

I have Report Builder 3.0 deployed on my local machine pointing to a remote SQL Server 2008 R2 instance outside of my local domain.  Within this local Report Builder 3.0 instance I am able to open up previously created rdl files from the remote SQL Server 2008 R2 instance that I am connecting to.  However, if I try to create a new report on my local instance of Report Builder 3.0 and attempt to use the same data source as was used to create these existing rdl files, I receive the error: "Unable to connect to data source. The user credentials provided in the connection string do not have permission to connect to Reporting Services."  So why can I open existing rdl files from this remote SQL Server 2008 R2 instance, but not create new ones even though I'm using the same data source as the existing rdl files?  Thanks, Mark

how to create database tree view using jquery


how to create database tree view using jquery

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend