3,481 Topics
 | |
 | how do i create service accounts for the various SQL Server 2008 components?  |
| | hi everyone i have to 4 table and two different database ----------------------- first db = rotadb first table =Rota rota pRotabos ldchangetime 101 6 NULL 102 7 NULL 103 8 NULL 104 9 NULL 105 10 NULL ------- second table = Rotabos Rotabos_rowid pRotaBa 6 1 7 2 8 3 … |
 | Hello! I have a query regarding Merge Replication. I have 5 Tables. 1. SetYarnMain Fields (MainId(PK), MainName, Comments) 2. SetYarnSub (SubId(PK), SubName, MainId(FK), Comments) 3. SetYarnDet (DetId(PK), DetName,SubId(FK),MainId(FK), Comments) 4. SetYarnGrp (GrpId(PK), GrpName, DetId(FK),SubId(FK),MainId(FK), Comments) 5. SetYarn (YarnId(PK),YarnName,GrpId(FK),DetId(FK),SubId(FK),MainId(FK),Comments) **These Tables doesnt have Identity Column** Lets take 2 tables SetYarnMain and … |
| | Firstly, Hello, The purpose of this post is to get some advice/recommendations from some other developers on what path to pursue next to progress and improve. I am trying to decide what programming language to learn next, and currently im edging towards C++ but considering some dialect of LISP maybe … |
| | hello all! I have this SQL code that I am supposed to write and am worried that my code may be wrong. I am fairly confident that the first 2 questions are correct but after that......who knows! I have attached an ER diagram( which is acutally really messed up...but whatever) …  |
| | I need to have a text field in a search form that pulls from our DB, to default to uppercase for the search. I tried to use java script in the html part of the form for that field but it bombs out after you submit the search. Here is …  |
| | Hi, I'm trying to create a form in which a user selects a Customer from a Combo box and then can select a "Dongle" (or Product they have) from a list box. Below is a screen shot of the relationship between the tables.  Also here is a screen … |
| | Dear All, I am beginners in MS Sql, now I have three tables (Companies, Product, SaleBody). and their fields are (CompanyId, CompanyName), (ProductId, ProductName, CompanyId, PurchaseSTPrice, TradePrice), (SerialNo, SaleId, ProductId, Quantity, Price, TotalPrice).............. I want to create Report in which I want (companies.CompanyName, product.ProductName, product.TradePrice, salbody.TotalPrice) How can I get …  |
| | Hi, On executing CROSS APPLY Clause using UDF: create function Reg(@pc int,@pp varchar(15)) Returns Table As Return select cr from crt where piod=@pc and cr=@pp Go select distinct a.cr from cdet AS a CROSS APPLY Reg(a.cr,a.piod) AS a where a.piod='208'** Am getting this following errors: Incorrect Syntax near '-'. Thanks. |
| | Ahoy, I'm having a bit of trouble executing a stored procedure using PHP's SQLSRV package thing. It's pretty much just a simple select query, with the parameters being passed through a php (it's from a property search). SqlSrv is a tough nut to crack as docuemtnation is either non existent, … |
 | hello! i am working on a client and server application , i want to connect my server with my client application to perform some database transactions.i think it is very simple to connect a client with the server , but here is the point , i have two pc , …  |
