So it looks like your data don't include any rows for (DEP.UserDelete = 0) AND (DEP.EventID = 654) that are between today and March 16th.

Try

SELECT * FROM DefendantEventPros

WHERE...

moonbrig (3/8/2010)

---

Hi friends,

I'm newbie in this forum. Anyone can give me any suggestion of open source tools to convert database from .sql to .CSV? I also try to find how...

It looks like you limit the data with one of the INNER JOINS from below.

Please reduce your query to those tables and check whether you'll get any values for today...

Glad I could help. 🙂

Did you try

exec sp_helpuser 'user'

to see if they belong to different roles on the two db?

I'm not sure if the rewritten versions of the attached functions will return the same as yours currently used, but it might be worth a try...

Especially dbo.GetOrganizationBedStatusID could be simplified...

@bob-2 (The-One-Who...)

It's funny that both of us came up with the almost identical solution. Including the BOL quote. Especially, if you put it in perspective to the "discussion" on THE...

wwei (3/8/2010)

---

HI lmu92,

Thank you so much for your help.

I tried, seems still not working for me.

If I change the destination data type to either money, decimal, or number, will...

Seems like you've got trapped by some display issue when using PRINT...

If you'd run a SELECT instead, it's a little different- but probably still not exaclty what you're looking for....

You could send the ID values as a comma separated list in a varchar variable to your sproc.

Run a high performing split string function to separate the values (an example...

A few questions to clarify the scenario:

What would be the sorting criteria? (I'd expect an ID or datetime column but there's none...)

How would you deal with an element being deleted?...

I'd prefer using XQuery rather than OPENXML.

Something like

DECLARE @VChr1 XML

SET @VChr1 = '<i>1</i><i>52</i><i>3</i>' -- had to do it in two steps due to SS2K5

SELECT

T.c.value('./text()[1]','int') val

FROM @VChr1.nodes('i') T(c)

Ooopps!! You're right. I missed that the [type] column holds different data. I didn't spot the different values clus vs. ulus.

Your code should run just fine.

knovak (3/8/2010)

---

Thanks for the responses. I figured out the query about 10 minutes after I posted here. I was missing the IN and GROUP BY clauses. The...

clive-421796 (3/7/2010)

---

...

Would like to hear from the likes of Jeff Moden, Lynn Pettis, etc. if they have a solution for this.

...

You will notice I mentioned Jeff Moden, Lynn Pettis, etc.

etc....