Extract, Transform, Load (ETL)

RE: Delete all records from a DB

• by mromm

• SQLServerCentral.com

• Reply

There is no magic (movies are excepted). You have to go through every table that has relevant data and execute a DELETE statement with the WHERE clause.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-09

RE: Use Results from a Cross Join for dynamic SQL

• by James Travis

• SQLServerCentral.com

• Reply

quote: Ah! Problem is me, me thinks. Sometimes it's difficult to explain what u have and what u want to someone else but I think we are getting there. I agree that a cursor could be a solution but I am trying to keep to set based as much as possible to satisfy the purists […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-08

2 reads

RE: select and lock next key value

• by Johan Bijnens

• SQLServerCentral.com

• Reply

create a parameter-table with a column "lastkeyvalue". Read that value for update and than its all up to you. Others cannot reach it until you release it. That is if you want to have a key sequence. You could also use uniqueidentifiers. Then you can just generate them at clientside. They are considered to be […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-08

RE: Sql server agent not installed/running

• by mybid2003

• SQLServerCentral

• Reply

Posted duplicate post in Administration with subject "How to get sql server agent running"

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-07

1 reads

RE: Use Results from a Cross Join for dynamic SQL

• by winash

• SimpleTalk

• Reply

and no prizes for guessing.... *couldn't resist that*

2003-05-07

1 reads

RE: Orphaned logins in SQL 2000?

• by Dinesh Priyankara

• SQLServerCentral.com

• Reply

I had a same problem with SQL 2000 when I restored one of my DBs in different server which had same logins because of UIDS mismatch. But this can be easily solved with sp_change_users_login 'Update_One', 'user', 'login'. Dinesh mcp mcse mcsd mcdba

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-07

RE: HELP! Query not properly displaying data

• by RD-Francis

• Intelligent Enterprise

• Reply

Quick note: you swapped the sides of the join between your first chunk of code and your second. The CSCSHBAL table should be the one the join direction referes to (on the right for RIGHT, on the left for LEFT)

2003-05-06

RE: Concurrent use of Stored Procedures

• by Rajesh-Patavardhan

• SQL Server Performance

• Reply

One alternative is to use transactions and issue a SELECT with TABLOCKX within the transaction on the tables to be locked. TABLOCKX holds exclusive lock on the table till the transaction is completed.

2003-05-06