How To Build My SQL Querry.

Nov 12, 2003

Hi.


I know this querry:





"SELECT TOP 10 * FROM MyTable ORDERBY ..."





will give the top 10 rows.





But how can I build a querry that can get the rows from 40-50 (ie).


Thanks.

View 2 Replies


ADVERTISEMENT

Need Help To Build Querry

Jan 21, 2005

I have two tables linked with the colunm name systemId and I need to get all the systems responding to the condition (t1.software & 0000000001) = 1 and if they have any contacts I would like to see them.
Here is what I have for the moment however my querry do not return the system info if no contact exist and that is wrong.

select customers.customerId,customers.systemId,customers.country
from customers,contacts
where (customers.software & 0000000001) = 1
and customers.SystemId = contacts.SystemId
order by customerid

Systems
-SystemId
-CustomerId
-Name
...

Contacts
-ContactId
-SystemId
-Name
-Tel
...

View 1 Replies View Related

Error On Build Solution, If SSIS Project Is Part Of Build

Mar 22, 2006

Hello,

we have automated build on every night. In our solution is SSIS project, where each package is encrypted per password. We call build process per command line like this..

C:ProgrammeMicrosoft Visual Studio 8Common7IDEdevenv.exe (c:DevelopmentX3\X3.sln /build Release)' in 'c:DevelopmentProjectsDailyBuild

Through build process we get a error:


External Program Failed: C:ProgrammeMicrosoft Visual Studio 8Common7IDEdevenv.exe (return code was 1):

We think a reason is, that on build of SSIS project must be entered a password. You can wonder for what we need that SSIS packages are part of our build. We hope that on build process is also created Deployment Utility, if so set in dtproject.user. Is it so? Is there any way to create Deployment utility on automated build process? Can be a password provided pre command line?

with best regards

Anton Kalcik

View 5 Replies View Related

Querry Help!!!

Aug 25, 2005

Is there a way I can frame the querry for the following scenario??

column1
--------
item1
item2
item3
...
..


Querry: Select datediff(month,item1,item2) and next for item2 and item3...

Thanks

View 3 Replies View Related

I Need Help With A New Querry Again

Nov 12, 2007

Hello. I know, you think I'm totally clueless, and you're right. SQL is the most confusing thing for me but I must learn it.
So, I am running a query to find out the name of the person who sold the most stoves with the least color purchased. I have ran that query and it works . My problem is that I have to add to that query another column that counts the number of stoves sold, instead of having them displayed one by one. My query is as follows:


SELECT EMPLOYEE.Name,STOVE.Color FROM INV_LINE_ITEM, STOVE, EMPLOYEE, INVOICE
WHERE INV_LINE_ITEM.FK_Stovenbr=STOVE.SerialNumber
AND INV_LINE_ITEM.FK_InvoiceNbr=INVOICE.InvoiceNbr
AND INVOICE.FK_EmpID=EMPLOYEE.EmpID
AND STOVE.Color IN (SELECT CAST(MIN(Color) AS CHAR(5)) 'Min Color' FROM STOVE)
AND EMPLOYEE.Name IN (Select CAST(MAX(Name) AS CHAR(15)) 'Employee Name' FROM EMPLOYEE)
ORDER BY EMPLOYEE.Name, STOVE.Color

Thank you

View 3 Replies View Related

Sql Sub Querry

Feb 18, 2008

I have a single table and I want to check for the duplicates. On the bases of two column.
Namley HiNum, Procode.

so if there are duplicates I want to print out those records
How I can do that in a script.

I tried the following codes but I am getting an error. how I can fix it. Or this is completly wrong?
.

Select * from Claims Where HiNum in (Select HiNum,Procode,Count(*) as NumberOfRows

From Claims

Group by HiNumber, Procode

Having Count(*) > 1)

View 2 Replies View Related

Insert Querry

Mar 16, 2007

Hello
          Can anyone give me the code to insert date from textbox to database(SQL Server 2000). The date fromat in SQL is dd-mm-yyyy.
Rathish
 

View 3 Replies View Related

2 Updates In The Same Querry!

Oct 29, 2007

Hi! I 'd like to update the database..I 'd like to update the same field, the first update would set all to 'No' and the second update woyuld set specific records to 'Yes':
1)  "Update tblDept SET IsTop ='No'
2) "Update tblDept  SET IsTop = 'Yes'  WHERE id = 200 "
Cheers!

