Easy Working at Home $1000 Monthly Income! Homebased Job Directory plus information package of Education, Knowledge, Wisdom World's Premier Web Based Company Offering Click it now: www.l-red.com/index.asp?REF=megna visit:http://classifieds.byindia.com/detail.php? siteid=3571&cityid=168&show_...more >>

Hi, Does full DB backup in SQL 2005 includes trans log backup too? if yes does the trans logs are truncated @ server? thanks and regards prince...more >>

Hello, I have a table tblInput like this: CREATE TABLE [dbo].[tblInput( [NameID] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Date] [datetime] NULL, [Value] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] with data (sorry, no SQL INSERT...): NameID |Da...more >>

I need to write a trigger that updates every record inserted to database. this trigger will update only one field lets say 'branchofficename' field in table. But in my VB application, that uses that database and that table, I need to declare a database-wide parameter, lets'say Branch_Office_Na...more >>

Hi, How can I dump my BD structure into some sql file? Regards, areq ...more >>

Is there a way to round up in sql? For instance, I want automatically round 0.3 to 1, 1.1 to 2, etc. Using the "round" function I only seem to get traditional rounding effects (ie, once the value is more than half a round up will occur, however less than half way to the next higher integer rou...more >>

I am writing a table load process that I'd Like to control by one main stored procedure. That main stored procedure executes multiple store procedures that each creates & inserts multiple rows into the SAME table. My logic is as follows: (Don't worry about the syntax of the SQL) Create Proce...more >>

After I create ENDPOINT for SERVICE_BROKER, will I see port open for listening (np via netstat)? (Servis Broker is enabled on both databases, and so (I am able send and receive messages using LOCAL route)). sys.dm_broker_connections view is empty. When will I see any connection in t...more >>

when i came this morning, database was down and got a error message. there was no error message n a log file. this was the message n a screen. 'database 'Ocean is alreay open and can only have ine user at a time' I fixed the problem but I dont know why the database went on a single user mode...more >>

How to prevent row data changes on system table such as master..sysusers table. Thanks -- bic...more >>

Hi, I have a two tables with ~5M rows. They have 5 to 10 foreing keys. Almost all of them are indexed. It's a data warehouse so there are only few updates. There's batch insert sometimes. Select statements are really fast, but when I want to delete, it's a real pain in the neck. In the ...more >>

Hello All, I would like to create a table from a query. The query is a complex one with results being generated from 9 tables. I will do some manipulation on the table and then use it for reporting. I cannot use the view here. Please help. Regards Gopal...more >>

I am relatively new to sql 2005. I am wondering if anyone has a sample of a search query that could be used to determine all stored procedures, views, etc that would be associated with a table? If anyone has a sample of such a search query and willing to share it, that would be great. Let m...more >>

hey all, i have a stored proc i'm working with: i need to take the current date go back a certain number of months specified in the parm. for example: SET @monthsDifference = DATEADD(month, -(monthsBack), GETDATE()) which takes us to: 12/26/2006 1. what i'd like to know is the eas...more >>

Hi, I can't Copy a database from Sql Server 2000 to 2005. I am using the Copy Database option from Management menu. I want to transfer all tables, and all stored procedures. I've tried everything for the past 3 days, and it didn't work. I always get the same error. Below is the error that I...more >>

Hi All, I have a sqlstatement as below: select * from sysindexes where indid < 255 and (status & 64)=0 But I don't understand what is the mean of 1) indid < 255 and 2) (status & 64)=0 Would you please explain it for me. Thanks In Advance, JP...more >>

I have a table TableA (Col1, Col2, Col3) which contains 5000 records. Col1 is the key field. Another table TableB (Col1, Cola, Colb) contains 300 records, Col1 is the key field. Another table TableC (Col1, Cola1, Colb1) contains 100 records, Col1 is the key field. I want to return all 500...more >>

