3,481 Topics
 | |
| | Hi there, Im working on a web database application and Im encountering problems to connect the database and the ASP.net page. The database is being detected but not the tables inside the database. Could anybody help me? |
| | As an IT placement student I have reached the end of a 3 month project for the company I work for. I have migrated information to MSSQL server 2008 edition and I am retrieving the information for dynamic web page display using php. Now that I have everything in the …  |
| | Guys, I have 2 tables. My objective is to get the information from Table1 and place it to table2. the 2 tables have the same Itemnumber and DefectCode. How could make this in correct scripts cause when i make the script it triple the records. [CODE] TABLE1 ItemNumber---------Price---PO-------Code-Qty P300-1710-DROID-U--302.05--9100962--506--1 P300-1710-DROID-U--302.05--9100962--553--4 … |
| | hi, i have one chat project. i m totally noob in that. in that server and client scripts... how can i test or run in my browser. i use vs2010 and mssql 2008. please help me.. thanks in advance jack |
| | how to create stored procedure for altering multiple coulmns , how to create stored for creating dynamic table and add multiple columns to created table |
| | Hi there, I am a newbie to MSSQL. I apologise first as I know that my question might have been asked by others elsewhere but unfortunately I couldn't find it. I will really appreciate if someone can shed some light into my question. I have two tables with the following … |
| | hi, i have an application that feeds data into a table of a database - table name is XTABLE716C6DC3. now i need a stored procedure that takes and calculates data from that dable anytime the table is changed and store the results in a certain format into a new table …  |
| | hi everyone they said in relational database there is no "last" concept.. and the only way to retrieve the last data entered in database is by IDENTITY and sone says TIMESTAMP... which one i would prefer to use? |
| | can anyone tell me how to insert { in sql. Eg. insert into dm_dbo.prsn_ps_epm(product_id,imprint_name) values('123456','nisheeth{jain');  |
| | Hi All, I have a SQL database which has many views and needs indexing. Unfortunately SQL server does not let me add indexes with schema bind error. There are app. 50 views created on the database and I don't want to delete and re-create them one by one. Is there …  |
| | What is the difference between oracle and sql? I am new to this field.Please help!!!!!!!!!!!!!!!!!!!! |
| | Guys, How to make an scripts if itemnumber have no '-U' then i will place this on the right side while if there's an exising '-U' then no replacement to be done. [CODE] ItemNumber ------------------ P300-4410-DROIDERIS P300-4110-TOUR P333-4410-EVO-U P333-4129-8530PUR-U P333-4170-9330GRY-U P333-4110-8350-U RESULTS: ItemNumber ------------------ P300-4410-DROIDERIS-U P300-4110-TOUR-U P333-4410-EVO-U P333-4129-8530PUR-U P333-4170-9330GRY-U P333-4110-8350-U …  |
| | Hi Guys, There are unwanted character in my columns. this character is came from the bulk insert. How tdo i removed this character using scripts. Please see sample below. [CODE] ItemCode--Item Number ---------------------------------------------------------- 123--Phone power on but vibrate is too weak P300-3110-VX8575 124--place a test call. P300-1710-DROID 125--power issues.touchscreen not … |
| | |
| | hi everyone .... how to graph data from MSSQL database using php? i research in google and i found phpgraphlib but it only graph the value of the array |
| | Greetings expert programmers, May i ask for a help on how to solve this error? " A network-related or instance specific error occured while establisihing a connection to sql server. The Server was not found or was not accessible. Verify that the instance name is correct and that SQl server …  |
| | Ok im not sure what it is I need. But I have a sort of fantasy baseball website that I want to add something to. I want to see what players have been on the most championship teams. I just don't know how to query the players against the results … |
| | [CODE]select CS.Ref, CS.C, DT.ID, DT.Init, DT.Surname, 'C' [P], 'C' [A], 100 [M], case when Convert(Varchar(10),CA.A,120) is null then Convert(Varchar(10),CS.DC,120) else Convert(Varchar(10),CA.A,120) end, C.R, Convert(Varchar(10),C.CDate,120), Do.Outcome, CT.PhysicalOwner, Convert(Varchar(10),CS.CDate,120), Convert(decimal(8,2),CS.B, Convert(decimal(8,2),CS.CB), Convert(decimal(8,2),CS.IB), Convert(decimal(8,2),CS.Calance), Convert(money,SUM(dd.C)), Convert(money,SUM(cl.C)), CT.CID[Cust_ID], Convert(varchar(10),CS.JDate,120), CS.JCN, CO.C, Convert(varchar(10),CS.OD,120), CS.OCN, CO2.C from table1 CS inner join table2 DT on DT.DID = … |
| | Hi, Please help me out . I need to retrieve the records from 11th row onwards using select query. Please help me out . Its urgent. Thanks |
| | hey how to answer to these questions Table: Sales(CustomerID , RepID , Area , SaleDate , ProductNo , Quantity , UnitPrice , ItemTotalPrice) a)considering the above table write a function to calculate the IemTotalPrice as ItemTotalPrice=Quantity*UnitPrice b)Write a SQL statement to create the above table (you must use the above … |
| | Guys, I have records from table 1. the objective is to get the date from Table 2. when i try to use select statement to obtain the records it pull all itemnumber with the same item number in TABLE 2. is there any idea to to this using the result … |
| | hi everyone i have this code(dont think its a code spam ..its a trick) which display the date(only): [CODE] <a href="index.php" STYLE="TEXT-DECORATION: NONE">«Back•</a> <br> <br> <hr width="200" align="left"> <br> <?php $conn=odbc_connect('datasourcegaby','',''); $search=mysql_escape_string($_POST['SEARCH']); if (!$conn) {exit("Connection Failed: " . $conn);} if($search==null){ header("location:index.php"); }else{ $sql="SELECT * from generators WHERE convert(datetime,convert(char(10),TIMESTOMPX,101))= '$search'"; }; … |
 | Hello, Please help me with my problem, this is the simple select statement I have for target bid date: [CODE]ProjectOverview.[Target Event Date - Date] AS [Target Bid Date][/CODE]now, I want to ask how can I select the latest target event date and if value is null, put "no date" caption … |
| | Hi guys! I am at the very end of a 3 month project and have encountered an issue right at the last hurdle. I am using my companies content management system to display a web page. The web page is information regarding a certain species of animal, and the content … |
| | Guys, I have a Date string. My objective is how to get the Datename. I got this Receivedate as string when I used the Bulk insert. i make the receiptdate as nvarchar because i got an error when i used the bulk insert. [CODE] Select ItemNumber, PurchasePrice, ReceivingPO, Cast(ReceivedDate as … |
| | How do i change the name of a table in my sql server 2005 express edition database using visual studio server explorer? |
| | Right now the company I work for is using Microsoft enterprise library very extensively. From what I've found online recently, these database objects aren't intended for web (asp) usage, and are relatively bloated. I don't know how accurate my research is, but I do know we have optimization problems in … |
| | I have the following stored procedure: [code] SELECT moncallAdd.FirstListing, DATEADD(MINUTE, mOnCallAdd.StartOnCallTime, DATEADD(DAY, mOnCallAdd.StartOnCallDate, '12/31/1899')) AS OnCallStart, DATEADD(MINUTE, mOnCallAdd.duration, DATEADD(MINUTE, mOnCallAdd.StartOnCallTime, DATEADD(DAY, mOnCallAdd.StartOnCallDate, '12/31/1899'))) AS OnCallEnd, 'Added' As Activity FROM mdr.dbo.mOnCallAdd WHERE DATEADD(MINUTE, mOnCallAdd.StartOnCallTime, DATEADD(DAY, mOnCallAdd.StartOnCallDate, '12/31/1899')) BETWEEN Convert(VARCHAR(10), GetDate(), 101) AND GetDate() and mOnCallAdd.SchedName = @schedname UNION SELECT moncallDelete.FirstListing, DATEADD(MINUTE, … |
| | hi everyone i have a search page that will search base one date... but if i search with only date (9/27/2011 ) it will only display the data from database that has the same date and time but not the whole data in that specific date: example: in my database …  |
| | Hi all, In my table i have duplicate rows. i want to get distinct rows. select distinct * from table1 does not work. select distinct col1,col2,col3,col4 from table1 does not work. both say: The text data type cannot be selected as DISTINCT because it is not comparable. select distinct(col1) col2,col3,col4 … |
| | Greetings expert programmers, Can someone guide me on how i will connect my vb.net 2008 to ms sql 2008 r2? I already installed mssql 2008 r2, and when i try to add the connection it says i need to call the administator something like that even though i checked all … |
| | Hello, I'm trying to do a very basic page that allows me to edit a single column in a MSSQL database. For whatever reason I can't figure it out and am hoping that you can help. Here is my front page (sorry about the silly names) [CODE]$ninja_conn = odbc_connect('XXXXX','XXXX','XXXX', SQL_CUR_USE_ODBC); … |
| | Hi all, I want to know how to assin a return value to a variable when calling a regex function. it always returns a bit type of value(its ok). i want that bit type of value tobe cheked whether it is '0' or '1' this is my C# code in … |
| | hi everyone i want to create a search page in PHP... where i can search data from database by a specific date by using odbc command (since i use to connect the DB by odbc) ...can some one help me ...  |
| | can any one tell if there existing database administration tools like mysql workbench but for mssql i know about sql management studio, but there is other one who will manage mssql other than SSMS? I will appreciate for any help will come. thank you.  |
| | Hi Guys, How do i obtain the nearest shipdate prior to Returndate. here is my sample script. thanks. kindly check my script. the result should be 2011-02-23 [CODE] Table1 ESN--DateReturn 123--2011-03-08 TABLE2 ESN---ShipDate 123---2010-09-28 123---2011-02-23 Select a.DateReturn max(b.shipdate) from Table1 as a left outer join table2 as b on a.esn=b.esn … |
| | hi, i have a question in data tables. i am coding in C#. my scenario is employees have many benefits in a company such as life, health, dental, 401k and such... i have a tabel in MSSQL database to represent the employee data and a emp benefit table to hold … |
| | hi ...i have a problem connecting MSSQL 2005 express and php.. i've tried configuring the php.ini by removing the ; in extension=php_mssql.dll but not working i also place the php_mssql.dll on ext folder but not working again; and also i tried downloading an old ntwdblib.dll and placing it in system32 … |
| | hi ... can someone help me on connecting MSsql 2000 to vb6 ...i've been searching google but they always point me to this site .. [url]http://www.connectionstrings.com/[/url] i dunno how to set up this strings in vb since im new to vb... :( please help |
| | Anyone know what is the root cause unable to open the connection in php? [CODE]CDbConnection failed to open the DB connection.[/CODE] I m having trouble connecting to mssql server connection..in yiiframework  |
| | Hello, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at … |
| | Hello Everyone, I know this is going to be easy to all of you, this is my first time performing an if else statement in SQL, after performing this query: Collapse | Copy Code IIf(IsNull(EventSummary.[Event Information - Event Status]),"ACTIVE",EventSummary.[Event Information - Event Status]) AS [Event Status], I get this error … |
| | I am using SQL Server 2008. I have data from SQL like this. [CODE] ID ID2 PartNo -- ---- ---- 75 23921 DENT 75 26145 PLGD 75 26145 PRRP 75 26145 SIST 75 57290 PRMD 75 57290 abc 75 57290 def 75 57290 ghi 75 57290 jkl [/CODE] I need … |
| | I am using SQL Server 2005. I have a data from SQL like this. ID ID2 PartNo 75 23921 DENT 75 26145 PLGD 75 26145 PRRP 75 26145 SIST 75 57290 PRMD 75 57290 abc 75 57290 def 75 57290 ghi 75 57290 jkl I need an output like this. … |
| | Hi I have [B]Windows 7 Home Premium SP-1, 64-bit[/B] version on my PC. I want to install SQL Server either 2oo5 or 2008. but i am unable to install this. Error: [I]OS Incompatibility[/I] Pls Reply: Thank U |
| | SELECT * INTO NewTable FROM existingdb.dbo.existingtable; I am executing this query but it is showing me the error as undeclared variable:Quanti (as quanti is my NewTable) |
| | hi i have to search based on opening and closing times of shops. e.g. opening time of one is from 9 am to 11 pm another can be 5 am to nextday 2 am. e.g of sample data below [CODE] ShopID open time close time shop1 10am 11pm shop2 6am … |
| | Hi, I have a sql view below: [CODE] SELECT b.Stk AS secode, b.TktE AS Ticket, CAST(a.Last / 10 AS integer(10, 3)) AS Last, CASE WHEN CONVERT(integer, a.Last) <> 0 THEN (CONVERT(integer, a.Last) - CONVERT(integer, a.Ref)) / 10 ELSE (CONVERT(integer, a.Ref) - CONVERT(integer, a.Prev)) / 10 END AS Change, CAST(a.High / … |
| | Guys, Please take a look my script. my object here is to get the most recent date from table 2. what if the recent date from table 2 is less than the date from table 1? [CODE] Table1 Type-Date1 -------- 1-2011-07-16 2-2011-07-16 3-2011-07-10 4-2011-07-10 Table2 Type-Date2 -------- 1-2011-07-06 2-2011-07-07 3-2011-07-01 … |
| | Good Day Everyone.. i have two tables..how to read from one table1 to table2.. example.. Table1 with thousand over records various types of recurrance and due pattern. where ID = History_ID Table 1 ID Reccurance Duepattern 1 Monthly 10 2 Yearly 25 3 Monthly 15 4 Weekly 5 yearly 14 … |
The End.