View 4 Replies View Related

Querry Question

Aug 29, 2005

I have created a small querry and for some reason my container (datalist) is not reconizing the company name This is also the first time that i have created a querry with two select statements in the sproc.... Does it make a difference if there is two select statements in a querry?? When populating a datalist?Not sure if i need to seperate the two statements some kind of way..
Is this ok to use with datalist? Erik.. ALTER PROCEDURE Get_Information_For_Datalist_Global_ @IDProduct AS INT, @IDCompany  AS INT AS SELECT  Product.ProductName,                              Product.ProductID,Product.ProductImage,                                   Product.ProductDescription, SprocsTable.*                              FROM              Product                         INNER JOIN                           SprocsTable ON Product.ProductID = SprocsTable.ProductID                        WHERE Product.ProductID = @IDProduct SELECT   Company.CompanyID, Company.CompanyName FROM COMPANY WHERE COMPANY.COMPANYID = @IDCompany

View 1 Replies View Related

Get Time Of Querry??

Dec 7, 2006

is there a way to get the time that it takes a querry to run like down to the millsecond

View 2 Replies View Related

Search Querry

Jan 26, 2008

hi.
i want to have a text box and command button. i will be entering the clients id in the text box and press the command button to search the clients record. this will be search query. i have done that previously in vb6. but dont know what query to write in vb08. Any help. thks.

View 1 Replies View Related

Displaying My Querry Horizontally

Feb 22, 2008

Is there a way to display my querry horizontally? 

View 2 Replies View Related

Enterprise Mgr Querry Error

Dec 29, 1999

There are 3 servers in our group which the Local Enterprise Manager Tool is giving us an error when we try to view local DB table data by right-clicking on the table and selecting return all rows... we get this error I thought this was a permissions error but as far as I know we haven't played with the permissions. This seems to be a common ailment here... does anyone have a fix for the EM tool.

An unexpected error happened during this operation.
[Query] - Query Designer encountered a Query error:
Unspecified error

View 2 Replies View Related

Problem With Select Into Querry

Jun 18, 2006

I have two database on same server. I want write a querry, witch qering the data from 1st database, than create a new table on the 2nd database.
But the in clause after the into clause permanently generate error.

Here is the query€™s little part:
Select €¦..
into Backup in €™Test.mdb€™ from €¦

I try wrote other ways
in €™Test€™
in €™dbo.Test€™
in dbo.Test
but none of them work

its only work, when i not want pass for the second database

How can i pass the result for the 2nd Database

View 11 Replies View Related

Running DTS From Querry Analyzer

Sep 21, 2007

Hi,How to run a DTS from query analyzer using some t-sql commands??? Is it possible?? What is the command to run a DTS from QA???and What are the possible ways of running a DTS?? from how many types we can execute a DTS like 2 of it i know from EM directly and from the help of Schedule jobs.

View 1 Replies View Related

Simple Querry Question ??

Nov 8, 2007

Dear all,


I have 2 SQL store procedure which are suppose to return similar number of data.
For an unknown reason one of the procedure is returning lasse data than the other.
in order to dig out the reason for that I need to compare the two set of data return by both procedure.

one by one is a huge woek has I have more than 1000 records.

So my question is that what is the easy way to extract data which has been forget or miss ?

For example

my procA return 500 rows
my procB return 400 rows

I would like to identify the 100 records which are in ProcA results but not in ProcB results
In other words extr^ct the difference between A and B

thnaks for your help
serge

View 5 Replies View Related

Editing In Querry Analyzer Not In EM

Nov 24, 2006

Hello,

In SQL if we want to edit a row in a table then we have two ways to do the same,

1. Execute a command to Update the records in sql through querry analyzer.

2. Go to enterprise manager and then open the table and update a new row.



But can't we do the editing in the querry analyzer is there any way to do this.

That means i select all the records from my table using the following querry.

Select * from MyTable

and then performs editing in the querry analyzer without executing any update command and without using the Enterprise manager.

Can we do this????????



Bye and TC

View 6 Replies View Related

Date Picker And Querry

Feb 3, 2008

hi.
i have created a database with a table called customer. hav a field which displays the date. how can i add a query on the date picker so that when i choose a date on the calendar i can view the customers details. in other display the record by choosing a particular date.

thx.

View 9 Replies View Related

Querry About Drivers For My Laptop.

Mar 6, 2008

