from the docs:

NOLOCK

Does not issue any locks. This is the default for SELECT operations. It does not apply to INSERT, UPDATE, and DELETE statements.

Note:

With SQL Server, a NOLOCK...

ping. anyone?

hi beeke.

you can't insert/update/delete data with a function. you'll have to use a stored procedure instead. this sample code below should get you started.

create table movements (

...

CREATE PARTITION FUNCTION pfNameRange(char(20))

AS RANGE RIGHT FOR VALUES ('E', 'I', 'N','T');

would divide the data into 5 partitions:

1: < 'E'

2: >= 'E' and < 'I'

3: >= 'I' and < 'N'

4:...

is the forum for a school work assignment, or is the forum to be used by your school?

if it will be used by your school there are quite a few...

myschif (2/25/2008)

---

Thank you all for the information.

Adam - I tried your code and received the following message:

Must declare the scalar variable "@PreGrpBal"

I am unsure how to resolve this.

Additionally, I do...

also look at this thread: http://www.sqlservercentral.com/Forums/Topic453576-149-1.aspx

although deprecated, you can still use it. just get it from the SS installation disc.

http://www.informit.com/articles/article.aspx?p=364263

you have an embedded OpenQuery() that's causing the problem. eliminate it and it should be fine.

'Select CCNVFC From BPCSFFG.GCC

Where CCFRCR = ''USD''

And CCTOCR = ''PLN''

And CCRTYP = ''MTHEND''

And CCDATE...

The case statement prevents the search on sCustomerSys from being optimized....

if i understand you, the stored procedure will be updating a target table and a trigger on that table will adding data to an audit table.

if so, why...

awells (2/20/2008)

---

I have an INSERT, UPDATE trigger on a table which populates two calculated fields for that table.

I have a sp that inserts on average 400+ records per batch. The...

change

SELECT x.i.value('.', 'VARCHAR(7)') as ID

to

SELECT x.i.value('.', 'int') as ID

if your IDs are indeed ints and not text.

lfmn (2/19/2008)

---

I have two tables I am trying to join. One table, tItem, contains action items. The relevant columns are ItemID, Owner, Manager and Requestor. For tPerson, the second table,...