Recent content by jby1

It is my understanding that GetTimeZoneInformation() can only be used to retrieve details of the current time zone. I need to be able to get details of the New Zealand time irrespective of the time zone of the PC running the application. I realise that it is possible to use...

Hi I have to implement some business logic that switches at 07:00 New Zealand time. This is the case regardless of there the logic is being run, ie NY, London etc. I cannot find any TimeZone classes, and it looks like Microsoft have taken a decision not to support this kind of thing anyway...

Hi A database I am working with has a UDT which is defined as not nullable. However, I am able to set variables of this type to be null, as well as assign null to table columns of this type. This seems like strange behaviour to me. Can anybody tell me what setting a UDT to be not nullable...

The subject kind of says it all really ... Is there a limit on the number of columns you can return in a query? If so, what is it? Thanks!

Thanks Borislav, I am liking your solution very much :-)

I have worked out a solution (although it may not be the optimum one) declare @t table(trans_id int, status int) insert @t values(1, 1) insert @t values(1, 2) insert @t values(1, 2) insert @t values(2, 2) insert @t values(2, 2) insert @t values(2, 2) insert @t values(3, 1) insert @t...

Hi I have a table that can contain numerous records with the same transaction id, each of which can be set to one of a number of statuses. I would like a query that will only select me transaction ids where they are all set to a specified status. For example, for this table (run this in Query...

I don't have SQL Server handy, so I cannot give you a coded example ... however If I was faced with this problem, I would go into Query Analyzer and build up the create table statement using a loop. Then I would select the statement string and copy the output from the Output Window. This...

I cannot think of any circumstances under which this could be useful. If you need a consecutive numbering of records, could you not create another column in the table, which is not an id field. Then do your consecutive number on that field? Would be helpful if you explained why you think you...

I have just found an article that suggests that in order to use Windows Integrated Security for accessing a SQL Server database from an ASP.NET application, the database must be running on the same computer as IIS. Is this correct? It seems like a terrible rule to me! Or by computer, do they...

Hi I have developed an ASP.NET application which runs on an intranet, and uses Active Directory roles for Windows Integrated security. I have up until this point been using a single SQL Server account to access the database, which is stored in the web.config file along with its password...

Can you give me a clue as to what style it is? Nothing is jumping out at me from the style sheet reference

Hi I would like to use a Multi Line TextBox, but I only want it to display scrollbars when they are required (ie when the text doesn't fit into the box). Is this possible? I am think I already know the answer, but figured it is worth asking the question!

Yes, it is!

Thanks. I think I was just being a little thick!