In your place I probably wouldn't create a new table to store alternative adresses. If it is an address, store it together with other addresses; depending on the overall design,...

There is only one thing to be aware of when using this solution... MIN(NOTE_TEXT) and MIN(HTML_TEXT) are independent and the minimum value from each column is returned - which means that sometimes you...

Hello Thomas,

one question first: why are the date and time columns in your table TEXT? Date and time should be stored as DATETIME; I can understand that in an intermediate table...

Hi Jeff,

isn't there some mistake? I tested your SQL and I'm getting this error:

Invalid column name 'wugga-wugga'.

(Nevermind, just kidding ... need to joke because...

I agree, the most probable source of such problem is outer join. An example (only freely based on what you mentioned about the table structure, but shows how it works):

CREATE TABLE...

I need to extract the text after 'TestBooking="' (i.e. false) highlighted in red.  The problem is that this could read 'true' so I cannot depend on the length of text...

Almost identical question appeared several times during the last month, I'm sure you'll be able to find some of these discussions.

General warning : if you want to simply get...

Actually, I don't think this will work, Brij. Unfortunately I'm not sure what you mean by "If it is, then"... but if you're referring to the first part of the...

I don't think DECIMAL is an option because of multiple dots in the values : 1.2.1 can not be converted to DECIMAL or any other numeric format.

Your problem is not in SQL, your problem is in unclear definition of required result.

If there are 2 rows with the same SSN, which of them do you want to return?

123111111       ...

Another possibility would be to have a fixed number of characters in each part, which would mean adding leading zeros to your current data. If you know that the numbers...

Hello,

to get count of rows where Serial number is NULL, use COUNT - with * it counts all rows, with a column name only rows where value of this column...

I'm not sure what you need to do, could you describe it a bit more in detail? Maybe temporary tables could help... it depends on what the procedure does and what do...

Maybe you could find some way how to do it without cursor and dynamic SQL?

Since I try to avoid both cursors and dynamic SQL, I'm not absolutely sure about it, but...

sp_who gives information about currently active users. If you want to get some info about user permissions, a better place to start would be undocumented procedure sp_MSobjectprivs. I have no...