SQLTeam.com | Weblogs | Forums

Issues posting code


#1

@HarrisQ, I'm hoping this thread finds you. Can you try posting your code in here?

If it still doesn't work can you delete the cookies for this site and try again?


#2

Thanks.

I have deleted cookies and will try posting something new later. I have now written a lot more code and it has become somewhat too 'involved' for posting. However, if the code below posts then some level of success......

In answer to the question i posted, i ended up writing a series of If statements with table updates.

Example for when the first 3 letter of the string (@VarDate) where 'Sat'
------------SAT statements
If @WeekdayName = 'Sat'
Begin

UPDATE #TempBHRNELFT
SET F6 = @NewDate
WHERE @Sat= 'Sat' and id =6 ;

But i'm pretty sure i will have plenty more questions!!!!

Thank you for persevering.

Q