3,481 Topics
 | |
| | Hello all. I have a simple quoting system I am developing for a project, and need help with how to query rates. There are two tables, one for zips (with state, county, zip code, and a zip lookup code associated with each zip), and one for rate data (company name, …  |
| | The procedure for Insert/update.I use datagridview get and display the data. I get the error message "Procedure or function Updatedata has too many arguments specified." // this is my Procedure ALTER PROCEDURE [dbo].[Updatedata] @item char(30), @uom int,@group int,@orqty int,@avgcons int,@reorder int AS BEGIN SET NOCOUNT ON; IF EXISTS( SELECT * … |
| | Good afternoon. I am trying to import a csv file to a SQL database hosted through GoDaddy. However, I continue to receive an error which states "Line 7 has 24 values (20 expected)". Line 7 in my .csv file only has 20 columns (20 values) and no matter what I … |
| | Hi All, Ever tried to make a change to a SQL database table only to get a message telling you it is unable to carry out the change as it would have to drop and recreate the table? This is one of these things that you encounter once, correct and … |
| | I need you help in making a query about this table. ------------------------------------ boss # | bet1 | bet2 | bet3 ------------------------------------ LastName |Bet1 |Bet2 | Bet3 11111111 |1 |0 | 1 22222222 |1 |0 | 0 333333 |0 |1 | 1 44444 |0 |1 | 1 i want to count …  |
 | hello! i am currently working on a simple file make application , this application read data from foxpro .dbf file , i want to get records between two dates , from date and to date , the invoice date field name is fl02 here is my query but this is … |
| | Dear experts, I have to contnous transfer data from one sql server to another sql server , but condition is that first sql (database used and inserted by another application) should maintain 3 month data at any time and anohter sql will store all the data transfer from first sql. …  |
 | i have a signup form on my website for user registeration ....... so i want to make it secure , by secure i mean , Password should be encrypted etc etc.....or any other precautions for security i already used hash functions of MS SQL on password field through queries but … |
| | I got SQL Server Compact I got a database called Pages and a row called pName the row contains page names, but some are upper-case I now want to make all these lowercase. So there is a page like Downloads, I want to change it to downloads is this possible …  |
| | Good day. I have this running query that I want to pivot the sum of CurrentBalance where in Monthdate =[2011-11-30],[2012-12-31]...etc. But everytime I try to put the Pivot, it cannot detect the CurrentBalance column alias. Here is my query so far. use MFR_Merchandise go declare @MonthColumns as nvarchar(max) declare @SQLtext … |
| | Hi all, To perform the delete data from Product table by ProductID of Adventure Works database needs to use delete cascade. Has anyone done this yet? Can provide for me examples to do it? Thanks a lot! |
| | Parse error: syntax error, unexpected T_DNUMBER in D:\InetPub\vhosts\xdran.com\httpdocs\settings.php on line 7 heres my configuration <? error_reporting(E_ALL ^E_NOTICE ^E_WARNING); $web['connection'] = 'mssql'; $con = mssql_connect("203.143.82.98:1433","sa","z09184049210); //$mssql_server = "203.143.82.98"; //MSSQL server name or IP //$mssql_username = "sa"; //MSSQL username //$mssql_password = "z09184049210"; //MSSQL password $web['database'] = 'Rancp'; $web['database'] = 'RanGame1'; $web['database'] = …  |
| | I am having a rquirement that I need to save details of Event in one table and PassTypes of that Event in another Table.Like ID EventID EventTitle EventDescription 1 E00001 EventTest This table Conatins all Event Related info… 2 E00002 EventTest2 This table Conatins all Event Related info… ID EventID … |
| | I have sets of data that i want to put in tables, however the data is big and want to put it in different rows, something like have a table like MSISN DBSG OSB1 OSB3 BS2G BS3G TS11 TS21 TS22 CSP NAM 256392999829 1 1 1 1 1 1 1 … |
| | HI, I want to retrieve list of executed query for a specific date in sql server. Thanks in Advance |
| | Here is the code that can be copied into sql server to better assist with what I am trying to accomplish. Hope it makes sense and post back with any questions you may have: create table #temp(period int, location int, custnum varchar(10), driver varchar(25), dollar decimal(10,2)) insert into #temp values(201201,221,'ABC123','dwcustcomm',52.37) … |
| | i installed .net framework windows installer and then sql server 2008 then sql server management studio 2008 iam using windows xp it shows very less shared features while installation... i want to know why it showed so less features? is it because of poor hardware resources? |
| | i have a database ,i want to make it accessible to 3 type of users(admin,applicant,official) with different permissions .... how can i resolve,what i modifications it gonna need like to table , relations etc |
| | Example data in column1 2|3|3|3GES|5|3 |3|334|3ere||343 I would like to split this by pipes so I can update the corresponding other blank 6 columns in each row. Example Col1 Col2 Col3 Col4 Col5 Col6 Col7 2|3|3|3GES|5|3 2 3 3 3GES 5 3 I hope this makes sense! Any help is … |
| | Hi, *I have installed sql server 2008 management studio with "use sql server authentication". *I have created a database with database name:stock owner:<default> *In Vb.net created a windows application;clicked on Add datasource;changed d datasource to microsoft sql server database file(SqlClient);clicked on option button use sql server authentication n then provided … |
| | Hi Is it possible to add a new category and combining the old categories into one? It's very difficult finding answer on this category. It's **MYSQLI** & **PDO** there are some questions but not much. I had to go other forum to look for answers plus blogs but I prefer … |
| | Hello DaniWeb, I have been working on a Maintenance Application. My company builds a specific type of system using specfic types of components. What I need to be able to do is keep track of which component is in which system given a certain event. ComponentType Table: Ident, Type ( … |
 | i get this msg from sql server when i restore the back up file TITLE: Microsoft SQL Server Management Studio ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ ADDITIONAL INFORMATION: The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\TenderingSys' is incorrectly formed. SQL Server cannot … |
| | I have created a linked server in ms sql 2005 on server machine A . It links to another database(say D1) located physically on a different server machine B. I have jsp code on Server A which accesses local database on server A. Can I access the remote database D1 … |
| | hello! i am developing a simple application which will get data from different database like mssql , access , foxpro , and after getting data it will create 4 text files tows.txt , customer.txt , product.text , trasection.txt , prob is this that i am very new to foxpro , …  |
| | hi, i have records in table like this: id v1 v2 v3 1 587 21 759 2 230 4 495 now i want ouput like below: id v1 v2 1 587 21 2 587 759 3 230 4 4 230 495 i am stuck here don't know what will be …  |
| | Hi Guys, Here is my requirements: I need to pullout records based on datetime fields ranges from 12 am in the morning of 2012/6/4 and 12 am in the morning of 2012/06/05. kindly please check my declare parameter for date if it is correct. Thank you in advance. Data: Declare … |
 | hi I am having a challenge with a Fetch statement being used in a stored procedure. I am declaring a cursor and fetching data into a set of variables. The variable types match the column declarations exactly. There is data in the table from which I am fetching. @@FETCH_STATUS is … |
| | I have a column called pEditDate in the table rc_Pages I need to extract the date for each page so when the users goes to page /example the last edit date shows at the bottom. I try to do is but can't. Using SQL Server Comptact and C# |
| | |
| | Hi, These are the opening lines of my code USE myDatabase GO PRINT '@@FETCH_STATUS: ' + CAST(@@FETCH_STATUS AS nvarchar(30)) This returns FETCH_STATUS as -1. I have just opened the connection. Can anyone tell me why this is occuring? |
| | Hi guys I got a table called rc_Pages then I got a column called pName (Pages Name) and now I have made a new column called pCategory (Page Category). Since there are like 60 pages and updating the pages manually can be a big issue. I need to set the … |
| | Hi everyone, Ok, Im new to the forum so I hope I've placed the question in the right place, and here it is : I am developing a silverlight application that uses Bing Maps. The Idea behind the application is that to help land owners (farmers , agronomy businessmen) visualize, … |
| | Hello people, First of all, i'm not an experienced ASP coder at all, i usually do php/java so i'm still kinda puzzled by this language. For my current project, i need to update a piece of an intranet, written completely in ASP. since it can't be reached from my position, … |
| | i was wondering how can database replication on a sql server be accomplished? |
| | how to delete duplicate record in a table by using SQL query |
| | Hi I am basically designing a database to store our development team metrics...here are some of my tables. What do you guys think? I am having a lot of trouble coding this on SQL Server so that question is asked towards the bottom :). ProductTable: productID (PK) productDescription SprintTable: sprintID … |
| | hello ! may God bless all of you, i m good in mssql , but this is very first time that i am very confuse , the case is , i have a table , having fields 1- ContactPersonId 2- Name and 2nd table having fields 1- recId 2- ContactPersonId … |
| | I have a bunch of records that I get from doing multiple joins. # Name, ID, Date, Gender, Birthday # John Doe 111 01/02/2003 M 01/01/2001 Jane Doe 222 03/04/2005 F 02/02/2002 Jane Doe 222 **03/05/2005** F 02/02/2002 Jim Doe 333 07/08/2009 M 10/11/2012 What I am trying to get … |
| | Hi Everyone, I am facing the following problem: My connection to SQL Server 2000 (Enterprise Edition with sp4) is fluctuating a lot. It gets disconnected after one or two hours and remained so for 2 - 3 minutes and again re-establish or sometimes I need to restart the SQL Server … |
| | Hi I have databse having id and name field. In that I wanted to fetch random names from that database but the records which fetch in 1 st attempt wpuld not repeat in next attempt. May be this can be done by using some stored precedure or something else i.e. … |
| | Hello, I have a MSSQL database with a table called "people" and a table called "attendance". The people table contains the person's ID (primary key, identity increment), last name, first name, and active fields (I would only be interested in grabbing fields where active = Yes). The attendance table contains …  |
| | Hi guys Our college has a website(php, html, css) that is hosted elsewhere, but now we have a college database (mssql) on a local server and the Director wants me to link the website to the database at the college's server. Any ideas on how to do that? thanks in …  |
| | Guys, current im using MS SQL 2005. today they will change it to MS SQL 2008 express edition. My question are: 1. can I still create SSRS/SSIS. 2. i have existing RDL,RDS file. still can open it to 2008 express. Thanks. Jonel |
| | I have a nightly SSIS package that reorganizes indexes that are between 10% and 40% and then a weekly package that rebuilds for anything over 40%. But Ive noticed a lot of table do not change. Example below my Location table below is just about always at 82%. Am I … |
| | Hi all, Here's to hoping that a SQL Server guru is hiding among the ranks of DaniWeb members. I have two servers, DB01 - the production database server and BKP01 - the backup server, that are in two different geographical locations. Since some queries on DB01 are accessing BKP01 there … |
| | Hi, We have an SQL Server 2000 with one 138GB database currently used. I am worry of the performance because as time goes it becomes slower and slower. So I tried googling out the solution and I found out the DBCC Reindex command. As what I read, first you have … |
| | Is it possible to reuse an identity field value after deleting rows in SQL Server 2005? Here is an example. Suppose I have a table with an Id field as a primary key (identity). If I add five rows, I will have these 5 Ids: 1, 2, 3, 4, 5. … |
| | Hey All, Context: I am creating a feed for work, similar to facebooks, that hits the database every 5 seconds to see if an update is made and if so returns the results to the feed. The problem I have is that we have over 35,000 users and if they … |
 | Hello, I want to change the datatype of a field from Varchar to integer in T-SQL. I tried something like Modify like you use in Oracle. ALTER TABLE tablename MODIFY COLUMNNAME Datatype. But its not working in SQL server.. Any thoughts. |
The End.