Hossein,

sp_executesql supports output parameters, see BOL.

Jan

Robert,

My functions are not used in production yet, so I wouldn't really know about this behaviour. Thanks for the warning, I will keep an eye on memory leaks and overall...

Why not try to write user defined scalar functions that mimic this access behaviour?

Jan

As Itzik also pointed out the CLR comes in handy if for calculations; things that have nothing to do with database access, but nevertheless need to be done in the...

Mark,

A bit more background info would do nicely.

Where is the END of your BEGIN block? Surely you cannot do a SELECT INTO #tmp inside a loop because it creates a...

Luke,

If it is a one-to-one relationship, you could turn this around: create one table where you do the updates and create “Events” and “eventDetails” as views on it for backward...

Jerry,

You could use a clustered index with a fillfactor that leaves some space on the datapages (e.g. 50%) and rebuild it in off peak hours. Maybe you can make the...

I have the impression that with the updateable view and the instead of trigger, you will just end up with the same code and the same inserts but then implemented...

Luke,

One thing you could consider here is to use SCOPE_IDENTITY() to identify @maxid. This will avoid having to do the

SELECT @maxid = MAX(ID) FROM Events WHERE CreatedBy = @username

for...

Hi all,

I'm experiencing the opposite problem: I'm importing an excel with numeric data and an error in one value which is a string. I'm using the "Data Conversion Transformation" in...

Hi Camilo!

Thanks, but I never installed SQL 2000 on this machine.

And it seems I have no program called ARPWrapper.exe. Where can I find it?

Thanks,

Jan

Why would you put everything in a temp table first and join that again afterwards? Everything record in your temporary table will have to be written to the tempdb (wether...

You will need some kind of tiebreaker for the duplicates.

E.g. group by the MIN(category_id) on categories.

Jan

Try to qualify your function with the owner, like this:

select a.table_id, b.Value

from tableA a

join dbo.getData(a.table_id) b where a.table_id=b.of_id

otherwhise the parser thinks getData is a table and (a.table_id) an optimizer...

Thanks Colin,

I have the following Data Columns:

EventClass

ObjectID

TextData

ApplicationName

NTUserName

LoginName

ClientProcessID

SPID

StartTime

As event I only have "Missing Join Predicate"

But still I don't see an objectid or Textdata appearing.

Regards,

Jan