Search results for query: *

Hi everyone, I'm hoping someone can help me out here. I'm starting a process of practicing my restoration of backups using query analyzer. I've been able to perform the restoration of the backup, but restoring the transaction logs is not working. My scenario assumes that the backup is being...

I'm hoping someone can answer this for me. Which is worse to use: group by or distinct? I took a peek at the execution plans for both and they are identical. In this example, group by and distinct serve the same purpose, to remove dupes from a dataset. Does SQL Server know this and just...

Hi everyone, I'm hoping someone can help me out here. I have got a table that holds call tracking information. The table looks like this: note_id, note_desc, call_date, entry_date What I'd like to do is to be able to pull the notes for the last 5 business days from today. Any help would...

Hello everyone, Most of my SQL Server experience has been on the programming side rather than the administration side so I'm hoping someone can help me out. If two instances are created on the same server does the can one domain login have two different levels of access to the instances? Any...

I'm hoping someone can help me out with an issue I'm having. I have to create a file populated with data from a stored proc I have written. The problem is that the requirements state there must be a header row with information about the file being sent and a footer row with summed information...

Hi everyone, I'm hoping someone in the community can help me out with something. I've got a stored proc that returns a resultset. Here's where I'm stuck. I want to insert the results into an email. I used xp_sendmail with @query, but the formatting was terrible. How can I make the output...

Hi all, I've tried to use the search on the site, but it appears to not be functioning correctly as it won't limit my search to use the asp forum. Here's my issue: I'm trying to capture the IP address and username on a page, but I'm struggling on how to get that information. The information...

Hi everyone, I'm new to asp and asp.net so I'm hoping someone can help me out. Without having to purchase any additional software, I'd like to track the links that are currently utilized on my site. Is there a way to initiate a database connection using an onsubmit() routine or something...

Hi all, I'm working on creating a table to hold some production information. One of the pieces I'd like to include is the time it was entered into the db and what login was used to insert the data. For the date piece I'm thinking I could just use 'sysdate', but what is the function to get...

Hi all, I have two fields that represent date and time but are both stored as varchar. What I'd like to do is to concatenate them into one field before I export the data. The data looks like this: where hst_dt is in mmddyyyy and hst_tm is in hhmmss. hst_dt hst_tm 07222004 012004 I'm...

Hi everyone, I'm a bit new to Oracle so I'm hoping someone can help me out with this. I have two columns that I'm trying to determine if they are correct. The problem is that one field contains a street address and the other contains the street address AND the city state and zip. So the data...

I'm really hoping someone can help me out on this one. It's about to drive me NUTS! I have a DTS package that runs everyday. One of the steps is to copy a file locally and move it to a datashare and then changes the name of the file. Here's the wringer. When you open the file on the...

I not new to web development, but I'm new to ASP and I've run into an odd problem (at least for me). It seems that sometimes when the page errors out I get a 'page cannot be displayed' instead of seeing the actual error message. It's almost as if I'm trying to load the wrong page. But if I go...

I'm hoping someone can help me out here. I created a DTS package that pulls data from DB to another. The DTS package works fine, but when I schedule to DTS package to run as a job, the job fails. Maybe I'm just looking in the wrong place but the error log just tells me what step was the last...

I'm hoping someone in the community can help me out with a problem I'm having. I'm trying to create a UDF that will round off a number to the nearest 50. I took a look at BOL using the round() function, but it doesn't do what I need it to. Ex. 123.43 = 100 or 127.00 = 150. Any help provided...