i lost my laptop driver's cd,right now i am using windows XP professional.and laptop is of compaq v3000.
so from where i get my laptops driver,can you help me out .?

View 1 Replies View Related

Generating A Querry Parameters

Nov 22, 2006

Hello,

Need a bit of help here. In one table i have my production data on some wheels. Each time the wheel is touched, it gets smaller. Then in another table I have the primary data of that wheel, ie price vendor, make model and scrap diameter.

What I'd like to figure out is, In one month, what was the wheel size to start off, what is the end size to give me a total size used during that month. If i could get that, then I think I would be able to figure out what the price cost for useage of that wheel was for the month.

Any help?

Thanks Brian

View 3 Replies View Related

How To Write The Result Of A Querry To A File

Aug 15, 2000

hello!

can somebody tell me how i can redirect the result of my
select statement to a file.

thank's

View 1 Replies View Related

Querry 2 Detect Doubles In A Table

Jul 6, 1999

Hi,


I have a table which contain a field called 'company' of type 'int'.
I want to make a querry which returns all doubles ... for example:

I have: after querry the return must be:

company company:
1 1
3 3
3 3
11 3
7 2
3 1
2 2
1
4
2
5

Thank you,
Sebastian

View 1 Replies View Related

Select +replace Querry Problem..

Dec 20, 2006

Hi.every one. I have a problem when I use this querry
select replace(Title,'.','')AS Title1, ID from tbl_Sim Where Title1 LIKE '%377%'

And here is my record
Title : 0988.613.775
ID : 2

and here is the error: Invalid column name 'Title1'.
Can any one show me how to run this querry, I want to TRIM the 'Title' before it can be compared with another condition
I am a beginner. Thanks alots!

View 2 Replies View Related

Use The Reference Column Name In The Same SELECT Querry

Sep 17, 2007

Hi,
I am writing the following querry.





Code Snippet

Select dbo.fn_EnGiftId(116) AS 'EnGiftId', dbo.fn_DeGiftId(''+ EnGiftId +'') AS 'DeGiftId'
But the above querry giving me the following error When i am executing the querry:




Code Snippet

Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'EnGiftId'.
The scenario is I have created two functions 1st is for encryption of GiftId and 2nd is for Decryption of the Encrypted Giftid.
But in the same select querry i want to use the name of column which i have given to the encrypted data in the selct querry i want to use that same column name in the decryption function uin the same querry.

When i am executing the below querry it gives me the required output. So Why not above querry.




Code Snippet

Select dbo.fn_EnGiftId(116) AS 'EnGiftId', dbo.fn_DeGiftId(''+ dbo.fn_EnGiftId(116) +'') AS 'DeGiftId'
i d't want to write the encryption function again and again. Is theer any way to avoid this.?????

View 5 Replies View Related

Problem With Ative Directory Querry

Apr 2, 2008

Hi,

I linked my Active Directory catalog on my local machine as linked server. Next I querry this server, and it works pretty.

I have problem in similar situation when I linked AD as linked server on other machine and when I querry AD it yields error:

Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "
SELECT cn, mail, sn, co, distinguishedName, displayName FROM 'LDAP://DC=<domain>,DC=com'
WHERE objectClass = 'user' AND objectCategory = 'Person'
" for execution against OLE DB provider "ADSDSOObject" for linked server "(null)".



What is wrong?

View 1 Replies View Related

How To Creat A Database Via SQL Querry Analyzer To A Web Server

Nov 20, 2003

I am new to ASP.NET and met a problem about access a database on a Web Server (www.myserver.com). My meaning here that I created a .sql from my localhost to test, but when to upload to my web server on the internet, an error occured: "System.Data.SqlClient.SqlException: SQL Server does not exist or access denied".
Anyone here can help me to solve my problem. Waiting for your reply soon. Thanks

View 2 Replies View Related

Report Designer : BIDS Seems To Hang After Querry

May 16, 2007

hi,

I'm creating my first report.
I do "new project" > "report server project".
Thereafter I create my shared datasource.
Thereafter I try to add a new report.
It ask to enter my querry.

I've built up my querry previously with the querry analyser in SSMS, and there it runs quite fast.

But when i copy-paste the querry in the reporting designer, and i choose to preview it, it takes more then 20 minutes.

however, my querry it quite big, but i've written querries ten times larger in my life.
(it's about 50lines: 10 querries, union-ed together and in each one i have 4 innerjoins.... all tables are even almost empty, so it's not that indexes are missing or whatever)...

