Interessante, eu também tenho uma UDF que recebe uma string com valores separados por um caractere qualquer e retorna os valores na forma de uma tabela.

Muito semelhante à função Split...

I dont like triggers but they are usefull for auditing, for example. I prefer to maintain only one trigger/table where the triggers exists just to call a bunch of SP....

In my case nop. Just a trying some ideas to figure out how to make a static select using dynamic ordering in columns of different types (datetime, varchar, int) using...

The -1 multiply dont works when there are varchar columns. I tried and orderind desc results in a near random list

Thank for the posts guys.

I managed to implement a log and think i found the problem: timeouts is another trigger at the same table.

Now i ill try to implement a...

Nop,

Its a .NET application running as a service and scaning a input folder for files.

Its reads any .TXT files in the input folder to populate a lot of "stage" tables.

After...

Nice work guys!

Vladan,

yep, I wondered about a case in the where clause. Why not?

GilaMonster,

Great! I can keep the original SP and make 2 news SPs in that context.

It´s pretty good...

My definition of CHEAT is: No to follow the rules u have accepted.

If you enter a course you must accpet the school rules.

If the exams rules are ok its another...

One more point...

Dude,

this join ´ll work work fine for most instances, but put a row in T2 where F1 is null and u ll got a real problem.

select *...

If u just want to return n rows from a table (or view, etc) at random u can use the newid() approach wich a temp table.

set nocount on

select newid() as...

I´m a developer in a no dba environment. I fell like a passenger in a plane where the pilot is missing and try to avoid a crash.

Yesterday I helped a...

I´m a developer (with basic DBA skills) working at a medium size IT company in Brazil. Firts I´m surprised to see in u.s. 35-37.5 can be the standart hour/week contracted while...

Very good, a pretty thing to read after a full day of hard work.

To avoid single quoted problems make sure to validate the input. Use of single quotes is a well know SQL inject attack used from hackers. Try replace each single quotes for...