| | I am Sameer Shah. I am a young coder born and educated in Mumbai, India and now working in New York, US. Coding has been my passion since I was 14. I like coding in C#,C++,C. At my workplace, I develop applications software much of it using MICROSOFT.NET C# and … |
| | Guys, I have a select statement ere one of the field has a negative value. How do i convert it into zero in select statement. ;with CTE as ( Select Itemid ,AVAILORDERED as OnHandQty - just want to convert some negative result into 0 From MyTable ) Select * from …  |
| | Hello everyone! I am trying create some table for ticket escalations.Escalation have more than 5 levels.. There is two table example: table_escalation id serviceId ownerId table_level id escalationId levelId currentUserId userLevelId I need advice: if this good structure. |
| | hi, how to create nested table in sql server for example employee table contains 3 column id name address where name should contain 3 sub columns like firstname middlename lastname how can i get this one help me plz |
| | |
| | I need some help updating data in my table based on data in the supply chain group's table This is how the table looks on their side ##Table Name: ProductSC## ID Code Description Status 1 N461579 Phone Available 2 N836257 Headset1 Discontinued 3 N836258 Headset2 Available 4 N748956 Adapter Available … |
| | I am newbie in sql server i'm using sql server 2005 and the northwind database i wanted to join order and order details tables and calculate the total purchase made by each customer by using group by clause. When i used select orders.orderid,orders.customerid,orders.orderdate,orders.shipcity,orders.shipcountry, orderdetails.unitprice,orderdetails.quantity,(orderdetails.unitprice*orderdetails.quantity )as total from orders inner join … |
| | I have a table 'Asset' with a column 'AssetDescription'. Every row of it has some group of words/sentences, seprated by comma. row1: - flowers, full color, female, Trend row2:- baby smelling flowers, heart Now if I put a search query like:- `select * from Asset where contains(AssetDescription,'flower')` It returns nothing. … |
| | hello ! how are you all , hope all of you are in great state of health and peace , well i have some questions , 1- WHAT IS MSSQL TRANSACTIONS . 2- where we use it. 3- Advantages /Disadvantages 4- Any imp information or point which you think it … |
| | Hi, Am having, some doubt, please clarify this? [CODE] 1. Using Import/Export wizard, can i able to import the excel data into the temporary table ? How ?[/CODE] 2. The following TSQL is working fine. Can i able to do this, from the CLIENT Machine itself. I don't want to … |
| | Hi i am making a stored procedure with multiple select statements when i execute them than different resultset are maken for each select statement all i need is to get one resultset from all select statements of sql quries in the stored procedure......HERE is the SP code..[CODE]SET NOCOUNT ON; Select … |
| | Hi, Trying this Query, [CODE][B]DECLARE @SR VARCHAR(8),@SC CHAR(15),@ST CHAR(15),@SNO int; SELECT * FROM (SELECT DISTINCT ROW_NUMBER() OVER (ORDER BY a.rno) AS rowid, @SR=a.rno,@SC=a.kat, @ST=a.type FROM SMas a, SDet b WHERE b.id='X' AND a.rno=b.rno) AS C WHERE C.rowid=4 [/B][/CODE] but getting this following error: [CODE][B][I][U]Msg 102, Level 15, State 1, Line … |
| | Hi, I am trying to create a stored procedure to add a new column into a database from an ASP web application. The SQL Code for this is:- [code] ALTER TABLE tablename ADD COLUMN columnname columndatatype [/code] I have tried to insert this SQL into a stored procedure:- [code] CREATE … |
 | Any tips on how to connect them? COmments are highly appreciated. Thanks! |
