A couple of things you might want to check. Do you have the network box as a linked server on your local box? Also when you are selecting,...

I took the question to be more about do I know the difference between a function having double colon in front of it or not, and not truly about what...

Toolbox/image.

GSquared (3/10/2011)

---

Tom.Thomson (3/10/2011)

---

Chad Crawford (3/10/2011)

---

jcrawf02 (3/10/2011)

---

We actually have annual contests to see who can guess the most acronyms, and we pass out a list to new hires so they're...

Just a thought.

Try changing your

and

to

DECLARE @tmpMen TABLE (Name varchar(10))

DECLARE @tmpWomen TABLE (Name varchar(10))

Looks like varchar maybe using...

Hi Tony

Thanks for the update, much appreciated.

hor_netuk

I have the same problem - could do it fine in Crystal and SSRS 2005, but not SRS 2008.

Ok, I've had a play around and you could try this (it...

I remembered this one. Y2k Seems like a lifetime ago now!

Steve Jones - Editor (4/29/2010)

---

Also, I'm curious how you are backing up the log every 10 sec. Are you using some external program. AFAIK, jobs to schedule can be done...

Right click on field, properties, and on the format tab, choose the ... button so see list of standard formats. x,xxx is one of them.