Hello,

you will get much better response if you will post your questions with table definitions (CREATE TABLE ....) and sample data (INSERT INTO ...).

If I understand correctly, what you need...

You could try this:

SELECT *

FROM sysobjects so

JOIN syscomments sc ON sc.[id]=so.[id]

WHERE so.type = 'P'

and sc.text like '%INSERT INTO yourtable%'

It isn't 100% reliable (you can miss some procedure because of split...

As has already been explained, you get best results when working with values that are really present...

Hello,

I think it is the other way round - you have to describe the logic, then we can look for solution. We don't know what you expect...

How do you know...

sandy (2/2/2009)

---

Hi Vladan,

When i run this code is sql 2000 i get an error of

Server: Msg 195, Level 15, State 10, Line 27

'ROW_NUMBER' is not a recognized function name. but...

Hello,

Either post sample data (CREATE TABLE, INSERT INTO statements) and required result plus some more info about the "features", or look up ranking functions (e.g. ROW_NUMBER()) and CASE statement in...

I checked it and either I'm blind (quite possible, I'm still only half awake)...

Ok, now it seems to be clear. Well, but it also seems that trigger will not work as you wish - trigger will fire on insert. If you have situations...

Better think again about that. Trigger that calls a...

Please show me why it won't work - find some example where my code produces an error and explain why that isn't correct. Also please explain a bit about the...

Hello,

from your post I understood that if date changes, you start from the beginning - meaning that if transaction starts before midnight and ends on the next day, it should...

dubem1 (1/28/2009)

---

I have a "Table A" with a foreign key on a Status table. The Status table contains 6 differents status.

I need a Stored proc which return how...

When inserting strings, you have to handle their length.

If you know that target column is VARCHAR(20), and the original text can sometimes be longer than that, then you have...

Garadin (1/7/2009)

---

I'd personally store the time and then just drop it when needed in queries.

Having too MUCH data is rarely a problem, too little data on the...

Hmm... didn't you mention originally that you're writing it for SQLS 2000? This won't work on 2k, it uses feature introduced in SQLS 2005.

In case you are writing it for...