3,481 Topics
 | |
| | Hi, I'm wondering if anyone can help me develop the right sql query. I'm trying to select a "customerNumber" in table 1, but only if it doesn't exist in table2. I tried this [CODE]Select Table1.customerNumber From Table1, table2 Where table1.customerNumber NOT IN (select table2.customerNumber from table2) [/CODE] It isn't right …  |
| | Hi.. I'm developing a website for the first time in visual web developer using asp.net and sql sever database. I have designed my pages and master page. I have created my sql server database too. Please could you help me how to connect the database to asp.net master page? Also … |
 | I cant load the image from database please help.. [CODE]strsql = "select top 1 id,shape from table" set rsgetimage = server.CreateObject("adodb.recordset") rsgetimage.open strsql,application("connectionstring") Response.Expires = 0 Response.Buffer = TRUE Response.Clear Response.BinaryWrite(rsgetimage("shape")) Response.ContentType = "image/png" rsgetimage.close [/CODE] it just display an x icon - thanks |
| | Daft subject header, but its early and brain not awake yet! One for the SQL gurus (either that i've missed something here....lol) I want to select rows where there are duplicates of data in some columns, but not others. Where a duplication IS found, i want to return all rows … |
 | hello ! i am working on a single page of asp ,and i am using ext js 4.0 with it . i have a grid of extjs , my task is to show records in that grid from mssql server 2008 , for getting records i am using webservice . … |
| | I want to take backup of my server database at my local machine........ how can i do this...... Thanks in advance  |
| | Does anyone know how to update multiple images? |
| | Hello, I am working through an SQL Server 2008 book. I am to the query section. I have copied the query below, word for word (I believe), but the system is showing a problem at line 10. This is the first query I have tried to create. I don't see …  |
| | Hi all, Im running a update query like this to update multiple rows(about 1000). Example of query: [CODE]UPDATE DATA1 SET Column = CASE WHEN TIME = 0 THEN X WHEN TIME = 1 THEN y WHEN TIME = 2 THEN Z WHEN Time = 3 THEN Q END [/CODE] The … |
| | Hi, Please help me out to get this issue solve. Am don't know, how to get the output. This is the way, i need. But i don't know. (a)select distinct empid from emptable where year=2011 order by empid (b)I needs to pass this empid with the while loop: while() { … |
| | How can I replace only "North" in this following string when it is by itself? 'E NORTHCREST DR NORTH' UPDATE address SET streetname = REPLACE(streetname, ' NORTH',' N') This script changes it to 'E NCREST DR N'  |
| | I have to save 4 different pictures in my database. NSO, GoodMoral, ReportCard & TOR. Here is my code. [CODE] Sub savepic() Dim str As String = "My connection" Dim con As New SqlClient.SqlConnection con.ConnectionString = str Dim ms As New IO.MemoryStream() nsopic.Image.Save(ms, nsopic.Image.RawFormat) goodmoralpic.Image.Save(ms, goodmoralpic.Image.RawFormat) repcardpic.Image.Save(ms, repcardpic.Image.RawFormat) torpic.Image.Save(ms, torpic.Image.RawFormat) … |
| | hello! i am working on a Asp.net project using C#, now i want to connect mssql server 2008 using JS or AJAX , i am very new with JS so i have no idea where to start .can anyone help me in this . Regards M.Waqas Aslam |
| | declare @suppid as varchar(50) if(@suppid is null) begin select isnull(MAX(convert(int,suppid)),0)+1 from us.dbo.supp where ISNUMERIC (suppid)=1 end  |
| | Cannot connect to x. =================================== A network-related or instance-specific error occurred while establishing 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 is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 … |
| | [CODE]Hi Forumer's kindly please optimize my query. I need to separate the colums for statusissue = 0 and statusissue =1 my query create double entry. ]--Sample Table Create Table #Table1 (Itemid nvarchar(10), Datephysical datetime, Statusissue int, Qty numeric(28,12)) --Sanple Data Insert into #table1 (Itemid, Datephysical, Statusissue, Qty) values ('HTC1175','2012-02-14',1,50) Insert … |
| | [CODE]SqlCommand command = new SqlCommand("SELECT Id FROM users WHERE Username=@Username AND Password=HASHBYTES('MD5', @Password)"); command.Parameters.AddWithValue("@Username", pieces[1]); command.Parameters.AddWithValue("@Password", pieces[2]);[/CODE] doesn't return correct result [CODE]SqlCommand command = new SqlCommand("SELECT Id FROM users WHERE Username=@Username AND Password=@Password"); command.Parameters.AddWithValue("@Username", pieces[1]); command.Parameters.AddWithValue("@Password", pieces[2]);[/CODE] returns correct result, however the data in mssql database has to be not … |
 | Hi , I have 2 columns named 1. Tel_H 2. Tel_H_Code How can i merge these two columns to make them one ?? I am clueless here...The best i can do is to view them as one [code] SELECT Tel_H_Code + Tel_H AS 'Tel_H' FROM Detailed_List [/code] |
| | Hi Its in fact easy to handle special characters like "%" in query, with just a bit of research one can found solution for this. Today when i checked events for my server i found that one error message and that was because a user searched for " l'atelier " … |
| | Hi Forumer's, I have 3 tables, my objective is to compare the returndate from receiptdate and trandate and get the most recent receiptdate or trandate based on returndate. [CODE] Create Table #USPRODUCT (ESN Nvarchar(35), returndate datetime) Insert Into #USPRODUCT (ESN, returndate) Values ('268435458805382753','2011-04-21') Insert Into #USPRODUCT (ESN, returndate) Values ('268435458805382753','2011-08-08') … |
 | Good day, I want to delete a record from a single table but some of the filed on sigle record is related to other table on my database. how would i delete it.. i used this script delete from faculty deptid = (select deptCode from dept) all i want is … |
| | I have a database that continually receives information from outside sources. I then use SQL code to take this data and move to different databases based on the information received. As it stands right now, if I receive a '1', '2', '3', from an outside source, we manually move it. … |
| | hello ! i have experience in VB.net,C# and MSSQL2000,2005,2008r2 .but today my boss assign me a task to connect mssql server 2008 by using JS or JSON ,both are unknown for me ,:( i dont have any knowledge about JSON and JS , can any one help me how to …  |
| | [CODE]IF OBJECT_ID('tempdb..#Table', 'U') IS NOT NULL DROP TABLE #Table GO Create Table #Table ( CorrectionDate datetime, Origdesc nvarchar(50), Newdesc nvarchar(50), Total int ) Insert Into #Table (CorrectionDate, Origdesc,Newdesc,Total) Values ('2011-08-01 00:00:00.000','RMAWAR','NTF',193) Insert Into #Table (CorrectionDate, Origdesc,Newdesc,Total) Values ('2011-08-01 00:00:00.000','NTF','RMAWAR',108) Insert Into #Table (CorrectionDate, Origdesc,Newdesc,Total) Values ('2011-08-01 00:00:00.000','RMAWAR','Sub Abuse',86) Insert Into … |
| | |
| | need some help here what i want is when the user inputs the username and password, his/her information will be showed in the textbox located at the mainform which shows the users information like where he live and his occupation. please help me on how to show users data in …  |
| | |
| | Hello Friends. Im having a problem in identifying the Provider for my MSSQL Server 2008. Can anyone address me the location of this information because I have to initialize it in my VB.et. As I understand for Ms Access it is something like [CODE]"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="[/CODE] Can I know where to …  |
 | Okay, So I have an application which uses MSSQL server as datasource. Is there anyways I can avoid using any database server and use a local file as datasource ? If yes , what are options. AND HOW ? PS: this is very important guys. please help. THANK YOU. |
| | hello EveryOne! i am very new in JS and JSON , or you can say this is my first day to learn something about JS and JSON, i have few questions 1- what is difference between JS and JSON. 2-My Task is to connect MSSQL server 2008 and show records … |
| | HI I would Like to Know how can Display the error Message When Executing the SP .. and the Stored Procedure doesn't having any value to Fire the Event .. [CODE] set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author: <sabari,,Name> -- Create date: <Create Date,,> -- Description: … |
| | My table has these info T123 T153 T174 Basic SQL count works fine which results to (3).. but when I use this function needed for my query the output is 4. [CODE] COUNT(DISTINCT CASE WHEN id LIKE '%T%' THEN RIGHT(ID, 3) ELSE 0 END) AS Count [/CODE] what's wrong with … |
| | I am wondering if anyone wants to try and better this code sample. Here is the request: Given a range of dates (start, end) return all rows that cross that range where the rows contain a start and end date. This appears to work. I just wonder if anyone else … |
| | ..hi...im working with a Cash Collection System using PHP and a Yii Framework.. ...but i am wondering if it is possible to connect a MSSQL Database by Yii... ..if so...then could you please help me how... |
| | hi there i have problem with my MS SQL server some one execute unwanted update statement on huge table and make loss for my data i fix it by using available backup but, i need to know who,can i do it if there are some logs for sql statement please … |
| | hi friends. Im currently working in integrating GR Fingerprint SDK with vb.net application. I am using MSSQL 2008 as my database and vb.net as the front end. I have completed almost 90% of the application and im stuck in integrating this SDK with my application. It has an error such … |
| | Hi, I have a table that stores records of students. Now what I want is that after a particular period of time the account of the student gets disabled automatically. Is there any time based trigger that can be hit automatically if i set the time limit for that. Or … |
| | Hi guys, Need your advice. I ask my boss if i could have a training for SSAS and he replied positively, im not connected in IT we are different department but were using MS SQL and we do some analysis and reports using excel and SSRS. im helping other department … |
| | Hi, For the users, i grant the permissions to create a table and then i also given the permission to alter table i.e grant alter on san to user; Logging as user: Table (design mode), am getting the error: "You are not logged on as the database owner or system … |
| | I am having a table named "Society" And 5 master tables "BlockA","BlockB","BlockC","BlockD","BlockE". The "Society" table contains the foreign key columns of all the 5 master tables. Now when i write the select query it takes a lot of time to execute, as 5 tables are referencing one table and joining … |
| | So I've looked for an answer to this question on the web but couldn't find anything that covers this specifically. Our database stores the project version in the format #.#.# (Rev_#) so there is both text and numbers in the string. I have no control over the data so I … |
| | Hi. I was creating an enrollment system for my Thesis, and my adviser told me that I must have a Code in my program that Synchronize database from client and server so that if the terminal connection is "Up" the data will go to the server and if the connection … |
| | Hi a have 4 tables Table A ID | Data 1 --------------- 1 | A Table B ID | Data 2 ----------------- 1 | B 1 | C Table C ID | Data 3 ---------------- 1 | D 1 | E 1 | F Table D ID | Data 4 … |
| | Guys, Need your help. i need to obtain the nearest date from 3 tables. attached my scripst. th problem with this scripts it creates double entry in receipt date with the same transaction specially for this ESN "268435459407885398". [CODE] SELECT p.ESN, p.ReturnDate, s.Receiptdate, e.Shipdate FROM #Product p with (nolock) CROSS … |
| | I have Sql2008 enterprise edition and want to install on windows 7 ultimate edition,it is giving error for version compability.what is required to do? |
| | Hi, I am having trouble with retrieving records on my database. My layout was this.. [CODE]UsersList Username Firstname LastName Role Records TheUser ApprovedBy DateApproved [/CODE] The first text are the table names while the indented once are the field names. I have a table named Records. TheUser and ApprovedBy was … |
| | Hi, I want to convert Single Column values to Row. Table Original Content: Code Amount Expenditure 10027 5000.00 LOCAL CONVEYANCE 10027 320.00 LOCAL CONVEYANCE 10116 1589.00 TRAVEL EXPENSES 10095 350.00 LOCAL CONVEYANCE 10095 1215.00 TRAVEL EXPENSES Expected Output : Code LC TE 10027 5000.00 NULL 10027 320.00 NULL 10116 NULL … |
| | hi, can someone help me? i am using vb.net2010 and mssql as my database. what i want to do is when i open the form, the database will auto increment the student id and show it on the text box. |
| | Hello Every one ! i am trying to make query to show the growth of sale of the product month wise ,i have one table name Sales .having following fields , SalesID,ProductID,amt,Qty,SalesDate i use this query to show my records [CODE] select ProductID,Amt,Qty,substring (datename(month,SalesDate ),1,3)as months,DATENAME(YEAR,salesdate ) as years [/CODE] … |
| | Hi, I am trying to use the PIVOT function in SQL Server 2008. I have a query that I think should work, but whenever I execute it, I get the errors: Msg 265, Level 16, State 1, Line 25 The column name "CompleteTime" specified in the PIVOT operator conflicts with … |
The End.