hey all, i have the following 2 tables: table1 ------- employeeID(PK) ,Name ,status (part-time/full-time) ,startDate ,endDate table2 ------- employeeID(FK) ,status (part-time/full-time) ,startDate ,endDate Sample Population: table1 ------- 1, John Smith, null, null, null 2, Ja...more >>

Hello there I have some process that i can't run on single sql query. In order to run it i must split the huge query to 3 temp tables and run it. The problem is that i can't use temp tables on function but only on store procedure. Also if So i thought using table variables. I used it ...more >>

SQL command: UPDATE tblGrossUpFixedIncome SET FixedIncome = '3,4,5,6' WHERE KeyID = 1 SQL Server 2000 result: "Cannot implicitly convert varchar to money. Use CONVERT." SQL Server 2005 result: FixedIncome field now contains 3456. How do I get the UPDATE command in 2005 to giv...more >>

I am not sure which is the right newsgroup to post my message, so sorry about the double postings. I have a stored procedure SP1 which gets its data from another stored procedure (SP2) that is nested in it. SP1 will not run the very first time by itself, it basically fails. After I have exe...more >>

I am trying to pull together information from two different Linked Server databases. Let's call the LinkedServerA and LinkedServerB, both of which are Oracle databases. So, what I want to do is pull the following Columns from LinkedServerA: ANUMBER, FNAME, LNAME, C_ID, S_ID, STATE And ...more >>

Msg 8624, Level 16, State 1, Procedure PurgeReceipts, Line 14 Internal SQL Server error. This is on a SQL 2k server. I tried the same on a 2k5 server and it worked fine. I don't know how to troubleshoot this. The print statements do not show. CREATE PROCEDURE PurgeReceipts AS PRINT '...more >>

When I go to set up SQL Agent mail, teh mail session area is greyed out. How do I fix this since it does give me the option of choosing a mail profile. I have outlook installed on the server...more >>

Hi All, What is the optimize number of fragmentation to allow for table before we need to run the "DBCC INDEXDEFRAG" for the table to improve the performance, Thanks In Advance, JP...more >>

Hi. Can someone remind me how to do this? I have a table on which there is an Update trigger. Works fine. However there is also a scheduled job that runs a batch update on that table every week which then also fires the tigger for every row in the table. How do I prevent this happening and...more >>

Thanks in advance for help received. Accounts can be created any time Accounts can go years before an opportunity is created Accounts can have multiple opportunities in a year Any Account that has an year(opportunityDate) = 2007 but does NOT have any previous years opportunities Crea...more >>

