Yes, I've seen everything under the sun too. I still like what I was told to use when I started my current, very long term project:

t_ for tables (fyi...

I really wouldn't expect to see much, if any, difference. One question though, why does your WHERE clause read

WHERE TBL_STATUS = @ldeleted_status = 50025

and not

WHERE TBL_STATUS = @ldeleted_status

?...

I'd have to agree with folks on this one. I have done both. We still use a procedure in our Sybase database to get the next ID to...

Might I suggest that you use a NOT EXISTS? It should perform better than a NOT IN. It's also curious that I couldn't reproduce your issue. It...

It still sounds like the users that can't run it aren't members of the appropriate group. What happens if you grant the exec on the stored proc to 'public'?...

Personally I would only invite a DBA if it made sense. The majority of the developers either know enough about SQL or have other developers they can use as...

If there is only one row coming back from the IDTABLE you could do something like this:

DECLARE @ID INT (?)

SELECT @ID = ID FROM IDTABLE WHERE EMAIL_ADDRESS = 'key1'

DELETE FROM...

Zoltan,

I think you missed the point. You really shouldn't name your variables like that. You should do as a number of folks have pointed out. Have a...

I always clean up after myself as well.

Gary, Even if you don't drop the temp table within your stored proc you can run it multiple times within QA. When...

You are probably going to have to cursor through this to do row-by-row processing as you have a lot of subqueries that are likely to return multiple rows. For...

I have been using DBArtisan for years with regard to data querying and manipulation. A lot of folks here use RapidSQL but only for Sybase as they think you...

Definitely NULL. I would never even consider using a blank. In fact, it drives me nuts when a front end tool inserts a blank instead of a null...

If you are having problems with temp tables and Crystal Reports you could always create a stored procedure. Crystal should play nice with that.

Yes, you are the Gary I was referring to. I apologize as I didn't follow the whole flow. I did learn something new though. I'll put OpenDataSource...

Gary,

Looks like you are opening a text file. I think Guarddata was looking for outputting to a file. Can OpenDataSource be used for outputting?