I have a database table that contains some file names and there come times when I have to copy these files to another location to have them be re-processed by a windows service.
Is there a query I can run to copy the files? I'm finding myself running a query to find all the files I need to copy, and then manually copying the files. I was hoping my query could do this for me.
dmorand
Last Activity: Jul 28 '09, 03:47 PM
Joined: Sep 26 '07
Location:
-
Help with a query to copy files (new to oracle)
-
Thanks that'll do the trick! -
Return records 5 thru 10
I realize that mySQL uses the Limit 5,10 type functionality, but I need to retrieve only records 5 thru 10 in my query.
I'm assuming I need to use TOP....
I can do something like this, but I am not going to certainly get the records I need.
SELECT TOP 5 from TABLE order by FIELD DESC
I'm doing this to create some pagination on my web application search results. -
I tried this but get an error (Line 6: Incorrect syntax near ','.) :
Code:DECLARE @location as char(1) SET @location = 'B' select top 100 * from smsdss.encv f where f.hpohierhpoobjid IN (case when @location = 'B' then (1004088425,1002573976,1003204285) end)
Leave a comment:
-
I tried to see if this would work, but no luck
Code:DECLARE @location as char(1) SET @location = 'B' DECLARE @value as varchar(255) SET @value = '''1004088425'',''1002573976'',''1003204285''' select @value select top 100 * from smsdss.encv f where cast(f.hpohierhpoobjid as varchar(10)) IN (case when @location = 'B' then (@value) end)
Leave a comment:
-
Trying to get a case statement to work correctly
I'm trying to test some logic I want to include in a SQL query I have.
I want to be able to check against a group of values when a user sets a parameter value (location). I tried the query below but get no results, and I know why. The number values I have below need to have quotes around each number, but I can't do that because then the sql statement becomes invalid and I get an error:
Server: Msg 170, Level 15, State... -
Thanks, that worked like a charm!!Leave a comment:
-
Display flag if record exists in table
I have three tables (hsusers,hscovg roupmember,hsco vgroup). I want to display all users, and a flag 'IsCoverageGrou pMember' if the user is a member of at least 1 coverage group.
Here is a definition of the tables:
hsusers = list of users
hscovgroupmembe r = contains users and the coverage groups they are assigned to
hscovgroup = contains the names of the coverage groups
I can run the below query,... -
Excellent, that worked like a charm, I appreciate your help!!!!!Leave a comment:
-
Trouble using Like Operator.....having a dumb friday
I've got a table which contains some items that I need to compare against another table which contains a more detailed look at the items, and there could be multiple.
Example:
Table1:
Field: ACETAMINOPHEN
Table2:
Fields: ACETAMINOPHEN
ACETAMINOPHEN CHEWABLE
ACETAMINOPHEN DROPS
ACETAMINOPHEN SUPP
ACETAMINOPHEN SUSP
ACETAMINOPHEN W/COD #3
ACETAMINOPHEN... -
Thanks, I'll take a look!!Leave a comment:
-
Calculate median value?
Does anyone have any experience with retrieving a median value using SQL server? I'm trying to retrieve a median value from a list of various numerical values.
Any help would be appreciated. -
Unable to run scheduled task, getting a HTTP 401.2 error
I have a scheduled task that I setup in the CF administrator. It calls a page which runs some queries and inserts some data into tables. I checked the output file, and I'm getting this error:
HTTP 401.2 - Unauthorized: Logon failed due to server configuration
I'm using Integrated Windows Authentication on my site because I'm using LDAP security within my application.
Does anyone know what I need to do... -
How come if I try to do this:
onSubmit="windo w.location.relo ad();" in my form tag it's not submitting the form, it's just refreshing the screen. I want the screen to refresh after the form gets submitted to allow the user to enter a new form without having to jump between screens.Leave a comment:
-
Thanks for the tips guys. The reason I wanted a table variable was so that I could have the stored procedure make a new table each time I call it.Leave a comment:
-
Excellent, I'll give that a try...Leave a comment:
-
How to create a table from a variable name?
I'm very new to stored procedures so this is probably something very dumb. I want to pass a name of a table to be created to my stored procedure. I'm using the variable @tableName in the code below but I'm getting an error:
Server: Msg 170, Level 15, State 1, Procedure usp_CodeGreyDat a, Line 22
Line 22: Incorrect syntax near '@tableName'.
Server: Msg 137, Level 15, State 1, Procedure usp_CodeGreyDat a, Line 29
... -
I have a popup form that's used to submit comments. When the user clicks the submit button, I'd like the popup window to close once the submission takes place.Leave a comment:
-
Refresh or close after form submission
I have a page that I want to be refreshed after a user submits a form. I also have another page that I want to be closed after a user submits a form.
How would I go about doing this?? -
insert null into datetime field
I have this query that I'm using in coldfusion:
Insert into ps_manager_empl oyee_ids (manager_emplid ,emp_id,last_na me,first_name,h ire_dt,rehire_d t,emp_status,un ion_status)
values ('#managerempli d#','#emplid#', '#last_name#',' #first_name#',' #hire_dt#','#re hire_dt#','#emp _status#','#uni on_status#')
I'm trying to insert some date values, but they are entering as 1/1/1900 instead of NULL. How can I insert...
No activity results to display
Leave a comment: