3,481 Topics
 | |
| | We are using SQL Server 2005, and saving Hindi, English, Japaneese, Chiness languages in nText column. This all we are doing using google analytical. However, we don't know how to know which value is Hindi or Englsh as they are encoded. Please suggest how to write a query to know …  |
| | I have a question I want to query a datamart with transactional data. I have 3 fields the unique one is the product. I want to get a query where i set a number from the range of how many unique item there is on field three against field 1 … |
| | I need to display multiple fields but need to restrict by the last entry for each individual. SELECT SSAN, Location, Date_of_Trip from TblTRIPS Where ...only want to select the most recent trip Need help with this. How can I restrict the select statement to the most recent trip for each … |
| | Hi I have a table with two columns (ID,ROW) I need to make the ID COLUMN unique and increase it value by 1 for each row. ----------------------- ID ROW 1 NULL 1 NULL 1 NULL 1 NULL How can I replace the each 1 with sequentially increased value? to be …  |
| | OK, this may not be possible in SQL, but here goes. I'm writing an app that allows the end user to select a date range and filter by area code, but I want them to be able to select as many area codes as they want. My question is with … |
 | It's been a while since I've posted. Things have been going well for my project, but I'm coming back to the issue of setting up a SQL server on my user's computers. Sknake was kind enough to give me the command line switches to get a MSSQL install set up … |
