Search results for query: *

Hi chiph, Thanks you for the reply. Its still not working. I've tried everything I know to make this work.

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...

Thanks for all help! I used left join to check and see if reservation exist for today's date. Thanks again.

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...

Hi Denis, Thanks for the reply. I need some more help that sql code help fix half of the report now I need to fix bottom half. SP gathers data and puts it into temp tables then slices and dices the data then gives that back to report. When sp starts pulling data from the temp tables it gives...

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 =...

Thanks again Jason....

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...

Thanks Jason,

I did try that before I posted and didnt find anything that would get me in the right direction.

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'...

OK, So I made changes and everything runs alot faster now. Update execution plan... I have job that runs alot SP every hour at 59 min Example "1:59:59", now that updates the reservation table on production. Update takes 2 mins just because reservation table has over 800,000 records ("I need...

Hi SqlDenis, I didnt know you could combined that into one statement or I would have done it. This is really my first time with trigger. OK all make the changes and let you know how it goes. Thanks for the help.

Ok, I removed RTRIM from varibles, now I still have the same problem with the timeout. I dont understand why this is so hard to get working... trigger just passes paramaters to SP then the SP should do all the work. I have to remove reservationID, BrandID, Route from string values with...

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...

Yes... I think all just put to database on the same server ...save me this headache.

Hi, Yes I have moved SET XACT_ABORT ON around but still same error.

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...