Hi there, I'd like to ask you for help with following: I am trying to select YTD for last year in my sales table. select * from Salestable Where Postingdate > "first day of 2004" and Postingdate < "today last year" best regards, Benedikt F. Computer Department Iceland Seafood Int. ...more >>

Hi all, Does anyone know what is the following query mean: select * from abc,def where abc.xx(+) = def.xx i have no idea about the (+) symbol..what it represent? Thank you in advance Best regards, Ocurnos...more >>

Hi all, Does anyone know what is the following query mean: select * from abc,def from abc.xx(+) = def.xx i have no idea about the (+) symbol..what it represent? Thank you in advance Best regards, Ocurnos...more >>

I'm not sure if this is a join problem or even if it can be done. The english part of the query will be requesting cagegoires="Cat2" and return the matching records in table1, plus return all the other categories that belong to the set in table 2. should return two records.. 1 document1 ...more >>

Is this possible? A char variable length field contains this data: (for example) ABC,XYZ,GEF,CAB I need to query another table on the contents of each of these names that are separated by comma. I need to read ABC and then query another table for ABC in field1 and pick up some fields. Then...more >>

Here is the situation Table 1 : tbl_documents docID docName 1 aaa 2 bbb 3 ccc Table 2 : tbl_Rating ratID rating docID 1 3 1 2 5 1 3 2 1 4 3 2 The queary I need is to display the result in this form. must be like this docID docName Avaragerating 1 aaa 3 2 bbb 3 3 ccc ...more >>

Hi, I have a result set that returns Loctation Codes. Each location code is the following format: [Letter][2 Digit Number]. For example, A10 B13 D04 What I would like to do is if the letter is either A, C, E, G then order the results by the letter, then by the 2 digit numbers in asc...more >>

I am having a little problem creating this query. I have a stored procedure that accepts 4 parameters. One of the parameters tells the query which column to sort on. Select Case When @ReportParam = 'Col1' Then Col1 When @ReportParam = 'Col2' Then Col2 End as ReportOrder, Col...more >>

Is it possible to add a column description when creating a table? An example would be great....more >>

I have a table with the fileds empid,empname,designation,branch.. etc I have 5 types of designations CEO,BM,PL,Tester,and PRG and the two branches those are Hyderabad and Visakhapatnam i need the query like first CEO name next Hyderabad BM Name next Hyderabad PL name next Hyderabad Testername ...more >>

Hi there, I'd like to ask you for help with following: having 3 tables: T1 (Person_ID, Product_ID, Costs) T2 (Person_ID, Product_ID, Balancies) T3 (Product_ID, Product_Type) I have simple GROUP BY query: SELECT T1.Person_ID, T1.Product_ID, MAX(Costs) FROM T1, T2 WHERE (T1.Product_ID = T3...more >>

Hello, I created a stored procedure that renames a table to OLD_xxxxx and replaces that table with another (copy) that resides on a different database. I pull the tablename names through the use of a cursor table and construct a SELECT INTO statement as follows 'SELECT * INTO DB1.dbo.' + ...more >>

I have a adp that I want to protect. Because of my recent upsizing to MSDE, I am kind of lost! I got Andrea Montanari's Dbamgr2k to handle security issues but still... In the logins node of my MSDE instance I have 2 users: sa and BUILTIN\Administrators both pointing to the "master" database of...more >>

Dear all, I'd like to display the result of this query in percentage: SELECT SYS.Client_Version0, SYS.Client_Type0, count(*) as 'Count' FROM v_R_System as SYS WHERE SYS.Client0=1 group by SYS.Client_Version0, SYS.Client_Type0 order by SYS.Client_Version0, SYS.Client_Type0 Any idea...more >>

Hi, I have a query that returns back rows that have multiple entries for a given UniqueID. I want the query to be expanded so that it then only returns 1 of the multiple rows based on the maximum date. Thefore, my return set looks like this: UniqueID Name Date ----------------...more >>

I have two sets of Data. For example Sales And Purchasing. SALES(ISAL) PURCHASING(IPUR) ------------------------------- ------------------------------------ ItemGroup ItemGroup ItemCode ItemCode DocDate DocDate Quantity Quantity Total Total The data mentioned above are all differ...more >>

How can I get this to work? declare @WkEmpID declare @sql varchar(1000) set @sql = 'select distinct @WkEmpID = EmpID from Employee' exec (@sql) Now this is a simplified version of a more comples query which is forcing me to use this method rather than a simple SQL query. The big problem i...more >>

I have a db which stores all my sales transactions. The task is to extract the buy price(price) for each item(ItemCode) where the date is the latest for each item. For Example: Sales Table ItemCode Qty Price Date -------------- ----- -------- -------- XYZ ...more >>

Hi , Can someone help me to build a query base on : SELECT Full_Name,FLT_ID, FLT_DT_ID,PNR_ID Where Full_Name,FLT_ID, FLT_DT_ID is duplicate in the same table Thank You very much -- Travis Tan...more >>