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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Andel

  1. Andel

    Slow Replication Monitor (SQL 2005)

    On one publisher, there are 4 publications. I have 6 subscribers. I have a dedicated distributor. It is hosting quite a few publishers. So it is busy :-) Do you know any settings or tricks to make the monitor act faster?
  2. Andel

    Slow Replication Monitor (SQL 2005)

    In replication monitor, when I expand a Publisher to see my publications, it will take too much time to expand. The monitor shows "<MYSQLSERVER> (expanding...)" for a long time then eventually expands. Is there any setting for this to make it faster?
  3. Andel

    Splitting One Column into 4 columns

    gmmastros, you're great! thanks a lot. that's exactly what i'm looking for. thanks also to others who responded.
  4. Andel

    Splitting One Column into 4 columns

    Thanks Qik3Coder. I'm actually looking for a single select without a while loop. If it can't be done, then I go with the while loop as in your example. But in my case, i need a loop inside a loop. Outer loop is to go through the rows and inner loop is for splitting the columns, just like your...
  5. Andel

    Splitting One Column into 4 columns

    Yes i tried charindex along with substring. i can do it cleanly for the first 2 columns, "drive" and "capacity", but the query becomes ugly after that. The challenge is how to get the starting and ending position. Can you give me your code? I can use cursor with a while loop also but that's my...
  6. Andel

    Splitting One Column into 4 columns

    Hello, I have a table with one column and i want to split it into 4 columns. Values are comma delimeted. Is there a way using SQL query alone? Column1 ====================== C,18432,6196,12236 E,409595,112464,297131 H,407548,11915,395633 I want the output to be: Drive Capacity Used...
  7. Andel

    Assigning a default value on RadioButtonList

    I don't actually know what happen but what I did is to delete the whole page and recreate it. I used the same code and it works. thanks anyway.
  8. Andel

    Assigning a default value on RadioButtonList

    I'm trying to assign a default value to my radiobuttonlist but for some reason the following code gives "Build Failed" when I publish my web. Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If IsPostBack = False Then...
  9. Andel

    Working with UniqueIdentifier field (UserID)

    I'm using the above code to insert my data. I tried converting it to a string but it gave me different error. Can you please give me an example?
  10. Andel

    Working with UniqueIdentifier field (UserID)

    I ceated a table with a UserID field. This is a uniqueidentifier type field. (I would use this as foreign key of the UserID from aspnetdb..aspnet_users table.) The problem is that I can't figure out how to insert data in it. Here's my current code. Protected Sub btnSubmit_Click(ByVal...
  11. Andel

    Is there any way to Resize a LoginView control?

    Thanks a lot folks!
  12. Andel

    Is there any way to Resize a LoginView control?

    hello, can you please explain how? i'm new to this. thanks.
  13. Andel

    Is there any way to Resize a LoginView control?

    I cannot figure out how to resize my loginview control. I want to make it wider so that i can position my texts better.
  14. Andel

    RAISERROR within SQLServerAgent job

    ok, but will it still execute the raiserror if app_name() not like 'SQLAgent - TSQL JobStep%'?
  15. Andel

    RAISERROR within SQLServerAgent job

    Hello folks, I'm trying to use RAISERROR on my stored proc to log an error message to the event log. This is fine. The problem is, when I use SQLServerAgent to run the stored proc, the sqlagentjob reports failure everytime. How can I use the raiserror command and have the sqlagent job reports...
See more

Part and Inventory Search

Back
Top