Well now Noeld, you know . 3 sources give her location around this town so it can't be wrong (work location at...

Select convert(varchar(10), getdate(), 110)

Check out BOLS if you need a different formating (under convert/datetime and see which value you need to use instead of 110).

Should be pretty easy to do (not jixing it hopefully). Can you post the expected data you want from the query?

Let's try again then :

US, VIRGINIA, FREDERICKSBURG, COX COMMUNICATIONS

Is that source better?

BTW you would be a nice discovery since you always try to hide in your corner

Considering you're reaction and your fear to be discovered I'd say I hit the bull's eye right on. I never disclose my sources for this type of info

That should be : you're welcomed again .

Falls Church, Virginia, USA .

Need the adress too?

Now that I tried it and saw it failed so greatly, I'll have to stop doing that.

I just realized that you were calling an extended proc... I thaught it was a normal sp and that the whole work could somehow be encapsulated in a single operation.

Normally...

The one time I try to be modest, you don't get it. Well I'll have tried once .

You'll have to turn the profiler on to see what's going on... Maybe you could check the db size every 5 minutes combined with a full trace. when you...

Who is he gonna marry????? .

Ya but mines are always clear in my mind when I write them .

for the table script : Click on the table(s) in EM, right click/copy.

If you want to send sample data which would be appreciated :

Help us help you

That's why I want to anser... but you won't even need the loops once I can convert to a set based version.