2,935 Topics
 | |
| | 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 … |
The End.