Recent content by unclejimbob

Yes, create a before insert trigger for the table and use it to populate the key number column. create trigger setKeyNumber for mytable active before insert 10 as begin new.keyNumberColumn = <<sql used to generate the keyNumber value>> end ^ ujb

select the_number*-1 from the_table

I moved country/job and I'm no longer working with InterBase...

Y'know I'm sure I've seen that left join plus null idiom somewhere before - and recently too. Give me a minute, I'm sure it'll come to me...

From what I can see this is because "SELECT MAX(ExamDate) FROM MathHistory" gives you the max exam date for mathhistory rather than just the max exam date for max history where maxhistory.classid = StudentRecord.classid, therefore you will need to include the same selection criteria for the...

Try SELECT * INTO dbo.shopping_TSR FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=c:\inetpub\wwwroot\fileuploader\upload\tmb2.xls', 'SELECT * FROM [Sheet1$]')

If I read this right your report parameter is multi-valued and you want to carry out some processing to ensure that when you check a particular list value (in this case 'All'), this action then causes all the other values in the list to also be checked. If this is so then I'm not sure if what...

Thanks, this also relates to a question I posed back in May about why I should be using dateadd when I don't need to return the time component. I will add your observations to my grab-bag of cool tricks - and this therefore deserves a purple thingy. :-)

Dunno about it being the best way but here is one way. DELETE FROM [table-a] FROM [table-a] ta LEFT JOIN [table-b] tb ON ta.site_no = tb.site_no WHERE tb.site_no IS NULL

Not familiar with PHP over FireBird but I'll have a stab, the SQL syntax shouldn't really affect what you are doing, as long as you are doing something like this: select my_blob from my_table where my_table_pk = x Then as long as you have defined the BLOB sub type as text you should be able to...

Parameter sniffing - don't know if this is of any particular help but I was caught by the parameter sniffing issue a few weeks ago; I had managed to solve it, I just didn't know why it was happening :-) Anyway for what its worth I wound up setting a local variable to the value of the parameter...

What is the error that you get when you try and establish the connection ?

I don't have this exact environment but I'll have a stab at it. What is the problem ?

No, what your suggestion will give me is this: Male Female Total Single Married Single Married USA 10 5 2 20 37 UK 20 6 3 30 59 If I add a subtotal to sex, I get precisely that - a sub...

Thanks for the reply Geoff, have a good one ujb