Yelena,

I also agree with you.

I know that the questions and free and I have still learn something from this, and that some questions are abigious on purpose (pick the...

I am with you Terry.

I doubled checked with BOL just to make sure my memory wasn't deceiving me - I noticed the caveat so re-read the question. It didn't seem...

Ritesh,

It's looks as though you have missed out a &

strSQL2 = "SELECT qryEatingDisorder.* FROM qryEatingDisorder WHERE PageID = '" & lngRecordNo & "'" & "and EatingID = '2'"

Should do the...

Yueming,

You need to write your case statement like this:

Case when...

Also don't forget that dates in SQL Server use single quotes not #. So '12/02/2005'

Also it's a general rule to put dates in the following format yyyymmdd, as to avoid...

Hi Bob,

If I understand you correctly, you want to insert data from a query into a table but not populate all the fields in the table, in which case something...

Hi Jeff,

I did think of using SUBSTRING, but I can't remember know why I used RIGHT... I think it may have been because the account numbers are variable length, so...

Syed,

Just realised I missed a closing bracket, one after the +1, should read:

select RIGHT(mytext, Len(mytext) - patindex('%[^0]%', mytext)+1) from mytable

Obviously I should have said replace "mytext" with you column name,...

Hi Syed,

I had a similar problem when bringing together account information from three different sources and combining them into one report, without leading zeros - don't you love it when...

noggin,

I found this MSDN article:

http://msdn2.microsoft.com/en-us/library/ms189566(SQL.90).aspx

UNSAFE

Hi Lester,

You don't neccessarily have post the whole sproc just the important bits..

But having said that and re-read you previous comments. It does sound as though one the input variables...

Hi Lester,

Yes I realise that it didn't solve your sproc problem but it's best practice, and when you start using cast with a varchar bigger than 30 characters it would...

Hi Lester,

While you are correct in saying that the size part of varchar is optional in teh Cast, you should really specify the size as it will default to 30...

Mick,

RETURN is what you are looking for.

BOL shows an exmaple in a stored procedure.

Cheers,

Rodney.

This might have something to do with Financial Year Starts. If July 1st is the start of the fiscal year then July would come before December, but January would come...