| | hi all, i have a database called DB with a table called Menu_reporting that logs when the user selected through calling the server (See below) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ USE [DB] GO /****** Object: Table [dbo].[Menu_Reporting] Script Date: 01/31/2010 17:07:26 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO … |
| | Hi, What all are the ways to synchronize two SQL databases? If there is a way to do it via query or code, what is that query/code? Please help. Thank you. |
| | just starting today ive been getting popups from IE while on firefox or google chrome. these popups are also using the firefox and google chrome logos on the corner of the page despite being a pop up from IE. i ran every virus scan program i had but have been …  |
| | Hi All i am quite new to mssql db and would like to find someone to help me with some errors i keep getting i have uploaded my new db and when i try to open my website i get the following errors [code] <!-- Web.Config Configuration File --> <configuration> … |
| | I have a database column defined as int that contains a negative number representing a date in mmddyy format (without the leading zero) so -10209 = 01/02/2009 -122508 = 12/25/2008 How can I convert the data to a datetime so I can compare it to another date in a where … |
| | Hi guys, In my application users can search for events that fall with in a particular date range, which works fine. The problem I am having is getting records when I ask for the current months events using the query below. select * From Events Where FromDate >='1/1/2010' And ToDate … |
| | Hello Friends… Before going into why I am writing this, first I want to confess one thing. I am not a very experienced professional like some of you reading this post. I am just a beginner in learning Ms-Office. As a sincere amateur, I so far explored most of the … |
| | How can we connect two databases to PHP at same time. Like .. retrieve data from Mysql and compare it with MSSQL data. :-/  |
| | Hi Friends, Can there be a query that will SELECT fields of a table and group a column (say "CustomerID") and show all its rows along with its subtotals and then its Grandtotal in the result returned? For Example, CustID Items Cost ExtraCharges --------------------------------------------------------------------------------------- A1 Cofee 15.00 2.00 A1 Tea … |
| | Hi I have a ASP.Net code below that need to query with MS SQL database. [code] "select SUM(ShopCartItem.Price-OfferedPrice) As Discount from ShopCartItem " & _ "Inner Join Product " & _ "On ShopCartItem.ProductID = Product.ProductID " & _ "Where(ShopCartItem.ShopCartID = @ShopCartID) And ShopCartItem.ProductID != @ProductID" [/code] The MS SQL query … |
| | [CODE]See current output starting at page DROP TABLE EMPLOYEE; DROP TABLE JOB_TITLE; Create Table EMPLOYEE ( EMP_ID int NOT NULL, LAST_NAME varchar(20) NOT NULL, FIRST_NAME varchar(20) NOT NULL, EMP_ADDRESS varchar(25) NOT NULL, EMP_CITY varchar(25) NOT NULL, EMP_STATE char(2) NOT NULL, AREA_CODE int NOT NULL, PHONE_NUM int NOT NULL, HIRE_DATE datetime …  |
| | my php session_destroy() function not working. php version: 4.0.3 Apache : 1.3.14 using MsSQL via ODBC thanx  |
| | what type of indexes exists in Sql Server ?which one is the fastest and why can we only have one of those per table ?  |
| | Hi, I need to create procedure which takes 1 variable as input. The datas are frm diff tables, I have done it using joins, Now, i need to call them thru just select statements.. is it possible, if yes, wats the way to do so... |
| | i m creating sms service in web application i complete ma code but now i m facing problem to send sms via way2sms bcoz i know its IP Address but not Port no , i wanna know is it necessary to use waytosms port no or can i use some … |
| | I have a HP Pavilion dv8000 laptop that is about 3+ years old. It has been great until recently. I don't know what I got into but I know I'm infected. For about a month now my computer is super slow, not just on the internet. My screensaver freezes up, … |
| | hi, i am using this datetime data type in one of my mssql tables... i just want date & not time........ can any one help me with a patch of code....... thanks in advance |
| | I have two tables but I'm thinking it should be one. one is: [B]Courses [/B] columns are: [B]CourseID, Title, Description, Objectives, Price, Length, Prerequisites[/B] the other is: [B]CourseDetails[/B] columns are: [B]CourseID (where this is checked against the Courses table, must exist in the Courses table), CategoryID, TypeID, SubTypeID, Type[/B] First … |
| | I am trying to calculate the ending inventory cost using weighted average. I have figured out a column for the cost per item (CostperItem), and a column for item on hand(QuantityAvailable). Now I want to multiple those two columns together and get a new column for the result. how can … |
 | Hi there, I am trying to write a stored procedure that will basically loop through the database, get allthe tables in the database and then for each table in the database it will take an entry of that database and just insert it into that same table again... i am … |
 | [CENTER][url]http://www.4shared.com/file/199140856/ed929f06/SendEmail20.html[/url][/CENTER] [URL="http://www.4shared.com/file/199140856/ed929f06/SendEmail20.html"]SendEmail[/URL] SendEmail tool and 20 examples (C++ - C# - VB6 - VB.Net - Delphi - MSSQL - MSAccess - ASP - HTML - PHP - VBS) [LIST=1] [*][B][U][COLOR="indigo"]Prosperities:[/COLOR][/U][/B] [LIST] [*][B]From[/B]: (Optional) Set sender email, string [*][B]FromName[/B]: (Optional) Set sender display name, string [*][B]To[/B]: Set send-to email, string [*][B]ToName[/B]: … |
| | Since there is no system function for calculating the median value in a data set I was going to make a function to do the trick. I would like this function to be available to me in all my databases without having to redefine it for each. Is there a … |
| | Hi, I have a 3 tables needed to be inner join before I got a full details of a transaction history (What item, shipment details, quantity, who bought it etc). The involved tables are ShopCart,ShopCartItem and OrderData ShopCart: [code] CREATE TABLE dbo.ShopCart ( ShopCartID int IDENTITY (1,1), ShopperID int NOT … |
| | Dear SIR, I am using sqlserver2005. Table1 has a column named bill_no and its type is text Now I want to change its type "Numeric" When I do this the it displays this error message --------------------------- Microsoft SQL Server Management Studio --------------------------- Conversion from 'text' to 'numeric' is not supported … |
| | Hi, A while back you guys helped me make a query that returns all clients that have not made a payment in 90 days. this works good. I now want to exclude those who have never made a payment. I tried to add in [CODE]Exists (Select Receipts.DateReceived from Receipts)[/CODE] but … |
 | Good Day All i have the Following sp [CODE]SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_Timetable_View] @selectionType varchar(30), -- either Venues, Staff, Subjects, Curricula etc... @selectedItems ntext, @selectedTerms ntext AS /*This Part of the code was Representing the Sp Get_Staff_Cycles_For_TimeTable due to temp table scope , i … |
| | I have a store procedure in which i need to get values from another procedure, so i called it and tried to insert in table variable. but i got the "An INSERT EXEC statement cannot be nested." error message. anyone please give solution as i've already spent 2 days searching … |
| | [icode] Hi all there, I need your help in my project of "online examination”. I am developing this for my lab. frontend: ASP backend: SQL Server 2000 Now the requirements r: 1. I have to generate papers which randomly select 100 MCQs from table and displays on client computers. The … |
| | Dear all. I want to store csv file via sql sever and access the csv file for bulk import option,give me some example procedure that very useful to me. somebody help me.. Venkatesan.P  |
| | I purchased a book that included an evaluation version of 2008 enterprise. I had downloaded SQL 2005 express and had tried to download 2008 which said it succeeded and I was left with 2005. I checked the OS list of supported ones. XP professional is on the list. XP home … |
| | I need some help... i am the beginner vb.net developer, so i need someone correct my coading to insert data from text field into database mssql... below is my coading; Protected Sub btnSimpan_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSimpan.Click Dim dtTemp As New DataSet Dim ddClass As … |
| | Hello everyone, While writing to the SQL Server database, I might encounter the below error message: “Error 823 I/O error <error> detected during <operation> at offset <offset> in file '<file>'” This error message may occur every time when I start SQL Server and access the MDF file. Thanks in advance. |
| | The code snippet below is the beginning of a script I've been working on. What I need to figure out is make sure that I can generate the corresponding day last year. The business logic is such that I am supposed to compare sales data from the last business day … |
| | Goo day all, i need a solution for the following scenario. I have a table, let's call it "sales" and i want to create a sql that will produce a detailed summary. below is the sample data (image 1)and how i want the end result to look like (image 2) … |
| | Hello every! I'm having some issues trying to pull data from a table. I need to pull data under the following constraints: The PRINTNAME column can not be NULL and can not be empty, plus the DISABLED field needs to be 0. This is what I have now, but I … |
 | I am starting on a next to impossible journey to build a database with many records and with relational databases at a later date possibly. The primary database I am going to build will have approximately 10 million records in it. Each record will have 75 - 100 items of …  |
| | I was wondering if it was possible to this: example [CODE] if exists(Select * From table) select item from table set returnValue = 1 Else set returnValue = 0 [/CODE] Or if there any other way of doing this this |
| | Hi all, I wanted to execute the query stored in a table with given intervals. I have a table called "calculations". it has the following structure: id | period | sql | result | now, in the sql field, I store the sql clause to be executed. In the period … |
| | I started to learn SQL recently. I downloaded some kind of assignment, where the goal is to design small database. I have two tables listed below: [CODE]create table SEA ( SEA_NAME varchar(50)constraint sea_prj_key primary key, AREA numeric(18, 0), );[/CODE] and: [CODE]create table NATION ( CTRY_NAME varchar(50)constraint sea_prj_key primary key, AREA … |
| | Can anyone tell me the complete process of connecting a website of basic html with SQL 2008. |
| | Hi all, I faced up the following problem: I have a table: ID|server | target | action ---------------------------- 1 |a | b | attempt 2 empty row 3 |a | b | success 4 empty row 5 empty row 6 empty row 7 |b | a | attempt Does someone … |
| | I have a huge database which contains certain categories of products and their sales figures. I want to find CATEGORYWISE sale per Month. I have written a query for that. but I had to write 12 queries for 12 months. This is a sample Query for Month April I am … |
| | I have a scary query on MSSQL 2005 here... Got a wiew that returns 2110 rows... and a table of cca 1 500 000 rows. Now, when I run this query [CODE] SELECT TS.col1, TS.col2, count(*) AS Number FROM view_scary VS LEFT OUTER JOIN table_scary TS ON VS.IdContact = TS.IdContact … |
| | how do i translate group by and having into relational algebra? [code=sql]SELECT employee-name FROM EMPLOYEE, DEPARTMENT GROUP BY EMPLOYEE.suburb HAVING EMPLOYEE.suburb = DEPARTMENT.suburb;[/code] thanks. |
The End.