Recent content by collierd

Looking good now thanks Using relative referencing method Damian.

It does Glenn I can't see what this is relative to I will have a look into this Should I be using the method Could I perform this without relative referencing?

Hello I have the following macro running within Excel: Dim rowReference As Integer Dim columnCounter As Integer Dim budgetCodeCounter As Integer rowReference = 2 For budgetCodeCounter = 1 To 4 For columnCounter = 1 To 12 Cells(rowReference, 1) =...

Fixed it: Seems to be where the quotes are "=budget!R1C2 & ""*"" & budget!R4C[" & i & "] & ""*"" & budget!R4C1"

Hello Within Excel, using the following data: C1 C2 C3 C4 C5 ..to C13 R1 Leeds R2 R3 R4 Sales Jul-06 Aug-06 Sep-06 Oct-06 ..to Dec I am trying to get the following results: id Leeds*Jul-06*Sales Leeds*Aug-06*Sales...

Thank you

Hello Within Excel I have a date displayed as Jul-06 (this is 01/07/06) I have another cell with a reference in it (ASP) I am looking to concatinate these 2 cell with a * delimiter to form 01/07/06*ASP I can't seem able to do this as the system converts this to an internal date Does...

If I wanted to take this a step further and insert records that are currently missing from this list and allocate them the nearest previous date e.g. 2006-11-04 would be day 3 Is this possible?

Thanks

Hello Using SQL 2000 If I have a table called tblValidWorkingDays which comprises of a single field called workingDay (sample as shown) workingDay 2006-11-01 00:00:00 2006-11-02 00:00:00 2006-11-03 00:00:00 2006-11-06 00:00:00 2006-11-07 00:00:00 2006-11-08 00:00:00 2006-11-09 00:00:00...

Fantastic, thanks for that

Hello I am SQL 2000 I am looking to create an SP that takes 5 fields If field1 has something in it, it select something, else field2 etc (case method) I currently have the following (where the selects are there for test purposes): TestProc @field1 int, @field2 int, @field3 int, @field4 int...

I would use ` rather than ' e.g. this is my o`malley I've always used this by way of 'best practice' within the SQL environment Damian.

Thanks, i've had a look at the microsoft site. Open ended and depends on the individual I know but, how long did it take to get to a position where you sat the exam. Been looking around from there and the book for just the one exam is 1024 pages - i've also see suggestions that this book doesn't...

Hi I've been using SQL Server 2000 for some years now and just fancied getting some qualifications This is not only for 'CV' purposes but I also would like to establish what I know/don't know and improve my knowledge of SQL Server MCDBA seems the most sensible option In all likelyhood, what...