Recent content by roswald

Yes I was referring to vb.net in this instance. I found out what I needed to know, thanks all. Hey rickyoswaldiow, I see we share the same last name. I have a brother named Rick. small world. bob

Can anyone tell me how I can take a DataSet in vb and create an sql table out of the results? thnaks, bob

Hey Vongrut, That is the exact code I was looking for. I knew it could be done directly in sql but just didn't have the expertise to make it work. Abaldwin, take a look at his post because that is the solution right there. Thanks to all of you for helping out! bob

Nope! What you see here is all I have to work with. bob

Alex, But I will also have recs that aren't in order with no breaks in coverage like this... ID Start End 1 1/1/2006 2/10/2006 1 2/11/2006 3/12/2006 1 4/1/2006 5/15/2006 This should be made into 2 records, so I need something different than what you sent me to...

I have a table that will have a start date, end date, and a third field called ID. If when going through this table that is indexed by ID, start Date, I want to take all the fields that have no breaks in the date fields to be combined into 1 record where possible. For example, I have 3...

Line 60 is the select statement that was processing when the connection was broken. It is almost as if there is some type of threshold being met that is causing the connection to be broken, like a timeout or something, because this only happens with very long running queries, but if I run that...

We are on Windows Server 2003 with SQL Server 2000 Database and when running a bat file using ISQLW (which is the same as running Query Analyser) I will sometimes get the following error after being connected for a few hours already, for some reason the connection gets broken and this error is...

I am trying to run the following command... Alter Database MYDB Set Restricted_User With Rollback Immediate When I run this command it works great except for the users that connect to that SQL Server 2000 server via a CITRIX connection. I can kill thier spid also and I believe the Citrix server...

I have a table that contains a BeginDate field along with a Plan_id field that we will use to sort recs. What I want to do is add a EndDate column to this table or create a new table with Plan_id, BeginDate and the new EndDate column. The current table will be sorted by Plan_id and BeginDate...

Touche Bill, I didn't think of that one. Thank you, b

When I run this command to prevent users that have read only type permission.. ALTER DATABASE Roster SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE Any login I create with SQL Server authentication is prevented for accessing the database but, if the user login is created using Windows NT...

All our SQL Server 2000 users are in a Read-Only group named Readers. Is there a command that will prevent any user in that group (Readers), from being granted any Lock on any Object between 3pm and 4pm? I need to accomplish the following; 1. Any users that are active when my script is...

Thank you mrdenny for the History lesson. Your help was invaluable. b

mrdenny, We sure do have a firewall to go through. Thank you. All I read is not to start messenger is pc is used to get on internet. No explanation though. Can you tell me how turning the messenger on would be a potential security risk without the firewall? b