Search results for query: *

I am trying to run below and get this error even though the columns is a integer.??? CAST(@CAMPCOUNT AS INTEGER) IS THE Issue in below query: DECLARE @CAMPCOUNT INTEGER,... SET @SQLinsert = 'INSERT INTO ' + @DBName + 'WAVE_QC_HISTORY (Exec_ID, Test_Number, Test_Name, Test_Result...

i would like to select date from a table where the transaction happened in last week (sunday through saturday) What can i use to day to find out last week Sunday and saturday given running the query today. thanks

I have 2 tables: Table 1: only had TranId - 4 transaction records Table 2: TranId, Member Id - - 4 transaction records for same member in table 1 I would like to pick a transaction record group by the member id. Please help me with query. I have tried below - but putting the transaction id in...

i have 2 tables: Individual: has iid, hid (Individual id, household id) Order_header: iid, order amount I want the query to return 1 individual per household who has the hightest order amoount

i need distinct part and rest of the fields, how do i do it? select part, desc, qty... from partstable i cant do select distinct part, desc, qty... from partstable as I only need one of records in case the part# is repeated

i have a set with radio buttons. on submit i need to check if one of them is selected then redirect to a page. following code is giving error: <form name="q1" method="post" > <h4>Please answer the following questions:</h4> 1.What is your Education qualifaction?<br> <input type="radio"...

I have a web service that I need to secure. Client has asked me to use PKI based security not SSL. I cant find any decent examples of how to do so. Any one that has done so ? http://www.aspfree.com/c/a/VB.NET/Securing-Web-Services-with-X509-Certificates/ Looks like I need: Client...

I am writing a web service in c# that will have some required and some optional parameters. How do I specify optional parameters ? so that the wsdl can show it as an optional ?

I have a very basic question: When designing a website layout what is the size I should target? What should be my size to avoid scrollbars. I understand that vertical really depends on how many toolbars a user has, but what is a average or accepted sizes to design? 1. designing for 1024x768...

I am trying to write a query to fetch all orders, and its their latest event o.* all orders, e.event_description where their latest event from order_event Tables: orders 1 record for every order order_events many events for every order event_types description for a...

Can i do a select on ref cursor like this: procedure (r_cursor OUT ref_cursor, flag OUT varchar); OPEN r_cursor FOR select items from po_items where .... ; select count(*) into lcount from r_cursor; if lcount=0 then flag = 'N' else flag = 'Y' end if; end;

have a po_item table and po_item_details table with one to many relationship. I need to display multiple records in po_item_details in a flat format. select pi.po_item_id, pid.qualifier, descrption from po_items pi left join po_item_identifiers pid on (pi.PO_ITEM_ID = pid.po_Item_ID) gives...

i have a po_item table and po_item_details table with one to many relationship. I need to display multiple records in po_item_details in a flat format. select pi.po_item_id, pid.qualifier, descrption from po_items pi left join po_item_identifiers pid on (pi.PO_ITEM_ID = pid.po_Item_ID) gives...

I have backed up a db and restored it to a diff sql server 2000. I dont see any triggers restored. Is it true that triggers dont get exported with a complete backup, and need to manually scripted out ? Are there any other objects that I need to manually export ? Thanks

I am trying to update PurOrders field "num_filled" with count of orders there are for every PurOrder. I get error: "An aggregate may not appear in the set list of an UPDATE statement." UPDATE PurOrders SET num_filled = count(*) FROM Orders o INNER JOIN PurOrders p ON o.external_id...

Following is my xml: **************** <root> <sequence name="RState"> <entity name="Indicator"> <value name="CurrentState" type="int">2</value> <value name="Description" type="string">test</value> </entity>...

i have data as: select count(ny), count(dc), count(sd) from table 35, 23, 22 i wish to have it as: 25, 23, 22. Can some one help me.

I have date in the format of '6/1/2005 2:00:00 PM' and I would like to convert it to '6/1/2005'. Is there any function available to do this ??

I neet do divide Full name into First and Last name. They are seperated by space. I have tried the following which for the first name but not last name. select full_name, LEFT(rtrim(ltrim(full_name)), CHARINDEX(' ', full_name) ) as First_name, RIGHT(rtrim(ltrim(full_name))...

I have the following scenario store_id , amount 1, 20 1, 33 2, 39 3, 31 I would like to get the distinct records containg the store_id and the max amount. I have tried: select store_id, max(amount) from store group by store_id, amount