Your Welcome,

Glad I could help...

^__^

You welcome ^__^

Hi there,

Try this one

SELECT REPLACE('hóla','ó','o')

Tell me if this was helpful or if it needs some modifications.. Thank you ^__^

Hi there,

Lets take it one by one. the 3 procs are just samples, focus your sample on the TODAY proc. the three are the same only the other two stores...

Hi there!

Heres an easy way

Just create a table which will be used to store the stored procedures name or Id and when it was executed.

Now, in every sproc, just record...

Hi there,

Sorry but I thing this forums does not post words inside the... sorry for got what their called... the symbols used for xml and html.

anyway, could you rewrite the...

Hi there,

Try this one... I hope it helps...

(Although this example uses dynamic SQL)

DECLARE @tableName VARCHAR(MAX)

SET @tableName='NotExistsingTable'

IF NOT EXISTS(SELECT [name] FROM sys.tables WHERE [name]=@tableName)

BEGIN

SELECT 'The table does not exists'

RETURN

-- Or just...

😀 Hi there,

Sorry this came late, I was a bit busy with my work...

By the wa thanks for thwe new sample... Now we're talking...

Saw your problem and I think I...

Hi there,

In addition, join is used in the ANSI Standard... well that's what I heard...

I didn't even know you could use commas since in almost all books and inforation on...

Hi there,

No offense but why not just use a stored procedure?

I'm not that familiar with triggers because I don't use them. Heard that there were issues in them and I...

Uhmmmmmm... Hi there,

I'm a bit confused about what you want. Could you or anyone explain a bit more. It would be better if you can give us some sample data...

😀 Hi there,

Hope this helps... 😉

--Let's first create our sample data

DECLARE @tbl TABLE

(

IDINT

)

DECLARE @i INT

SET @i=1

WHILE @i<=50

BEGIN

INSERT INTO @tbl

VALUES(@i)

SET @i=@i+1

END

-- create temporary tables for teams

DECLARE @teamA TABLE

(

IDINT

)

DECLARE @teamB TABLE

(

IDINT

)

-- Randomly...

AAAAAAAAW... Sorry about that gila. Didn't see the picture perfectly

sorry for bad english

Hi there,

I created a procedure for converting decmal to binary, hex, and oct... although... it only converts numbers:P

Hi there agian,

My bad... I didn't notice that the decimal takes 2 decimal places which means 0.025555 was rounded of to 0.03 when I stored it to the variable, it...