Search results for query: *

I have a comma separated input parameter @EmployeeId that contains the following values: '123','234','246'. How can I break them up into a temp table(#Employees) so that I can then write a query against them. Something like this: SELECT * FROM SALES s INNER JOIN #EMPLOYEES e ON s.empId =...

I have the following dynamic statement: SET @sSQL = 'INSERT INTO ' + @Table + ' (sCalldate, sAgentid, sProject, sLogIn, sLogOut, sCallTime, dCallSec) ' + ' VALUES ( ''' + @sCalldate + ''', ''' + @cursorAgentId + ''', ''' + rtrim(ltrim(@sProject)) + 'z' + ''', ''' + @sStartTime + ''', '''...

I have a table that contains employees punchin and punchout times. An employee can punchin and out multiple times during day(Lunch/Breaks). Sometimes they forget to punch out, but punch in again. So I can have records that look like this: EmpId Project PunchIn PunchOut 1 A...

I need to execute the following select statement dynamically: SELECT @RC = count(*) FROM @sTable WHERE Calldate = @sCalldate When I write it like this I get errors.. EXEC ('SELECT ' + @RC + ' = count(*) FROM ' + @sTable + ' WHERE Calldate = ' + @sCalldate) IS there any way I can do this...

I have a web page that creates a text file and saves it to a network folder. The problem is that I am getting access is denied errors. Does this have to do with the asp.net account? I gave the netowrk folder read/write rights to the asp.net user. Am I missing something? Do I need to write...

I have a database whose transaction log is 22867.367 mb. I need to truncate it. I used the following command: backup log mydatabase with truncate_only and the only difference I noticed was that the Log Space Used went down. The Log size didn't change. What commands should I be using to...

Which is better to use in a query for conserving resources, IN or EXISTS? Thanks, Ninel

I have an EDIT EMPLOYEE page. It contains a dropdown a user must select an employee from. I have other dropdowns on the page, for example site, department, and position dropdowns. The department, siten, and position dropdowns are populated from the database. When user selects employee John...

I know how to bind data to a dropdown, but how can I bind to a textbox when it doesn't have the datasource property? This is what I havae so far: Private Sub ddlEmployee_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ddlEmployee.SelectedIndexChanged...

I have a web page that edits an employee's information. The user first must select an employee from a dropdown. Based on the employee chosen I need all other controls on that page to populate with that employee's information. Does anyone know how to do this? Is this done with vb.net or...

I have a web page that edits an employee's information. The user first must select an employee from a dropdown. Based on the employee chosen I need all other controls on that page to populate with that employee's information. Does anyone know how to do this? Is this done with vb.net or...

I have a web page that does some process when user clicks the submit button. Before the app does any processing I want a pop up to appear to confirm that the user wants to go ahead. Does anyone have any code or know how to go about doing this? Thanks, Ninel

My web application is creating a text file. It then saves it to a network drive. When it tries saving I receive this error: 'Access to the path "D:\INETPUB\FTPROOT\accumen\TSRLog\TSRLogAdjusted_20050812.txt" is denied.' How can I grant access

My web application is creating a text file. It then saves it to a network drive. When it tries saving I receive this error: 'Access to the path "D:\INETPUB\FTPROOT\accumen\TSRLog\TSRLogAdjusted_20050812.txt" is denied.' How can I grant access

Does anyone know or have any code tha zips up a text file? Thanks, Ninel

I seem to have completely blanked on this one: How do I loop through a dataset that came back from a stored procedure? Thanks...

I am executing a dts package from .net. I pass a global variable to the dts package and it executes a stored proc and then exports to a text file. When populating the global variable from within the dts package and executing it, the package executes successfully. But when I try to execute it...

I have a table in SQL Server that gets populated with data on a daily basis. Is there any way through vb.net I can populate a text file with that data other than executing a dts package?

I am trying to execute a DTS package from vb.net. On my local machine I had no issues, but as soon as I uploaded to my company's server I received the following error "Login failed for user 'NT AUTHORITY\NETWORK SERVICE'". I searched on google and found someone's solution: I executed this...

I executed the dts package from my local machine and it runs perfectly. I then uploaded all my code to my company's server and received this error: The specified DTS Package ('Name = 'ExportTSRLog'; ID.VersionID = {[not specified]}.{[not specified]}') does not exist. How do I get this to...