Search results for query: *

Hi All, This one I thought would be easy but I can't get it to work. I am tring to call a stored procedure on DB A which then has to look up values on DB B. Is it possible for a stored procedure to query a different database without giving direct select access to any database. It seems if you...

Hi All, This one I thought would be easy but I can't get it to work. I am tring to call a stored procedure on DB A which then has to look up values on DB B. Is it possible for a stored procedure to query a different database without giving direct select access to any database. It seems if you...

Hi all, I hope someone can help, here is a summary of my problem; I have an VB 2005 app that runs once a day which connects to a Class 4 Db. In the app I have an App.config file which has the connectionstring and necessary passwords it needs to run. I have code that encrypts the Appsettings in...

I am using the update feature in a gridview in ASP.NET 2005 I am passing parameters to a Stored procedure which seems to work, but when the page is loading up again I get the error Input string was not in a correct format. Description: An unhandled exception occurred during the execution of...

I am fairly new to ASP.NET (actually pretty new to web development) Any way, what I have is a webpage with a ascx at the top for a header, a treeview going down the left hand side of employees, what I am trying to do is when you pick one the employees in the tree their details will show up in on...

I am trying to run a query sorted by date on a table where the date column was set up Varchar 8 but my problem is someone put some dates in the UK way (dd/mm/yyyy) while the rest of the dates are US (mm/dd/yyyy) so now when I try to sort by date it can't. Does anyone know how I could built a...

Hi, I hope you can help but my problem is, I have a web page that does some lengthy searches. I have put code in so that when a user presses the Search button it will open a popup saying SEARCHING (flashing) so they know that their computer has not hung and then goes to the rest of the code...

I think this one will take a bit of thinking but this is what I am trying to do. I have a database which I got alot of help from here with when I was creating it over a 2years ago attached to a VB6 App. This was an App to keep track of employees (their attendance, position,deviations, remarks...

I think this one will take a bit of thinking but this is what I am trying to do. I have a database which I got alot of help from here with when I was creating it over a 2years ago attached to a VB6 App. This was an App to keep track of employees (their attendance, position,deviations, remarks...

Hi again, I am not sure if I am in the right forum this time so please be patient with me. I have a text file which is sent to me every day with roughly about 70 columns and about 300,000 rows which has columns delimited by commas and Text by quotations and Rows by LF. and I run a DTS to import...

Hi Again, because you helped me so quickly with my last problem which I really appreciate, but now I have a bigger problem. In work we are always sending letters out to customers with account #s, name and addresses etc so all this info has to be encrypted when stored in a SQl Db and when it is...

Hi I know there has to be a better way of doing this and hopefully someone knows it. but here goes, I have a combobox populating from a SQL table which has 2 columns (User_ID and User_Name). I am populating the combo box with User_Name then when you pick the appropiate name it should look at...

Hi all, I don't know if this is possible but can someone tell me if/how it is possible to use a datepicker but make every 2nd Friday on that calendar be highlighted (make the font be a different color that every other day) If someone can help me. It would be greatly appreciated Thanks in advance

Hi This is something that I have never done before so please be patient..... I am trying to get Sql Server 2000 to run a SP on the 1st day of the month which will email the results from last month to a Email list. I have the SP built and tried to create a job to send the Eamil using XP_SendMail...

When I run the the line in red in Query Analyser it runs great and displays the proper date. but when I put it in my Function it error out saying there is an error near 1 CREATE FUNCTION dbo.Get_AdjHrs (@EmpID int, @Date datetime ) RETURNS numeric (5,2) AS BEGIN Declare @AdjT...

I have a trigger which looks like this CREATE TRIGGER [Processes_Trigger] ON [dbo].[Processes] FOR INSERT, UPDATE AS Update Processes Set modified_Date = GetDate(), modified_User = (select loginame=rtrim(loginame) from master.dbo.sysprocesses where spid = @@spid) but when I insert a record...