Patrickn,

I'm doing the same thing now with my project. In RS, I link to my datasource and insert my query and I do all the formatting I need in...

You could perhaps do a row_number() over partition..... that would work.

-M

OK, I'm sorry, Lynn. I see where you're coming from. I interpreted your statement differently. My apologies.

Michelle :blush:

You shouldn't be so gumpy Lynn... Remember back in the days when you were working on a problem and you just couldn't figure it out and your boss has...

Ravi,

Try to thoughly understand what the user requirment is and the objective and don't assume what you think the user needs. You might be making it harder then it...

Hi Tyler,

I'd suggest hooking up with some of the dba's at work and ask them what they're working on and have them show you examples and ask them for their...

Ravi,

I'm not sure what you're after but if you want to aged a column you would use this statement.

datediff(day,[column name2], [column name1]) AS [Days Aged]

I don't know if this helps...

Hi Jack,

I went to Report Properties and I created three variables;

Name | Value

Region1 | 10

Region2 | 20

Region3 | 30

And I'd like to use each of these three variables in three...

Thanks thetodaisies! I found what I needed. 🙂

Michelle

Thank you Jack, I found what I was looking for. I think I just needed to get away from it for a while.

Another question for you though... I...

Dude! That's freakin' awesome! I am definately most impressed....

Aw, I'm so happy now. I didn't even know how to conceptulize it and you knew exactly what I...

Thanks Bob. That was really nice of you to write back and taking the time to help me.

Michelle :kiss:

Hi Bob!

Thanks for replying. There could be a total hundreds of orders per month, maybe around 600 - 800. But total of matching serials numbers with the same...

Here is the code to search an entire database for keywords. This should do the trick.

I know... stupid variable names, I was bored one morning. 😛

Michelle

SET NOCOUNT...

Oh, that very interesting Bruce! I never thought about doing that way....

My .CREATED_AT is actually stored as a numeric(15,0).

I'm going to try what you suggested and see how that...