2,935 Topics
 | |
| | 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 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 … |
| | 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 … |
| | 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. |
| | I created an instance and did some fault while moving the files from one location to other and now the server doesnt start and i need to execute a query in SQL SERVER Management studio in order to open a new query feature it again ask to start the server..the … |
| | Guys, Using this query, i got an error. any idea guys. what method should i used for this report. Im using text queries instead of SP. thanks. The variable name '@FromDate' has already been declared. Variable names must be unique within a query batch or stored procedure. Fromdate:'2012/06/01' FromTime:12:00AM Todate:'2012/06/29' … |
| | I have two tables. One with orders and one with lines items for the orders. The line items have a unique code that relates to the line item number. When sorting on this unique code, you are able to see the order in which the item was added to the … |
| | Ohayo I Hav a Doubt regarding the storage of database.. Suppose i have a college database...among Master Model Tempdb MSdb were do i store this college database??in master?? even if i create a new database how to add the new data into the existing database??  |
The End.