Search results for query: *

Hi, I'm haven some problems moving value from winForms. I have Textbox with hold propertyID and I need to move this value to form2 to finish running my query. Only problem is value comes over as NULL. Not sure what I'm doing wrong I have use GET / SET property few other times but not with...

Hello, I am haven bit of problem trying to get this subquery to work, what I want to do is filter out data if exist in another table with today date as timestamp. I just need some help making sure this is proper way to do subquery. SELECT reservationID FROM ResTans WHERE ReservationID NOT IN...

I have sp that takes for example today's date and run it through some variables with finds other dates based upon today's date. Everything is off my 1 week and I am trying to figure out how to solve this problem. Below is current code. Date is passed to this parameter @dteRequest =...

Hello, I need help formating datetime column inside datatable. This is what datetime looks like in row {8/17/2007 12:00:00 AM} Want to convert it to {8/17/2007} Sence I am looping through the datatable at once I can't use my regular method to convert datetime. temp =...

Hi, I have little problem with looping through datatable and then writing it to text file. The data is coming for datatable and I want it to look just like datatable in text file. It looks like this so far. hotel - Marriot city - Idaho address - 5555 yellowstone blvd and I want it to look...

Hi, I have question on dataset that is getting is data from store procedure from mssql server. Once I get the data in to dataset all records are group by City then I need all the same City's to be send to its own datatable or dataset not sure which one would be better to use. I just don't know...

Hi, I am haven problem trying to compare day from different years but I am trying to find the same day not date. I have the following code so far but I there is something wrong not sure how to fix it but here is example. Code DECLARE @dteRequest AS DATETIME Set @dteRequest = '06/14/2007'...

Hi, I have create Trigger on table to update another table on different server. The Trigger sends parameters to stored procedure hoping to make this process run faster but I keep getting Timeout error now. I know the trigger works find but when parameters get sent to store procedure if were the...

Hi, I have linked 2 sql server together so I can update one of the tables and I keep getting this error. TestinServer ----> Links to ----> DevelopmentServer ERROR: The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction...

Hi, I need some help retrieving some values from string. I have tried few different ways but nothin seems to work. Here is the string value (brand!sunshine)(r!58)(k!15228) the only parts that are static is brand!, r!, k!, after that is the values I want to retrieve. sunshine 58 15228 I...

Hi, Iam using C# with SQLXML 4.0 to dump data into SQL database from XML file, my problem is creating XSD with annotations SQL to map "tables/relationship" to sql database. Is there 3rd party program to create this for me? I just need help mapping sql inside XSD file. I have tried adding sql...

Hi, Iam haven some problem with my code. All I want to do is open up connect to database and insert data after button on the page has been clicked. Right now it doesnt execute unless I remove |"If Len(Request.Form("form1")) > 0 Then" and "End If" then when page is loaded it insert data which...

Hi, I need some help with formula that well allow me to select borrower and co-borrower from my table, problem is that both are in the same columns and I tired to right formula to extract both from the table but it still only pulls borrower name. There is column in the table that is BORR_CODE...

Hi Need some help with this problem Ive been having with one of my clients. When I try to connect client to the exchange server in outlook 2003 exchange, it wont connect to exchange server with any mail box name. I setup the host file with ip to name exchange.mydomain.com, DNS is up and running...

When you buy a brand new cisco switch is it the same as the routers to setup, Console and Configure? I have only setup routers and never got the chance to setup switch, just wondering if you would need a router to configure switch?

Hi Have a a few questions for you experts :) If I have 1 router 2600 cisco and that is the only router on the network and I want to connect internet to that router, Do I call Teleco company and just order the internet and they give me a Frame Relay DLCI number or how does this all work. The...

Web Server is being moved to new office just build. I really need this to run smooth and I need some info from the experts :) The office has a T1 line and I need to know which is the best practice to set this web server back up and online with little down time. Iam no expert so I have to ask...

I have Passed CCNA and I want to get my CCNP but I am not sure how many test I need to take, I looked at Cisco webpage there was 4 test but then 2 at the bottom. So I am still unsure how many I need to take. Can I just take one big test? What is the best material to study?

What is the correct way to Deny Telnet access. Configure and apply an access list will prevent telnet access to the Router1 while allowing all other traffic to pass. The access list should not contain more than three (3) statements and should be applied to the Router1 router. 1. what interface...

Score 675 There was alot on Frame-Relay and Access-List,OSPF. I Fup on Simulator. Sybex was ok, I am looking at Cisco press now.