>> So I have a stored procedure <<

Why? You are doing a computation, so if you put it in the view. It will always be correct, it will port. Since...

You might want to warn him that the code you proposed does not work because of cardinality errors in the old Sybase UPDATE .. FROM .. WHERE. And of course...

>> I have to check if record [sic] exists in table, if there is record [sic] then UPDATE else INSERT. <<

Please learn to post DDL, as per the forum...

Several years ago I got "Fizz Buzz" as an interview question. It is not that tricky, but people tend to write something like this:

CASE WHEN x % 5 = 0...

I am not sure exactly what you want. I see you used camel case to make the the code harder to read (Google it and see the research; your I...

I always used a query with an integer parameter, but now it has to change to more integers in the parameter.

Before:

DECLARE @Param INTEGER;

SET @Param = 1

SELECT *

...

>> I'm having some trouble finding a solution to a problem, its been a few hours now and I think I just completely loose track of what I'm doing and...

>> I am looking for a way to create a query to SUM and GROUP BY by using IN clause [sic: predicate, not clause] similar to below. <<

Why did you...

Yep, and nobody takes Latin either. Yet everywhere you look,...

I need help with an SQL query. I have a "Master list table (X and Y categories)". I have to compare the above list with two Sub list tables -...

I think you...

Let's ask the poster; was this data from a spreadsheet or a string of some kind?

COBOL, COBOL, COBOL, you really should get yourself out of the '80s, it's time...

You do not understand the difference between a string and a numeric in SQL. Registration numbers are called "tag numbers" in data modeling; they are a name of an entity...

>> I want a SQL function that will allow to make one update but with several replace on the same column. <<

UPDATE Foobar -- we have no DDL or even...

>> I am having issues with the following script. I have 3 tables that link together. <<

We do not use "link" in RDBMS; that is assembly language. We have references...