is it known that in the report designer querries are much more slower????

View 3 Replies View Related

How To Create SELECT QUERRY FOR A CHANGE ORDER FORM In ASP?

Jun 6, 2007

 Hello.
Hope you are all well and having a good day.
I've got a problem i would like you to help me out with. My
company has got a client who sells meat and my senior tech lead
has customized the cart to fit their needs and have created a
despatch table with a "simple asp form" that allows them
to scan their products in with a wi-fi scanner.

The despatch table has the following fields:
1. OrderID
2. Product
3. Quantit
4. sellbydate
5. traceabilitycode and
6. Weight
Question 1: how do i create a form in asp that allow a user to
view the order no, product and quantity
celibate,traceabilitybycode and Weight after scanning the
details into the simple form created?
Question 2: How can i create an asp form that allows users to
search for the Order that populates the orderid, Product,
quantity?
Question 3: How can i create an asp for that allows users to
search for Product with orderid,traceabilitycode and quantity?
Question 4: How can i create an asp form that allows users to
Trace: Orderid, traceabilitycode, sellbydate and Quantity?

Please find below the source code of both the:
despatchLotsRowsSimpleForm.asp that allow them to scan details
into the table and the despatchLotsExec.asp:

THE FORM:
<!#include file="../includes/settings.asp">
<!#include file="../includes/getSettingKey.asp">
<!#include file="../includes/sessionFunctions.asp">
<!#include file="../includes/databaseFunctions.asp">
<!#include file="../includes/screenMessages.asp">
<!#include file="../includes/currencyFormat.asp">

<%
on error resume next

dim mySQL, connTemp, rsTemp

' get settings
pStoreFrontDemoMode =
getSettingKey("pStoreFrontDemoMode")
pCurrencySign = getSettingKey("pCurrencySign")
pDecimalSign = getSettingKey("pDecimalSign")
pCompany = getSettingKey("pCompany")

pAuctions = getSettingKey("pAuctions")
pAllowNewCustomer = getSettingKey("pAllowNewCustomer")
pNewsLetter = getSettingKey("pNewsLetter")
pStoreNews = getSettingKey("pStoreNews")
pSuppliersList = getSettingKey("pSuppliersList")
pRssFeedServer = getSettingKey("pRssFeedServer")

%>
<b><%=getMsg(10021,"despatch")%></b>
<br>
<%=getMsg(10024,"Enter despatch ...")%>


The despatchExec.asp Page
<%
' WebShop 3.0x Shopping Cart
' Developed using ASP
' August-2002
' Email(E-Mail address blocked: See forum rules) for further information
' (URL address blocked: See forum rules)
' Details: add e-mail to newsletter list
%>

<!--#include file="../includes/settings.asp"-->
<!--#include file="../includes/getSettingKey.asp"-->
<!--#include file="../includes/databaseFunctions.asp"-->
<!--#include file="../includes/stringFunctions.asp"-->
<!--#include file="../includes/miscFunctions.asp"-->
<!--#include file="../includes/screenMessages.asp"-->
<!--#include file="../includes/sendMail.asp"-->

<%

on error resume next

dim mySQL, connTemp, rsTemp, pEmail

' get settings

pStoreFrontDemoMode = getSettingKey("pStoreFrontDemoMode")
pCurrencySign = getSettingKey("pCurrencySign")
pDecimalSign = getSettingKey("pDecimalSign")
pCompany = getSettingKey("pCompany")

pEmailSender= getSettingKey("pEmailSender")
pEmailAdmin= getSettingKey("pEmailAdmin")
pSmtpServer= getSettingKey("pSmtpServer")
pEmailComponent= getSettingKey("pEmailComponent")
pDebugEmail= getSettingKey("pDebugEmail")
pGiftRandom= getSettingKey("pGiftRandom")
pPercentageToDiscount= getSettingKey("pPercentageToDiscount")
pStoreLocation = getSettingKey("pStoreLocation")

' form
pidOrder = lcase(getUserInput(request.form("idOrder"),50))
pProduct = lcase(getUserInput(request.form("product"),50))
pQuantity = lcase(getUserInput(request.form("quantity"),50))


pPriceToDiscount = 0

' insert despatch

mySQL="INSERT INTO despatch2 (idOrder, product, quantity ) VALUES ('"
&pidOrder& "', '" &pProduct& "', '" &pQuantity&
"')"

