3,481 Topics
 | |
| | Hey guys, My AV has located a rootkit MBR:\\.\PHYSICALDRIVE0 I have already tried a solution that I found in this forum but it has not worked. basically I have run bootkit_remover.rar and run it. It returned the following: -- [COLOR="Red"]Bootkit Remover (c) 2009 eSage Lab [url]www.esagelab.com[/url] Program version: 1.2.0.0 OS …  |
| | Hello guys, I have two tables with the following structure: TABLE A: Email Address, CampaignID, Source, Unsubscribe Email1,2 Email1,1 Email1,3 Email2,5 TABLE B: Email Address, SeedList, ListName Email1,SeedListA.SeedListA Email1,SeedListB,SeedListB Email2,SeedListC,SeedListC The purpose is to merge the two tables together. But there is a really strange rationale behind this merge. If … |
 | Afternoon All, hope someone can help as this is really doing my head in. I have a SQL View which has a field called MOP/T which shows the number like so 28.5140299679490 349.893390000000 349.893389892905 I want to format that field so that it only shows the number before the decimal … |
| | I have an XLS file. Let's assume that it has 1000 rows in all, with 10 columns. I would like to import rows 5 through 995 (say), and columns 1 though 7 and 10. How can I do this using an SQL query, either though OPENROWSET or BULK INSERT? I …  |
| | Hello All, Can some one help me how to write query for finding the profi per unit using SQL server 2005/2008. I have got a unit table which contains UnitId and Quantity and the other table which contains cost price, selling price and the Unit Id. Thank you  |
| | [CODE] SELECT p.* FROM (SELECT CONVERT(CHAR(10), li.RequestResolutionDate,110) AS DeliveryDate, ISNULL(ity.ItemTypeCode,'N/A') AS 'ItemTypeCode', rc.ResolutionCodeDescription FROM LALocationItemTypeRequest li LEFT JOIN LAItem it ON li.ItemID = it.ItemID LEFT JOIN LAItemType ity ON it.ItemTypeID = ity.ItemTypeID LEFT JOIN LAStop st ON li.StopID = st.StopID LEFT JOIN LALocation lo ON st.LocationID = lo.LocationID LEFT JOIN … |
| | hi , can some one provide me with a tutorial in creating user group in ms sql and assigning users to that group appreciate a lot thanks |
| | Hi to all, I created the following table --------------------------------- create table publisher(name varchar(20), city varchar(20)) --------------------------------- I want to put following constraint, 'name is having unique with city taken only from 'mumbai', 'pune', 'nasik', 'panji''. I know about unique constraints with name. I searched many about constraint with city, but … |
| | Hi, Not sure if my question belongs in an ASP.NET or MSSQL forum.. I have an ASP.NET webpage built in VS2010 with an Input field with the functionality to browse to a network directory, select a text file, read content and upload the data to an MSSQL database table. Nothing … |
| | hi friends, my database names are like that: --name surname date account--- i want to send 5 or more user info send database with form. form.php <input type="text" name="name" size="8" class="auto-style5" style="height: 20px"> <input type="text" name="surname" size="8" class="auto-style5" style="height: 20px"> <input type="text" name="account" size="8" class="auto-style5" style="height: 20px"> <input type="text" name="date" … |
| | Respected Friends Hi I have one table named as 'payroll' with the columns employee_id,employee_name,employee_designation, basicpay,allowances,month,year. This table data as follwoing: employee_id , employee_name, employee_designation, basicpay , allowances , month, year 1 , SAM , MANAGER , 5000 , 1000 , JANUARY , 2011 1 , SAM , MANAGER , 6000 …  |
 | He guys when i execute this stored procedure by right clicking on it and press execute then entering a value for PW i get a NULL value returned any idea why? [CODE]USE [DR2_Member] GO /****** Object: StoredProcedure [dbo].[up_php] Script Date: 02/26/2011 18:26:34 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON … |
 | Hi all, I'm a newbie when it comes to SQL and I have 2 tables that I need to update. Let's say, for argument's sake that the first table (Products) has an identity column (automatically incremented) with the name of ApplicationValueID. It stores a bunch of data about a product …  |
 | Hi everyone, I am getting this error: [CODE]Msg 512, Level 16, State 1, Line 1 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated.[/CODE]please … |
| | hi i have a question in getting values from two table i ave two tables Table1 and Table2. table 1 have data and table 2 may have the same data as table 1 and more. and also table 1 may have the same data and some which is not in … |
| | Hi to all, I create the following table. create table man(id integer, name varchar(20), city varchar(20), age integer) I want the age, maximum age of person. So, I ran following query, select name, max(age) from man group by name; It shows name of all person in ascending order with their …  |
| | I have a table in which i have a column named "dtCreated" which has got datatype as VARCHAR(50) Now I want records between two dates. I wrote my query as written below [CODE] select * from mytable where dtcreated>=fromdate and dtcreated<=todate [/CODE] This query work fine when fromdate and ToDate … |
| | Hi to all, I have nothing idea about how to create relation and solve their queries. I want to relation as follows: ------------------------------------------------------------------- BookAuthor(book, author, earnings) BookReference(book, referenceBook, times) BookReview(book, reviewer, score) BookPublih(book, year, publisher, price, numbar) In these database, each book may have 1 or more authors & each … |
| | Hi to all, I created the following two table -------------------------------------- create table mail(mid integer primary key, name varchar(20) ) create table phone( pid integer foreign key references mail(email), phone integer) ----------------------------------------- After inserting records on both table, now i want delete perticular record from table say 'delete record of pid=12'. … |
| | I am receiving an error 'Incorrect syntax near the keyword in Any ideas? [CODE] declare @item varchar(100) declare @stopid varchar(100) set @item in (select itemtypeid from laitemtype where itemtypeid like '88BBA7AD-BD25-E011-94E0-001B214A75A5') set @stopid in (select stopid from lastop where stoptypeid like '7D14FC8C-B184-DD11-9BCC-0014221E87F0') insert into lalocationitemtyperequest (itemtypeid,requestprocesseddate,createddate, stopid) values (@item,getDate(),getDate(),@stopid) [/CODE] |
| | [B]hi guyz..! i want to know da process the to configure sql server on client pc..using odbc...i have install sql server 2000 advance server on windows xp platfrm... i m trying to configuraing frm so long ...bt m failed..! kindly help me regards[/B] |
| | Could I select a datetime record using date only? I need to show rows containing a particular date. I'm thinking to separate it into two column instead if I couldn't select only date from a datetime. |
| | I'm making a fairly easy to edit and change public dictionary and am working on the viewer hooked to an SQL server. The problem I'm having is, isn't really a problem but I'm looking for a better solution, due to it possibly devolving into a huge mess of sorting a … |
| | Hi to all, I created following table ------------------------------------------------------------------- create table interiors(id integer, name varchar(20), type varchar(20) default 'baby cot', price integer) -------------------------------------------------------------------- but, when i doesn't inserted any value of 'type', by the definition of table, it should take default value. when i fetch all rows by 'select' query, it … |
| | How to select records with today's event? I have a column that is set to smalldatetime. I need to select those that have a row of today's event. |
| | Hi.. I want to take the max value of the substring of a varchar field having values as SN1,SN2....SN10.I used the query as following [CODE]select max(substring(st_no,3,4)) from tbl_st;[/CODE] I am getting the max value as 9.I want to get 10. If somebody knows please help me |
| | Hi to all, I created following table --------------------------------------------------------------------------- create table Interiors(no integer, name varchar, type varchar, dateofstock datetime, price decimal(6,3), discount numeric(6,2)) ----------------------------------------------------------------------------- i want to solve these two queries. 1. Display the type, sum of price and average of discount by grouping type as 'baby cot'. 2. Display the … |
| | Hi to all, i created following table ------------------------------------- create table employee(name varchar(20), dob datetime) ------------------------------------- I want to extract names of all months from 'dob'. for that i wrote following query ------------------------------------- select datepart(month, dob) from employee -------------------------------------- it works and shows all months but in number format, i want … |
| | Hi, am SQL beginner, now i trying to code student marks management so i came across to db i was confused. Please give idea to create such thing, i have students, mark tables as per the semester. then how i place the information according to register number. so that how … |
| | How do you replace characters as in an update? Example I have an address field that contains '.' and '-' and I need to remove these characters. Anyone know of an update script to do so? |
| | hey guys i get this error when trying to execute a stored procedure in my SQl DB [CODE] Warning: mssql_query() [function.mssql-query]: message: SELECT failed because the following SET options have incorrect settings: 'CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS, ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed … |
| | I need help troubleshooting a performance issue. I have a stored procedure that is selecting from 3 joined tables, and is hanging on the first time this procedure is running. Sometimes hanging so long that I get a timeout error. After the first run, it's faster, but still takes longer … |
| | Hi my problem is that so I can't add new data to database. I wrote procedure in mssql 2008 and now i don't now how coneecting this with asp.net [code] Create procedure [dbo].[addData] @name nvarchar(50), @telephone int, @place nvarchar(50), @street nvarchar(50) AS Declare @person_id int, @place_id int BEGIN if not … |
| | Hello there i am having trouble on how to compare the password of the input and the one in the DB since the one in the DB is encrypted with the code below for registration i just used a stored procedure in the db and called it in the php … |
| | Sum of One and not the Other I have a requirement to query one figure and the sum of another. What I need is one query to produce the MonthPayment for each CompanyID for a given ContractID and the Sum of TotalPayment with matching CompanyID and ParentCompanyID for each CompanyID … |
| | I know sql provides us with LTRIM and RTRIM but is there anyway to remove the spacing in the middle. '123 Johnson St' should be '123 Johnson St. Anyone know of any functions or tricks? |
| | hello all, I have database named 'Marketing', and want to bound DropDownList control with it using 'add connection' dialog box in the C#.net. I gave datasource: 'Microsoft SQL Server Database File (SqlClient)'. And when I give DataBase file name as 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\Marketing_Data.MDF', I get error while testing the … |
| | MS SQL 5 vb.net asp.net I working on a new site that requires me to show a page with a single product and it's information. I have a Next and previous button that will take the user to the next item in that category / subcategory. basic Querey to show … |
| | Does anyone know if it is possible to modify the maintenance plans through t-sql and if so please provide the code to do so. THANKS! |
 | Hi, I am experiencing some abnormal application behavior. I wrote an application in C# that does hourly database , as well as directory backups. Its constructed in a way that all settings are saved in XML file. and once the user allows the application to start doing the scheduled backups, … |
| | I found this script online for full DB backups but I was wondering how to change this to also set differential backups? [CODE]DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName VARCHAR(256) -- filename for backup DECLARE @fileDate VARCHAR(20) -- used for file … |
| | Hello, I have a table of many rows, and some rows have a connection to other rows. A simplified example of the table I am trying explain is below. ID MYVar LinkedToMYVar 1 10 0 2 20 0 3 30 10 4 40 0 5 50 10 6 60 30 … |
| | Hi Friends, i ve a doubt in sql.. want to display all dates between 2 dates.. for example if our input are 9/2/2011 and 12/2/2011 na, the output are 10/2/2011 11/2/2011 .. i need query for this..can u clear my doubts.. |
| | I have a table that contains ID, lastname and firstname of a person. How to make my stored procedure handle the where conditions using only stored procedure. SELECT * FROM person where lastname = @lastname SELECT * FROM person where firstname = @firstname SELECT * FROM person where ID = … |
 | Hi, It appears that the code tags in the MSSQL forum aren't working today. Example: [URL="http://www.daniweb.com/forums/thread348193.html"]this thread[/URL]. |
| | G'day Folks. This is a general question and not a request for code. I have a client with many DTS packages on their sql server 2000. Has anyone had to migrate these buggers to sql server 2005 or 2008? Was it difficult? - After substantial googling/searching I'm not sure I … |
| | MyTable: People who moved from Blah City, Blah State: Name Location Date Kids Jack LA 02/05/1999 0 Cindy Chicago 12/15/2005 2 Randy LA 06/19/2003 3 Jason Seattle 04/06/2002 0 1. Who moved to LA? [CODE] SELECT Name, Location FROM MyTable ORDER BY Location; [/CODE] Expected result: LA Jack, Randy What … |
 | Hi Everyone, I have a table that has a 2 column primary key. I set up the key where the 2nd column is an identity column. When I ran my VB application I discovered the ID (2nd column) did not increment the correct way. I was hoping it would increment … |
| | Hi! I need to be able to change the location of the database at runtime through a menu in my program. My question is how to best achieve this. If for example the ip to the server change, the user need to be able to update the database path; i.e. … |
| | Good day, i am creating a component, with an enum property for the property grid. [CODE] // The DataSources enumeration. public enum DataSources { MSSQL = 0, MYSQL = 1, POSTGRESQL = 2, ORACLE = 3, DSN = 4, EXCEL = 5, ACCESS = 6, } private DataSources m_DataSources; /// … |
The End.