Hi

I'm not sure if I got you. What about "BEGIN TRANSACTION" "COMMIT TRANSACTION"?

Greets

Flo

Hi Guys!

@paul-2: Thanks for test data! 🙂

I always prefer the joined UPDATE:

UPDATE e SET

e.memostatus = CASE WHEN m.employee_id IS NULL THEN 'N'...

New data? Thought there will be no new data.. :doze:

In this case take Bru Medishetty's advice. Do not shrink the database. Delete old data take backups of your database and...

Hi

Error says all. Label "Endproc" is not specified within your procedure body.

Greets

Flo

Edit

BTW: GOTO is ugly 😉

Hi

In this case shrink seems to be the correct solution.

Greets

Flo

Very generic question...

First and best way to prevent any SQL injection:

* Don't allow clients to create dynamic SQL. Secure the complete database with a stored procedures interface

* Do not use...

Hi

Just a little hint:

Keeping xp_cmdshell disabled in server configuration is a little security fake. Only users of "sysadmin" group are allowed to execute xp_cmdshell and each "sysadmin" is able to...

Hi Pedro

First your index question:

The order of the columns is very important for index usage:

If you have an index containing columns (in this order):

c4, c1, c5, c2, c3

and you query...

Hi

Jeff points to this article:

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

@aravind

Be careful with these kind of statement. This is a triangular...

Hi

You can use a SQLCLR procedure or a SSIS script task using .NET to encrypt the files or move them into a database table.

Greets

Flo

Hi

Try OR:

WHERE

(EndDate < CURRENT_TIMESTAMP AND StartDate > CURRENT_TIMESTAMP)

OR

(EndDate >= CURRENT_TIMESTAMP AND StartDate <= CURRENT_TIMESTAMP)

BUT

Have a look to your execution...

Glad I could help and thanks for the feedback! 🙂

MS Connect is a place to go if you find a bug which isn't too important for you at the moment or when you have a workaround.

If you have a...

Hi

You can write a SQLCLR. Why without xp_cmdshell?

Greets

Flo

Hi

A very common error (I learned, too). UPDATE is the most dangerous statement in SQL in my opinion (something I tell people whenever I conduct a class). It's a psychological...