| | hello! i have shifted my application from mssql server 2000 to mssql server 2005 , now the prob is the command object is not returning the recordset if command text is stored procedure , here is my code please check it and guide me through errors . [ICODE] dim cmdsp … |
| | Basically I have a trigger that is fired off whenever a workorder is reopened to close it again. The trigger works perfectly but I want to track the workorders where there is an attempt to reopen it. so basically if workorderid 8 is attempted to open again I want to … |
| | i have two tables in my sql database one is "vendor" and other "purchase_order" they both have one common attribute "vendor_name" my problem is that i want vendor name in my "purchase_order" table to be same as that in "vendor" table but vendor_name is not a primary key in "vendor" … |
| | I'm trying to create a webpage that will allow the user to input a vendor number(text box) and if the number exists populate the form with vendor name, phone and state using a stored procedures. Below you will find the stored procedures and after it my webpage. Stored Procedures: SELECT … |
| | I have to create a stored procedure that will view data from a table. The user will audit the data, with paid dates. The user comes back to the view report, check/select all lines that have the same paid dates to change. The user will enter the paid date, then … |
| | Hi Friends!! I am coming across this problem that whenever I am trying to retrieve the data in a dataset Through database, it is taking around 10 min to get the data no the localhost. And when I am running the same code on the live server it doesnot take … |
| | My sms gateway save message data in log(MSSQL) in Hex code, like this: 0046003A0062006F006B0040007700650062006D0065006400690061002E0070006C These are Unicode message (16 bits per characters) Each 4 characters is AsciiHex representation of a character (in hex): For example: “0046” = 46hex = ‘F’ “003A” = 3Ahex = ‘:’ how can I convert this … |
| | Hi, How do I design a table column named UpdateDate that will give the default date and time upon inserting a record into the table I'm using Enterprise Manager in MSSQL Many Thanks |
| | i have a combobox i want to show all the student name in it , i am using mssql database , and when we select student a textbox will show the rollno of that student , please help me |
 | Hi all, SQL definitely is not my area of expertise, so I need help with something. Suppose I have 3 tables (I'll try and keep this is as simple as possible): - User (with UserID). There are 13,000 records - Status (StatusID as the PK). There are 10 records - … |
| | I have developed following web service in vs2008 but cannot resolve th following error System.Data.SqlClient.SqlException: Arithmetic overflow error converting varchar to data type numeric. here is my web service code using System; using System.Linq; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Xml.Linq; using System.Data.SqlClient; using System.Data; using System.Configuration; [WebService(Namespace = … |
| | I have made a web service to insert product details the web method is as follows [code] using System; using System.Linq; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Xml.Linq; using System.Data.SqlClient; using System.Data; using System.Configuration; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] // …  |
| | is it possible to create a view with a primary key.. if so... how can i do that using a query of t sql.. anyone.. help..:?: |
| | Hello, I have a table with clients: id, name, email and the likes I am looking to find all ID's where emails are the same, I tried the following [code]select db_email, db_medlem, count(*) from kunder group by db_email HAVING count(*) > 1;[/code] however this generates an error due to not … |
| | How can I ensure that the stored procedure below is able to use either one or all the parameters to filter records from a table? CREATE PROCEDURE ABC @StartDate datetime = null, @EndDate datetime = null, @UserId varchar(255) = null, @AccNo varchar(255) = null AS BEGIN IF @StartDate IS NULL … |
 | will someone help me on how to solve this error? The database 'D:\FEB. 29, 2012\WAIS SYSTEM-UPDATED JAN25\WAIS SYSTEM\BIN\DEBUG\WAIS.MDF' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported. Could not open new database 'D:\FEB. 29, 2012\WAIS SYSTEM-UPDATED JAN25\WAIS SYSTEM\BIN\DEBUG\WAIS.MDF'. … |
| | hi everyone, I wish to share the mdf file on the network so that other computers can use the file to capture or retrieve the data. Is there any way I can do this on MS SQL SERVER 2005? |
| | Below dynamic query will set StartDate and EndDate to 1st of March to 30th April as UK financial year. DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 … |
 | Hello Guys, I am trying to get the data from two columns of two different tables using Join as combining them as a whole to insert into dropdownlist... The situation is like this: There are two tables named tblPropertyCategory and tblPropertySubCategory.. I have PCName in tblPropertyCategory and PSCName in tblPropertySubCategory.. … |
| | Well, when almost finishing this tutorial: [INDENT][/INDENT][url]http://msdn.microsoft.com/en-us/library/ff677562.aspx[/url] I found a problem on connecting the Add-in to the database, and so the lobInstance can´t be opened: [url]http://i.stack.imgur.com/AFzie.png[/url] This is the error code. (in fact the error message was being popped out when the Excel 2010 client starts, but I commented the … |
| | Hello, I am new to the hijakthis community... can you please help me with my computer? It is really slow and I think there may be a virus in it. Thank you! Here is my log: Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\Program Files\Intel\Wireless\Bin\EvtEng.exe C:\Program Files\Intel\Wireless\Bin\S24EvMon.exe C:\WINDOWS\Explorer.EXE C:\WINDOWS\system32\spoolsv.exe … |
| | Hi, I recieve the following error message: "java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression'name '" when I run this statement: [CODE] sql = "INSERT INTO empDetail VALUES("; sql += txtName.getText()+ ", "; sql += "'" + txtAddress.getText()+ "', "; sql += "'" + txtSuburb.getText()+ "', … |
| | I know this has been asked many times before so I apologize but here's the php file that's generating the error on the "if($stmt = $this->conn->prepare($query))" line: [CODE]<?php require_once 'includes/constants.php'; class Mssql { private $conn; function __construct() { $dbServer = DB_SERVER; $dbName = DB_NAME; $conn = new PDO( "sqlsrv:Server=$dbServer;Database=$dbName", NULL, … |
 | this is my query for displaying monthly business [CODE]select convert(varchar,dateadd(month,datediff(month,0,inv_date),0),101) as 'months with date format', sum(inv_amount) as 'business' from invoices inner join customers on customers.cust_id =invoices.cust_id where fname+' '+lname='lala fazlani' group by customers.cust_id,dateadd(month,datediff(month,0,inv_date),0) order by customers.cust_id,dateadd(month,datediff(month,0,inv_date),0) [/CODE] So when I execute this command, It gives me this result [url]http://img821.imageshack.us/img821/6492/sqle.jpg[/url] [url]http://img341.imageshack.us/img341/538/chartv.jpg[/url] … |
| | Hi everyone, ALTER TABLE preventiveRecord ADD Verifiedbymanager BIT NOT NULL CONSTRAINT preventive_verify DEFAULT 0 WITH VALUES ALTER TABLE preventiveRecord ADD Verifiedbysupervisor BIT NOT NULL CONSTRAINT preventive_verify DEFAULT 0 WITH VALUES SELECT [ID] ,[Date_Done] ,[Date_Due] ,[SME] ,[Status] ,[History_ID] ,[Remark] ,[Verifiedbysupervisor] ,[Verifiedbymanager] FROM [demo].[dbo].[preventiveRecord] Here is my query : from d in …  |
The End.