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 derfloh 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: Andel
  • Order by date
  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...
  16. Andel

    Removing a Character

    can't you use update qustn set qustntext = replace(qustntext, '"','')
  17. Andel

    &quot;moving Range&quot;

    do you have a unique key included in the first view? if so, you should be able to calculate the 'moving' column in a new view.
  18. Andel

    Flattening many records into one

    can you give a sample table and the desired result of your query?
  19. Andel

    Changing Database Owner

    Thanks for you guys response. Bill, i'm not sure how to use your query. I'm trying to change a database owner. Here's my current script (that doesn't work). CREATE DATABASE MyNewDB ON PRIMARY (NAME = Scratch_Data, FILENAME = 'H:\MSSQL\DATA\MyNewDB.MDF', SIZE = 5000, MAXSIZE = 10001...
  20. Andel

    Query help - use joins or subqueries?

    i'm guessing if the bed is not occupied then departuredate would be > blank or is not null? so can you try this. select b.bedname, c.firstname, c.lastname from beds b join bedusage bu on b.bedid = bu.bedid join client on bu.clientid = c.clientid where bu.DepartureDate > '' -- or you can use...

Part and Inventory Search

Back
Top