Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jby1
  • Order by date
  1. jby1

    Timezone issues

    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...
  2. jby1

    Timezone issues

    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...
  3. jby1

    UDT not nullable allows nulls?

    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...
  4. jby1

    What is the maximum columns in a query?

    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!
  5. jby1

    grouping question

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

    grouping question

    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...
  7. jby1

    grouping question

    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...
  8. jby1

    Create table using loop

    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...
  9. jby1

    keeping ids consecutive after removing data

    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...
  10. jby1

    Security Question

    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...
  11. jby1

    Security Question

    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...
  12. jby1

    Mutli line Text Box without Scrollbar

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

    Mutli line Text Box without Scrollbar

    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!
  14. jby1

    what does this return?

    Yes, it is!
  15. jby1

    newbie query help

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

    newbie query help

    Ooops, as I sent that post, someone answered the question!!
  17. jby1

    newbie query help

    Hi You might get a better response to your question if you include a description of what output you are expecting to get. It is quite hard (for me!) to see what you are trying to achieve with this query!
  18. jby1

    Master page and user control

    How are you setting the content page to the master page? Where are you trying the register the javascript?
  19. jby1

    Problem with connection pool

    I have been watching it this afternoon, and I am now 99% sure that this has solved the problem. Into the bargain, I now properly understand how connection pooling works, and have learned a few useful DBA commands. So a success all round!
  20. jby1

    Problem with connection pool

    I think I have solved it. The problem seems to have been in the SqlHelper class (which I believe people here have modified) It was with this code: // Call ExecuteReader with the appropriate CommandBehavior if (connectionOwnership == SqlConnectionOwnership.External) { dataReader =...

Part and Inventory Search

Back
Top