HAPPY THANKS GIVING 🙂

Unless I did something very wrong, I had completely different answers *sigh* TGIF

Bhuvnesh - I have no idea what your last post ment if anything......

I appreciate you help but I dont understand a thing you have said....

Dont you mean GETUTCDATE() ?? I have tried using that but then I still need to add 8 hours to it and then do a time comparision for the...

Good question, but poorly worded... Disk IO in sp_who2 references reads as well as writes. Bouse points for those who actually got it right for the right reason 🙂

Appreciate that. Thanks 🙂

Hi Gail,

Thanks for that. I will give shot and see what happens.

Hi,

Thanks for the advice. I found the problem to be a security issue AND the fact that the MaxPageSize is limited to 901 and I was pulling down more than...

Thanks for the reply, not sure what caused it to grow so much, that is under investigation. However It is now back down to its expected size along with the...

Not bad but i need to loop through all the values returned not just one by one..... but thank you.

ChrisM@Work (7/5/2012)

---

Does this help?

DROP TABLE #Temp

SELECT Value1 = CAST(Value1 AS ntext)

INTO #Temp

FROM (

SELECT Value1 = 'XXX XXXX:Test Indexing:04 Environment and Approvals:00 Remote Operations Centre:01 Application:02 MDP:figures for MDP:Carrooda ANEF.pdf '

)...

Sample Data:

XXX XXXX:16 RHP PMC:11 Document Control:03 Documents for Review:03 Supplier Reviews:RHIO-005620 BGC:100RH-1000-CI-PRO-1001_A.pdf

XXX XXXX:16 RHP PMC:11 Document Control:03 Documents for Review:03 Supplier Reviews:RHIO-005620 BGC:100RH-1000-CI-PRO-1002_A.pdf

XXX XXXX:03 Commercial:02 Procurement:07 Purchase Orders:Major Purchase...

Hmm explain more please... Answered 10 but got it wrong. Gold told to refer to books on line, answer is 10 but here it says 10, 12 which is it...

At first glance I thought, hang on there is one row returned with the value 'a' but when I out put the results to text you can see

a

-----------

(0 row(s) affected)

Gppd...

Thanks for the positive reposnces. The relationship with the 3rd party vendor is deteriorating which is why we are looking ot move the system in house. If it was a...