hi all , if i have table that contains 50 columns and 120 rows (data's ) . if i m executing a (select / insert /update) query . i have some server specification and client specification , and n/w specification . i want calculate time , that select query should take , update query sh...more >>

I need to calculate a datetime for the start of the current week (Sunday 12:00:00AM) and a datetime for the end of the current week (Saturday 11:59:59 PM). I've written some long-winded code to do this involving building up strings and then explicitly or implicitly casting them to datetime....more >>

Hello SQL gurus, I have a query as follows: SELECT DISTINCT P.PlantDescription, 'SETUP' AS TransactionType, SUM(MT.ActualMinutes * MT.Crewsize)/60 AS [SETUP run labor hours] FROM dbo.GLB_Plant_MASTER P LEFT OUTER JOIN GLB_BusinessUnit_MASTER B ON P.Depart...more >>

I am using opendatasource to insert rows in excel. First i clear the Excel sheet all rows to NULL, I am noticing that the new rows are always appended from the last insertion point in the excel rows. Is there a way to clear the excel sheet and insert rows from the top of the sheet ? thx ...more >>

Hey All, Just wanted to say i am still green with writing complex SQL Queries so please bear with me. I have 2 tables 1 containing an employee number (table:1) which is bound to the type of system they are using and another table which specifies the universal employee number(tabel: 2) for t...more >>

I have a critical production system. There is an application.. that runs as a Windows Service that continually queries a SQL Server 2000 DB, on Windows 2000 every second or two. A user went onto the system and executed a complex query, that ended up causing SQL Server to utilize 100% of the C...more >>

Good evening, all! I have a field that will contain between 2 and four alpha characters and upto 8 numbers. So all of these are valid: AB12335 MEAB4567 RNAP3456789 XY87654321 I need to left pad the number to be exactly eight digits. So I need the above to be: AB00012335 MEAB00004...more >>

Hi, We have a very large SQL Server database of around 2-3 Billion records. Each table holds hundreds of millions of records. Each table has the same simple schema: emailsender: varchar (255), emailreceiver: varchar (255), date: datetime id: ...more >>

Hello All, I have a table like this Id Target 1 access 2 access 3 acrodynamo 4 acrodynamo 5 addrecord I have a second table like this Id Destination 1 access 2 addrecord 3 afptrouble 4 approvals 5 auxlayoutmap I need to find all of the records in the fi...more >>

I am VERY new to SQL programming and don't know if this is the correct place for this post but here goes. I have a spreadsheet in excel that I use ODBC to pull data from an SQL database. I can do the basic stuff (select fields from a table and return them). Normally I return the data to t...more >>

This query is slow on my production server: Select Top 10 * From Data Where (GetDate()-Created > 365) And (GetDate()-Modified > 60) Order By MyPrimaryKey Data has about a million rows (each record is not very large). Created and Modified are datetime columns. I have separate ...more >>

Hi can anyone help me out with the sp_helprotect procedure. i need the servername and databasename alongwith the output of sp_helprotect in a table. I have 100+ servers and multiple databases on each other. Can you anyone over here help me out for the same. Wuld be much obliged. Thanks in advance. ...more >>

Got a question with a stored procedure... Create Procedure GetCCInfo ( @TickNumAuto nvarchar(255), @ExpDate datetime Output, @CardNumber bigint output, @CardType nchar(10) output, @NameOnCard nvarchar (50) output, ) as select cc.CustomerID, cc.CardType, cc.CardNumber, cc.ExpDate, cc...more >>

Hello, here is my issue, I have one database using MS SQL Server 2000, that has a table with first names, middle names, and last names stored in it along with other information. I have written a stored procedure that when a certain flag in that table gets set the information regarding that perso...more >>

Hi all, Long time programmer/jack-of-all-trades. Using a linked server set up in SQL Server 2000, connected to an Oracle 9i instance. I need to query specific rows of data in several large Oracle tables from several SQL Server stored procedures via an already defined linked server using the MS ...more >>

Dear All! i have following two tables and sample data create table worktab (Rno smallint,atype tinyint,number int,amount int) go insert into worktab values (1,1,12,6000) insert into worktab values (2,1,12,16000) insert into worktab values (3,1,12,26000) insert into worktab values (4,...more >>

Hi group, I am making a login system for an instant messenger. What I want is a fast way to find a users primary key (UserID) in a "Users" table by using the "UserName" and "UserPassword" columns. Then check if there exists a "loginsession" with that "UserID" in the "LoginSessions" table an...more >>

I am an application programmer using a front end component which has a property link to a Boolean field of a dataset. It is fine when I connect the MS Access, as MS Access has field type Yes/No. However, for SQL 2000 it has no data type of Boolean or Logical or Yes/No. How do I return the fie...more >>

hi all, can anyone tell me how i would take a positive number x and make it a negative number x. but when doing this i will not know the value of x. any pointers would be grate full Simon Whale ...more >>

Hi all, Newby here - with a problem! I have two tables (A and B). Table A has a unique id (Aid) and table B has its own unique id (Bid) but also a foreign key which is table A's unique id (Aid). Table A Aid (PK) Table B Bid (PK) Aid (FK) When inserting a new record into table A...more >>

Guys, I have to extract old data from one table and insert it into a new table. This part is simple but the problem I have is the new table has a column named storyID. This doesn't exits in the old table. I thought I could do something along the lines of insert into new table (select from old...more >>