call updateDatabase(mySQL, rstemp, "despatchExec")

pBody=getMsg(10025,"Despatch confirmed...") &VBcrlf&
getMsg(311,"To opt-out click at:") & " (URL address blocked: See
forum rules)="&pEmail

response.redirect "redit_message.asp?message="&Server.Urlencode(getMsg(10025,"Despatch confirmed"))

call closeDb()
%>

Thank you for your help in advance..
Regards,
philip

View 2 Replies View Related

(long) Querry Doesn't Fit In Query-string Window

Jun 4, 2007

hi,

i have worked three days on a query to display all my results in a beautiful report. The query is fine because when i execute it in Query Analyzer i have all results i want to see in my statistics-table in my report...

One thing: it's contains about 100 unioned statements, which results in a super-long query. Performance is OK because it are all 100 very easy statements that are union-ed together.

But, when I copy-paste it in my query-string window/textbox of the report designer, I see that there's a maximum on that textbox lenght, which results in the fact that my long query suddenly stops.

Any solutions????

View 4 Replies View Related

What Build Is This?

Jan 12, 2001

Hey folks, I just inherited a machine where select @@version returns this:

Microsoft SQL Server 7.00 - 7.00.710 (Intel X86)

Okay, I know that:

623 is orig sql
699 is sp 1
842 is sp 2
961 is sp 3 -- but what's 710 ?

going to http://search.support.microsoft.com/kb/c.asp?ln=en-us gets me exactly 0 <zero> hits. Is this a hotfix someone's aware of?

Any thoughts/documentation/whatever would be appreciated.

Thanks,

Tom

View 1 Replies View Related

SQL To Build SQL

Nov 14, 2000

I know how to use sql to write a block of sql statements by cutting and pasting the results in to the execution window. Now my question is this...
is there a way to create the sql and execute the results. i.e. Automatically cut and paste the results into the execution window and run it??
Something to munch on if your bored. Ideas appreciated.

View 2 Replies View Related

RS Build

Feb 28, 2008

The common way that we use to delpoy reports in production server is using rsbuild.config file and running the command to execute it. Is this a Microsoft product ? does it have any licensing issue if i need to use this approach in my production environment to deploy the reports?

View 1 Replies View Related

I Need Help To Build This Query.

Jun 10, 2008

Hi,
    I have two tables called Actcodes and a another table called FundBalances...
 
The Act codes have the following format..
 
PlanId int,
ClientId int,
 StartDate datetime,
EndDate datetime,
ClientActCode char(2)
CodeDescription char(15)
so based on what the user has selected i am getting the names of each codes
 
and they have the following Rows.
PlanId         ClientId           Startdate     EndDate  ClientActCode     CodeDescription
111               1                   1/1/2008      3/31/2008     01                    Begininng balance
111               1                   1/1/2008       3/31/2008     02                   Contributions 
111               1                   1/1/2008      3/31/2008     03                   something
111               1                   1/1/2008       3/31/2008     04                   sdkfjdkf
111               1                   1/1/2008      3/31/2008     05                    dfdfd
111               1                   1/1/2008       3/31/2008     06                  dfddfs 
111               1                   1/1/2008      3/31/2008     09                  dfdf
111               1                   1/1/2008       3/31/2008     15                   dfdkfdlfk
 
and my fund balance i have the following rows..
PlanId int
Participantid int
StartDAte datetime,
end date datetime,
FundId int
Loans
Act1 char(2)
TotAct1 money
.
Act20 char(2)
TotAct20 money
and the data is as follows
PlanId   ParticipantId StartDate EndDate fundId Loans Act1 TotAct1 Act2 totact2 ----- Act20 TotAct20
111         1212           1/1/2008  3/31/2008  15   NULL   01    15.15    02    15.48           20    12.4561
111          1212           1/1/2008 3/31/2008   45   0        01        45.12 02    453.123      20          54.00
so on and so so forth
 
tht Act1 matches the ClientActCode in the Act..
So is there a way i can get those column in my select which have actCodes present in the Act code table. for in... in my act code table for this plan i have 01,02,03,04,05,06, 09, 15 clientAct codes
 
so can i get the its respective Acts and Totacts column as  Act1, Act, Act3, Act Act5, Act6 based on the ClientAct codes.
 
Any help will be appreciated..
Thanks
Karen

View 23 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved