this is just a guess, where i'm trying to reduce the rows in the join by using a sub select;

does this produce results that are close to what you want?

SELECT...

well, if there was only one in the "p" table for shift 3, the issue is your joins are bringing in 4 more rows, right? i would guess the other...

well the SQL looks right, so it's gotta be the data not meeting your expectations.

i would expect the SQL below to show you that there really is 4 items in...

i believe by single developer, it is single installation. they do not want you to buy one copy and install it on 20 developers machines. 20 installations would require 20...

if your table t1 already has those values, you should be able to use the integer modulus to determine/select only those values that are perfectly divisible by 100; then do...

easily bob;

if the table exists, or if you create a staging table, there's no porblem; you want to use BULK INSERT command to do it. your example seemed to be...

when you run the profiler, does the spid in the loop change, or is it incrementing?

if it was incrementing, that would imply to me that it is getting new connections.

if...

glad i could help!

that's what i was hoping....that there was an Id, in your case, PersonId in the table. your modification looks good.

you can easily test it with this, which would insert 4...

well, I'm pretty sure you are running out of connections. it may have run without a problem previously, but breaking now because you are finally looping/creating more than 32767 connections.

since...

i've seen this before, but in a vb6 application; are you using .NET?

opening and closing a connection takes resources, and time, since the server has to answer back with a...

i think this is more like what you want:

CREATE TRIGGER tgrDefaultValue ON tblPerson

FOR INSERT

AS

UPDATE tblPerson

SET LastName = FirstName

FROM INSERTED

WHERE tblPerson.ID...

to take advantage of an index, you can't use any functions on the column in the WHERE statement; the isnull(name, '') = '' doesnt allow a Sargable search, so...

by changing, do you mean schema changes, ie new columns, defaults,constraints, datatype changes, etc, or do you mean data changes, like new rows of data,others updated/deleted

PavanKK (11/26/2009)

---

Hi All,

I am new to adminstration. can you help me with following.....

My application contains 300 tables & 1000procedures. Now am adding additional column to some tables ( say 180...