Database

Do a search for tutorials creating a music application (book would be similar), work through the tutorial. You question shows a dramatic lack of understanding of what you are attempting, the tutorials will deepen that understanding and allow you to ask sensible questions. Never underestimate the power of human stupidity RAH

UP for my question

Daaron wrote: crowdsource the solution? Solution to what exactly? As a guess you are referring to back claims. If so then the back log is probably caused by a lack of humans an/or effective process control. Software might help with a solution to either of those, but software itself is not a solution.

Right. About what I'd expect.

Assuming you have a list of PIDs you want inserted you require 3 statemants, Declare @NewID int Insert SS (fields).Values Set @NewID = scope_identity() insert Comp(SID,PID) Select @NewID, PID from listofpids Never underestimate the power of human stupidity RAH

2 things, do NOT put your email in a forum message, edit it out ASAP. If someone needs to get to you directly they can use the email option at the bottom of the posting. Define what you mean by distributed you can install 2 instances of SQL server on the same machine this could simulate a distributed environment but you need to be more explicit. Never underestimate the power of human stupidity RAH

Dammed if I know why someone would down vote this it is a perfectly valid question - balanced. Never underestimate the power of human stupidity RAH

Doesn't Oracle have a "create procedure" or something similar? :) Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

Well said: I used it on a couple of projects but have now gone back to ADO and my own DAL as it gives me more control and I don't feel that ORMs are the be-all and end-all. "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. Those who seek perfection will only find imperfection nils illegitimus carborundum me, me, me me, in pictures

I agree. I was just pointing out one of many things to look at.

Member 9671482 wrote: Please give answer. Fetching a lot of data takes a lot of time. There's no cure for that, other than fetching less. Here's some idea's you can try if you need more speed; verify and update the indexes (what fields are you using in your search?) look into (horizontal) paritioning select fewer columns (are you really using them all?) execute the optimize table[^]-command to compact the table (if deleted a lot recently) Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

I use TIME with SQL2008. You can use the CONVERT command to give you the time portion of the DATETIME column as a VARCHAR. (Look at 108)

thanks I'll give it a try!

What is it with you people today, the previous bloke wanted to use a trigger, you want to deploy a dtx and schedule it with some tool. USE A SQL JOB. That is precisely what it is designed for! there are a whole bunch of stuff available [^] Never underestimate the power of human stupidity RAH

My usual attempt to resolve a sql error is to drop the error message into google[^] - seems like it is a common problem. Never underestimate the power of human stupidity RAH

I wouldn't do that. It's against the "Rules" of normalization. You don't want to make a row dependant on another row in the same table. Think of all the fuzz to update the table when you find out someone inserted some wrong data last year, or when HR decides to change the rules (quite probable actually). So you should make a query that gets you the result you want instead. Hint, checkout ROLLUP. For example: SELECT EmpID, CASE WHEN (GROUPING(Leave_Year) = 1) THEN 'Total Balance' ELSE ISNULL(Leave_Year, 'UNKNOWN') END AS Leave_Year, SUM(Balance) AS Balance FROM MyTable GROUP BY EmpID, Leave_Year WITH ROLLUP I haven't tested this code, but it should give you an idea. I also assumed SQLServer, Different Databases have different syntax. Use Google. Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln

Bikash Prakash Dash wrote: You have to provide any value for that No you have to provide the correct key, any key will corrupt your data. Never underestimate the power of human stupidity RAH

Firstly, you have to download the Oracle Database Software. go to oracle.com and download the software. I suggest to download 11g R2 windows version. It's more easier to install on windows than on Linux. nothimg