i have one table sql server like below , from that table i want to get quesno, field name[what are the field have value] QuesNo A B C D 1 1 0 1 0 2 0 0 0 1 Output : QuesNo Result 1 A,C 2 D Is there any possible ways to get outpu? ...
I have a requirement to identify keywords stored in a table column in text passed to a stord procedure, at present I'm pasing the text in as rows in a table value, however as populating the table value is hideously slow, I'm going to scrap this approach. I looked at the full text search option, however based on my very limited understand...
I have 10 columns in a table and i need to alter the datatypes of that columns so how should i go with it i had tried for this - ALTER TABLE tblcommodityOHLC alter column CC_CommodityContractID NUMERIC(18,0) ,CM_CommodityID NUMERIC(18,0) for single is fine - ALTER TABLE tblcommodityOHLC alter column CC_CommodityContractID NUMERI...
Hi, Can anybody recommend good front end SQL server development pivot table components? Other than the Microsoft Office offers. Something intuitive and web based. Thanks for your time Paul ...
Hi all, I have a table Orders with (id,orderCode,productId,quantity,color,size) where I can have entries like: 1,O20100812,163,2,BLUE,Medium 1,O20100812,163,3,BLUE,Larger 1,O20100812,145,4,RED,Large etc 1,O20100815,134,5,RED,Large etc 1,O20100815,143,2,BLACK,Large etc 1,O20100815,112,8,BLACK,Large etc And another table Products with ...
Hi I would like to rotate a full table: LANGUAGE litAccept litDelete litErrorMsg .............. ------------------------------------------------- SPANISH Accept Delete Error has ocurred ENGLISH Aceptar Borrar Ha ocurrido un error ..... into something like this: LANGUAGE ENGLISH SPANISH ----------------------------...
Hi, I need to load and execute SSIS or DTS packages ASYNCHRONOUSLY from ASP.NET C# page on click of a button and report the success or failure at the end of the execution and if it fails the details of the exception should be shown to the user. it needs to be asynchronous because job could take a long time to finish. user should also ...
Table Structure ID DESC PARENT_ID** 35151 Parent 35154 35152 System 35151 35153 Same as System 35151 35154 ParentsParent 35157 35156 Product 35157 35157 Login Group 35159 Where Id is the primary key, and parent_id is the foreign key referenced in the sa...
Hi everyone, I want to know if there is a way to convert an MSAccess DataBase to a SQL Server database without starting from the beginning. Thanks ...
I understand that an Isolation level of Serializable is the most restrictive of all isolation levels. I'm curious though what sort of applications would require this level of isolation, or when I should consider using it? Thanks very much. ...
I have a table in SQL Server 2005 database that has following columns: Id,ProductName,Year,Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec What I need to do is to calculate an average ROLLING value for a product. For instance, if product named "Car" has 2 rows in a table(Year 2009 and 2010) I want to calculate average values from Aug...
I want to fetch all the columns except one column,Can anybody help me how I can get the result except write all the column name,because it is good for less number of columns but if the table have more than 100 column then it will be very lengthy....... ...
I have a new Visual Studio 2008 Database Project (Data Dude). It was generated by pointing at our existing database. I have now made a few changes (new columns, tables, indexes, etc) and I am trying to generate the deployment (diff) script for deployment. I have a Schema Comparison setup to do the comparison and generate the diff scri...
Hi, One of our customers does not want to put the default instance name "MSSQLSERVER" in the connection string. Unfortunately the dba has not replied to any of my emails inquiring what the problem is? Any reasons why this would cause an issue? JD ...
how can i use FREETEXT in sqlserver 2008? i have search problem? Its like a monster jobs search in key words please send me reply thank you ...
I'm looking at SQLServer replication. When I replicate, obviously the entire database can be replicated. However, is it possible to limit the replication to a specific set of tables or schemas? Thanks! ...
i'm using vb 2008 and local database sql server compact 3.5 to build a application. the problem is that i can't insert a new data to the database from the app. i'm wrote the query right at dataset and using table adapter. but when i call the query, it succeed but the data don't exist at database. for example: at table adapter, i made Add...
The following is a simplied version of a query that a reporting tool is sending to our database. I have never seen this syntax before in the Where clause. Can someone tell me what the brackets are doing? And, I assume the 'd' acts as a date cast? Select ch.ContainerID, ch.WorkItemHistoryEventTypeEnumID, ch.EventTime, ch...
I have 2 tables Jobs and Schedule Jobs JobId - int,PK, Identity ScheduleId - int, FK Title - varchar Description - varchar Schedules ScheduleId - int,PK, Identity Name - varchar There is a relationship one to many with cascade on delete. When I create Entity model, the generated Jobs model removes the ScheduleId field. Th...
I have a dynamic set of data X of the form: ---------------------------------- x.id | x.allocated | x.unallocated ---------------------------------- foo | 2 | 0 bar | 1 | 2 ---------------------------------- And I need to get to a result of Y (order is unimportant): ---------------------------------- y.id | y.st...