Urgent Licence Query
Dec 18, 2001
The question is regarding licences for clients who want to put their databases on the internet using our web servers. We have this in our price list as a service. We have been offering this service for a ong time.
Now we are using old licences v 7.0 for NT servers, and we need version w2000 for w2000 servers.
Our doubt is how to work the concurrent users through the internet. Can a server with mnimum number of licences serve hundereds of users through the internet,since users don't access the sql databases directly?
If anyone could help I would really appreciate it, or even offer a reference article
View 2 Replies
ADVERTISEMENT
May 22, 2008
Hi , can anybody advise good provider for SQL server licence lease.
Thanks
Natalia
View 1 Replies
View Related
Jul 23, 2005
Server setup:Server with 4 CPU's and 4G of RamThe server is used as a distributor between a separate publisher and aseparate subscriber sever.My question is:1)Can I install Standard edition of SQl Server on the distributorserver or does it need to be Enterprise. Keeping in mind that theservers primary role is to serve as a distributor in a replconfiguration.2)Can I license the server per CAL or does it need to be by CPU. I'mthinking I could license it by CAL, so I would only need to purchase acouple of CALS for the replication agents that run on the server... isthis assumption correct?Thx in advance.
View 1 Replies
View Related
Jun 30, 2006
Hi,
I'm new to SQL Server and have two questions.
We use the "old" MSDE Engine to host our time management database.
Now we have to change the server due a hardware defect. The new machine is a Dual Xeon 3GHZ with 2GB RAM with windows 2000 server on it.
Is it allowed to use the express edition on this machine and are where any known problems for the client access?
I known many useless questions, but I didn't found any informations about these topics.
Thx for your help.
Gun-Food
View 1 Replies
View Related
Dec 19, 2003
I'm trying to understand Microsoft SQL Server 2000 licence.
We want to buy the standard edition with 5 CAL's. What happen if we have sometime more then 5 users who try to connect from their home via Entreprise Manager. What happen exactly to the sixth person who try to connect ?
Thanks.
View 6 Replies
View Related
Sep 20, 2000
What type of licence do I need to run Desktop Edition of SQL 7.0. Is there such a thing as desktop license.
How much Does it approximately cost.
Thanks
View 3 Replies
View Related
Jul 23, 2005
Hi,I have just started a business and I was wondering if I could get someadvice about product selection. I am currently buiding my websiteusing asp.net connecting to sql server database.My question: Am I only required to purchase a SQL Server DevelopersLicence? I won't be hosting the site so I think this is correct butthought I should check.Cheers,Jack
View 1 Replies
View Related
Apr 24, 2008
Hi,
Do I need a licence and what type of licence for client tool - SQL Server Managment Studio on a developer PC? If I have five developers working on one project using one SQL Server 2005 database and they all need SQL Server Managment Studio SQL Server Managment Studio and SQL Server Managment Business Intelligenence Development Studio on their PC, how many licencese do I need in total and what type of licences do we need and what edition do we need to install on that single development server?
Thanks
View 4 Replies
View Related
Jan 28, 2004
I just heard of the new report writer feature in SQL. Will it be available for use in the developer edition.
View 1 Replies
View Related
Oct 10, 2006
HI there, probably an old common question. Installing the Advanced SQL Express version for use at work. Does it require a licence or licences or is free? Any answer much appreciated. Thanks Rick
View 1 Replies
View Related
Jul 4, 2007
We are in the process of installing SQL 2005 Standard Edition on Servers with two Intel Xeon 2.6Ghz processors. We want to buy a processor licence for each server rather than CAL's, but do we have to buy two processor licences or is it possible to configure SQL 2005 to only use one processor on a dual processor server and thus only need to buy a single processor licence.
View 5 Replies
View Related
Oct 12, 2006
I have developped a package that loads a flat text file into DB.
Runs OK from SQL BI Studio.
When I run it from SQL IIS, I have the following error message
"Erreur, le niveau de produit est insuffisant pour composant <<file IN>>"
that let me think this FLATTEXT ConnectionManager is only in SQL 2005 Enterprise version?
Can you help?
View 4 Replies
View Related
Aug 13, 2007
What type of licence should we buy among the list below
1.SQL Svr Standard Edtn 2005 Win32 English MVL 1 Processor License
2.SQL Svr Standard Edtn 2005 Win32 English MVL
3.SQL CAL 2005 English MVL User CAL
4.SQL CAL 2005 English MVL Device CAL
5.SQL Svr Enterprise Edtn 2005 Win32 English MVL 1 Processor License
6.SQL Svr Enterprise Edtn 2005 Win32 English MVL
7.SQL Server Wrkgroup Edtn 2005 Win32 English MVL 1 Processor License
8.SQL Server Wrkgroup Edtn 2005 Win32 English MVL 5 Clt
9.SQL Workgroup CAL 2005 Win32 English MVL User CAL
10.SQL Workgroupx CAL 2005 Win32 English MVL Device CAL
11.SQL Svr Developer Edtn 2005 Win32 X64/IA64 English MVL
our environment is
SERVER1,SERVER2,SERVER3 AND SERVER4-DMZ for DEV,QA,TRG AND DR
The servers are coming with the latest version of VMware starter license according to the no of cpu for each server with 2 x Quad-Core Intel Xeon Processor 2.66ghz with minimum 16gb memory and minimum 6 * 146 GB HDD.
Server1 will be partitioned into 5 logical servers
DEV-tranweb,QA- Tranweb, TRG- TranWeb, DR-TranWeb & compiler/sourcecode hosts
Server2 will be partitioned into 5 logical servers
DEV-tranApp,QA- tranApp, TRG- tranApp,DR-tranApp and FP/BugTrack host.
Server3 will be partitioned into 5 logical servers
DEV-tranDB,QA- tranDB, TRG- tranDB,DR-tranDB and AD
SERVER4-DMZ will be partitioned into 9 logical servers
The OS for the servers are Windows 2003 advance server OS with SAN Connectivity.this is the achitecture. Please suggest the best licence to buy for this achitecture.
Appreciate your response
Thanks
View 13 Replies
View Related
Jul 25, 2007
Hello Everyone,
Does anyone know if there are any licence implications (SAP side) against Microsoft .NET Data Provider for mySAP Business Suite?
I heard from a colleague that if my SQL Server has (for example) 5 users, if SQL does connect to SAP, it would require the user license of 5 more users?
If there any implications similar to this one with SAP?
Regards,
Joseph
View 1 Replies
View Related
Mar 28, 2007
Hey, i've written a query to search a database dependant on variables chosen by user etc etc. Opened up a new sqldatasource, entered the query shown below and went on to the test query page. Entered some test variables, everything works as it should do. Try to get it to show in a datagrid on a webpage - nothing. No data shows.
SELECT dbo.DERIVATIVES.DERIVATIVE_ID, count(*) AS Matches
FROM dbo.MAKES INNER JOIN
dbo.MODELS ON dbo.MAKES.MAKE_ID = dbo.MODELS.MAKE_ID INNER JOIN
dbo.DERIVATIVES ON dbo.MODELS.MODEL_ID = dbo.DERIVATIVES.MODEL_ID INNER JOIN
dbo.[VALUES] ON dbo.DERIVATIVES.DERIVATIVE_ID = dbo.[VALUES].DERIVATIVE_ID INNER JOIN
dbo.ATTRIBUTES ON dbo.[VALUES].ATTRIBUTE_ID = dbo.ATTRIBUTES.ATTRIBUTE_ID
WHERE ((ATTRIBUTES.ATTRIBUTE_ID = @ATT_ID1 and (@VAL1 is null or VALUE = @VAL1)) or
(ATTRIBUTES.ATTRIBUTE_ID = @ATT_ID2 and (@VAL2 is null or VALUE = @VAL2)) or
(ATTRIBUTES.ATTRIBUTE_ID = @ATT_ID3 and (@VAL3 is null or VALUE = @VAL3)) or
(ATTRIBUTES.ATTRIBUTE_ID = @ATT_ID4 and (@VAL4 is null or VALUE = @VAL4)) )
GROUP BY dbo.DERIVATIVES.DERIVATIVE_ID
HAVING count(*) >= CASE WHEN @VAL1 IS NOT NULL THEN 1 ELSE 0 END +
CASE WHEN @VAL2 IS NOT NULL THEN 1 ELSE 0 END +
CASE WHEN @VAL3 IS NOT NULL THEN 1 ELSE 0 END +
CASE WHEN @VAL4 IS NOT NULL THEN 1 ELSE 0 END -2
ORDER BY count(*) DESC
Here is the page source
<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DevConnectionString1 %>"
SelectCommand="	SELECT dbo.DERIVATIVES.DERIVATIVE_ID, count(*) AS Matches 	FROM dbo.MAKES INNER JOIN 				 dbo.MODELS ON dbo.MAKES.MAKE_ID = dbo.MODELS.MAKE_ID INNER JOIN 				 dbo.DERIVATIVES ON dbo.MODELS.MODEL_ID = dbo.DERIVATIVES.MODEL_ID INNER JOIN 				 dbo.[VALUES] ON dbo.DERIVATIVES.DERIVATIVE_ID = dbo.[VALUES].DERIVATIVE_ID INNER JOIN 				 dbo.ATTRIBUTES ON dbo.[VALUES].ATTRIBUTE_ID = dbo.ATTRIBUTES.ATTRIBUTE_ID 	WHERE ((ATTRIBUTES.ATTRIBUTE_ID = @ATT_ID1 and (@VAL1 is null or VALUE = @VAL1)) or 		 (ATTRIBUTES.ATTRIBUTE_ID = @ATT_ID2 and (@VAL2 is null or VALUE = @VAL2)) or 		 (ATTRIBUTES.ATTRIBUTE_ID = @ATT_ID3 and (@VAL3 is null or VALUE = @VAL3)) or 		 (ATTRIBUTES.ATTRIBUTE_ID = @ATT_ID4 and (@VAL4 is null or VALUE = @VAL4)) ) 	GROUP BY dbo.DERIVATIVES.DERIVATIVE_ID 	HAVING count(*) >= CASE WHEN @VAL1 IS NOT NULL THEN 1 ELSE 0 END + 									 CASE WHEN @VAL2 IS NOT NULL THEN 1 ELSE 0 END + 									 CASE WHEN @VAL3 IS NOT NULL THEN 1 ELSE 0 END + 									 CASE WHEN @VAL4 IS NOT NULL THEN 1 ELSE 0 END -2 	ORDER BY count(*) DESC ">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="ATT_ID1" PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="TextBox1" Name="VAL1" PropertyName="Text" />
<asp:Parameter Name="ATT_ID2" />
<asp:Parameter Name="VAL2" />
<asp:Parameter Name="ATT_ID3" />
<asp:Parameter Name="VAL3" />
<asp:Parameter Name="ATT_ID4" />
<asp:Parameter Name="VAL4" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:DevConnectionString1 %>"
SelectCommand="SELECT * FROM [ATTRIBUTES]"></asp:SqlDataSource>
<br />
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2"
DataTextField="ATTRIBUTE_NAME" DataValueField="ATTRIBUTE_ID">
</asp:DropDownList>
<asp:TextBox ID="TextBox1" runat="server" AutoPostBack="True"></asp:TextBox><br />
<br />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="DERIVATIVE_ID"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="DERIVATIVE_ID" HeaderText="DERIVATIVE_ID" InsertVisible="False"
ReadOnly="True" SortExpression="DERIVATIVE_ID" />
<asp:BoundField DataField="Matches" HeaderText="Matches" ReadOnly="True" SortExpression="Matches" />
</Columns>
</asp:GridView>
</asp:Content>
AFAIK I have configured the source to pick up the dropdownlist value and the textbox value (the text box is autopostback).
Am i not submitting the data correctly? (It worked with a simple query...just not with this one). I have tried a stored procedure which works when testing just not when its live on a webpage.
Please help!
(Visual Web Devleoper 2005 Express and SQL Server Management Studio Express)
View 4 Replies
View Related
Nov 15, 2001
Hi ALL,
I am looking for a query to solve this.
I had two table's.
1) Employee Table
Employee_ID Designation
---------- -------------
Savin Database Administrator
Ray Software Engineer
Adam Software Engineer
Scott Software Engineer
2). EmployeeCred Table
Employee_ID SkillSet
----------- ---------
Savin Oracle8i
Savin SQL Server 7.0.
Savin SQL2000
Ray VB 6.0
Ray Java2.0
Ray C++
Adam Share point
Adam VB 6.0
Adam Java2.0
Scott ASP
Scott VB 6.0
Output I requried.
-----------------
Employee_ID Designation SkillSet
------------ ------------ --------
Savin Database Administrator Oracle8i, Sql Server 7.0, SQL2000
Ray Software Engineer VB 6.0, Java2.0, C++
Adam Software Engineer Share point, VB 6.0, Java2.0
Scott Software Engineer ASP, VB 6.0
I need a query to solve this problem. Kindly please help me. Its urgent!!!
Thanks in advance.
venkat.
View 4 Replies
View Related
Aug 14, 2002
Here is the scenario:
There are 2 tables:
1. ItemMaster Table: This table contains all the available Items (around 500,000). Fields are:
(a) ItemId Integer (PK)
(b) ItemDetails Varchar(100)
2. ItemImage Table: This item contains the location of picture of few items out of above table (around 10,000). Fields are:
(a) ItemId Integer (PK)
(b) ImageURL Varchar(50)
Requirement: I want to create a query or stored procedure, which would return me: ItemId, ItemDetails and a flag to indicate if image is available for that item or not.
Can anybody help me out in getting this flag which has to be build dynamically in the query as its not there in the tables. And what would be the query for acheiving the desired result.
Thanks in advance
Dinesh
View 4 Replies
View Related
Apr 5, 2001
Hi,
I am a new SQL programmer. I need your help for writing a query. I am able to get the desired result set by looping through but it takes lots of time and resourses to run and crashes my machine. Is there any way to write a sql statement which performs batchwise? I really appreciate your help.
Following is a data from a view called ind_results.
last_name first_name course_code course_title score
-------------------------------------------------------------------------
Walker Jay 1 Mid-Term Exam 71
Walker Jay 2 Final Part I Online Exam 64
Walker Jay 3 Final Exam Part II Online Exam NULL
Reed Steve 1 Mid-Term Exam 70
Reed Steve 2 Final Part I Online Exam 78
Reed Steve 3 Final Exam Part II Online Exam 80
I need help in writing a query, where
1) If Score is null for either course_code 2 or 3, display score = 'incomplete' for course_code 2 and 3 (for Jay Walker)
2) If Score is not null for either course_code 2 or 3, display score = average value of score for course_code 2 and 3 (For steve Reed)
i.e. the resultset should look like this.
last_name first_name course_code course_title score
-------------------------------------------------------------------------
Walker Jay 1 Mid-Term Exam '71'
Walker Jay 2 Final Part I Online Exam 'incomplete'
Walker Jay 3 Final Part II Online Exam 'incomplete'
Reed Steve 1 Mid-Term Exam '70'
Reed Steve 2 Final Part I Online Exam '79'
Reed Steve 3 Final Exam Part II Online Exam '79'
I have at least 67000 rows in a view.
How can I display the desired result?
Thanks for reading it through
View 3 Replies
View Related
Jun 13, 2001
Hi ,
I am a new programmer. I need help on writing a query to accomplish the following.
Data is like this:
part_no status replaced_by_part_no
A111 superceded B111
B111 superceded C111
C111 superceded D111
D111 current null
I am trying to write a query where I get the following result. Basically
I have to display latest part_number in the chain with status as 'current'
for any part number that is superceded by another part_number.
part_number new_part_number
A111 D111
B111 D111
C111 D111
Please help.
I have written a code using cursor. But I just learnt that cursor should not be used. So I am looking for different syntax so that I can learn programming without cursor.
Thanks,
View 1 Replies
View Related
Oct 22, 2001
Hello I have the following query that is producing the following errors;
Code:
declare @temp_request as varchar(8)
Select request as temp_request,BUSINESS_REQ_ID,TEST_CASE_SOURCE as SOURCE from TEAM3B_PULL_TOTAL_TST
if (not exist (select * from TEST_REPORT.dbo.BUS_REQ_DESCRIPTION_TST where REQUEST = temp_request))
begin
Insert into TEST_REPORT.dbo.BUS_REQ_DESCRIPTION_TST(request,bu siness_req_id,source)
select request,business_req_id,test_case_source from TEAM3B_PULL_TOTAL_TST where request=temp_request
end
Else
begin
Insert into TEST_REPORT.dbo.RDD_UPDATE_TST(request,business_re q_id,test_case_id,test_case_descr)
select request,business_req_id,test_case_id,test_case_des cr from TEAM3B_PULL_TOTAL_TST where request=temp_request
end
Errors:
Server: Msg 156, Level 15, State 1, Line 4
Incorrect syntax near the keyword 'select'.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near ')'.
Server: Msg 156, Level 15, State 1, Line 11
Incorrect syntax near the keyword 'Else'.
Thank you in advance,
Terry
View 1 Replies
View Related
Nov 15, 2001
Hi ALL,
I am looking for a query to solve this.
I had two table's.
1) Employee Table
Employee_ID Designation
---------- -------------
Savin Database Administrator
Ray Software Engineer
Adam Software Engineer
Scott Software Engineer
2). EmployeeCred Table
Employee_ID SkillSet
----------- ---------
Savin Oracle8i
Savin SQL Server 7.0.
Savin SQL2000
Ray VB 6.0
Ray Java2.0
Ray C++
Adam Share point
Adam VB 6.0
Adam Java2.0
Scott ASP
Scott VB 6.0
Output I requried.
-----------------
Employee_ID Designation SkillSet
------------ ------------ --------
Savin Database Administrator Oracle8i, Sql Server 7.0, SQL2000
Ray Software Engineer VB 6.0, Java2.0, C++
Adam Software Engineer Share point, VB 6.0, Java2.0
Scott Software Engineer ASP, VB 6.0
I need a query to solve this problem. Kindly please help me. Its urgent!!!
Thanks in advance.
venkat.
View 2 Replies
View Related
Nov 15, 2001
Hi ALL,
I am looking for a query to solve this.
I had two table's.
1) Employee Table
Employee_ID Designation
---------- -------------
Savin Database Administrator
Ray Software Engineer
Adam Software Engineer
Scott Software Engineer
2). EmployeeCred Table
Employee_ID SkillSet
----------- ---------
Savin Oracle8i
Savin SQL Server 7.0.
Savin SQL2000
Ray VB 6.0
Ray Java2.0
Ray C++
Adam Share point
Adam VB 6.0
Adam Java2.0
Scott ASP
Scott VB 6.0
Output I requried.
-----------------
Employee_ID Designation SkillSet
------------ ------------ --------
Savin Database Administrator Oracle8i, Sql Server 7.0, SQL2000
Ray Software Engineer VB 6.0, Java2.0, C++
Adam Software Engineer Share point, VB 6.0, Java2.0
Scott Software Engineer ASP, VB 6.0
I need a query to solve this problem. Kindly please help me. Its urgent!!!
Thanks in advance.
venkat.
View 1 Replies
View Related
Apr 20, 2006
DATEDIFF([day], dbo.Nonconformances.OpenDate, GETDATE()) AS [Days Still Active],
what is its function ?
View 1 Replies
View Related
May 23, 2007
Hi
I have a report which has a table and that table has 4 columns
I want to represent the Data like this.
Company Match or Profit Sharing or Safe Harbor Company Match or ProfitSharing or Safeharbor
Years of Service Vesting Years of service Vesting
1 40 1 50
I have 3 text boxes saying Company Match, Safe harbor and Profit Sharing, and the User normally can click 2 checkboxes
Suppose if the user clicks only company Match, i want the company Match to display on the left hand side if the users clicks on 2 things say company match and safe harbor.
I want the Company match to come on the left and safe harbor to be on the right. and my Expression is as follows:
for the Left hand side its :
IIf(Fields!CompanyMatch.Value = true,"Company Match",IIf(Fields!SafeHarbor.Value = true,"Safe Harbor","Profit Sharing"))
and the right hand side its:
IIf(Fields!ProfitSharing.Value = true," Profit Sharing","")
so how can i display the details in the above fashion.
any help is appreciated.
Regards,
Karen
View 4 Replies
View Related
Nov 27, 2007
WITH
SET [FilteredAccountSet] AS 'order( [Acc€”BU_ Account_BCDsc].[Account],[Measures].[_MeasureBillingCode],ASC)'
SET [FilteredBUList] AS 'order( [Acc€”BU_ Account_BCDsc].[Business Unit],[Measures].[_MeasureBillingCode],ASC)'
SET [FilteredBillingCodeSet] AS 'order( [Acc€”BU_ Account_BCDsc].[Billing Code Description],[Measures].[_MeasureBillingCode],ASC)'
SET [FilteredEngagementGroupSet] AS '[Acc€”BCEngTypeGroup_BCDsc].[Billing Code Engagement Type Group]'
MEMBER [Measures].[AverageTeamSize] AS '[Measures].[Consultant Utilization]/(COUNT(GENERATE({[Date€”Year_Month_Day].
[Date€”Year_Quarter_Month].[All Date€”Year_Quarter_Month].[2007].[Quarter 1].[May]:
[Date€”Year_Month_Day].[Date€”Year_Quarter_Month].[All Date€”Year_Quarter_Month].[2007].[Quarter 1].[July]},
DESCENDANTS([Date€”Year_Month_Day].CURRENTMEMBER,[Date€”Year_Month_Day].[Day]))))'
MEMBER [Measures].[MdaCodeTotal] AS
'VBA!ABS([Measures].[AverageTeamSize])+
VBA!ABS (([Ledger€”L1_L2_L3_L4_AccountCode].[All Ledger€”L1_L2_L3_L4_AccountCode].[Revenue].[Service].[On - site],[Measures].[Amount Usd]))+
VBA!ABS(([Ledger€”L1_L2_L3_L4_AccountCode].[All Ledger€”L1_L2_L3_L4_AccountCode].[Revenue].[Service].[Off shore],[Measures].[Amount Usd] )) +
VBA!ABS(([Ledger€”L1_L2_L3_L4_AccountCode].[All Ledger€”L1_L2_L3_L4_AccountCode].[Revenue].[Service Travel & Other],[Measures].[Amount Usd] ))+
VBA!ABS(([Ledger€”L1_L2_L3_L4_AccountCode].[All Ledger€”L1_L2_L3_L4_AccountCode], [Measures].[Effort Based Cost])) +
VBA!ABS(([Ledger€”L1_L2_L3_L4_AccountCode].[All Ledger€”L1_L2_L3_L4_AccountCode],[Measures].[Pulse Non Compliance Cost])) +
VBA!ABS(([Ledger€”L1_L2_L3_L4_AccountCode].[All Ledger€”L1_L2_L3_L4_AccountCode].[Expense].[On-site living],[Measures].[Amount Usd] )) +
VBA!ABS(([Ledger€”L1_L2_L3_L4_AccountCode].[All Ledger€”L1_L2_L3_L4_AccountCode].[Expense].[Other Expenses],[Measures].[Amount Usd] )) +
VBA!ABS(([Ledger€”L1_L2_L3_L4_AccountCode].[All Ledger€”L1_L2_L3_L4_AccountCode],[Measures].[Effort Based Onshore Billing Project Days])) +
VBA!ABS(([Ledger€”L1_L2_L3_L4_AccountCode].[All Ledger€”L1_L2_L3_L4_AccountCode],[Measures].[Effort Based Offshore Billing Project Days]))'
SELECT {
([Ledger€”L1_L2_L3_L4_AccountCode],[Measures].[Billing Code ATC List]),
([Ledger€”L1_L2_L3_L4_AccountCode],[Measures].[AverageTeamSize]),
([Ledger€”L1_L2_L3_L4_AccountCode],[Measures].[Billing Code Engagement Type Group]),
([Ledger€”L1_L2_L3_L4_AccountCode].[All Ledger€”L1_L2_L3_L4_AccountCode].[Revenue].[Service].[On - site],[Measures].[Amount Usd]),
([Ledger€”L1_L2_L3_L4_AccountCode].[All Ledger€”L1_L2_L3_L4_AccountCode].[Revenue].[Service].[Off shore], [Measures].[Amount Usd]),
([Ledger€”L1_L2_L3_L4_AccountCode].[All Ledger€”L1_L2_L3_L4_AccountCode].[Revenue].[Service Travel & Other],[Measures].[Amount Usd]),
([Ledger€”L1_L2_L3_L4_AccountCode],[Measures].[Effort Based Cost] ),
([Ledger€”L1_L2_L3_L4_AccountCode],[Measures].[Pulse Non Compliance Cost]),
([Ledger€”L1_L2_L3_L4_AccountCode].[All Ledger€”L1_L2_L3_L4_AccountCode].[Expense].[On-site living],[Measures].[Amount Usd] ),
([Ledger€”L1_L2_L3_L4_AccountCode].[All Ledger€”L1_L2_L3_L4_AccountCode].[Expense].[Other Expenses],[Measures].[Amount Usd] ),
([Ledger€”L1_L2_L3_L4_AccountCode],[Measures].[Effort Based Onshore Billing Project Days]),
([Ledger€”L1_L2_L3_L4_AccountCode],[Measures].[Effort Based Offshore Billing Project Days])
} ON COLUMNS,
NON EMPTY
{
filter(
[FilteredAccountSet],[Measures].[_MeasureDataPresentBillingCodeDsc] = 1)
}
ON ROWS
FROM [Profitability]
WHERE ([Date€”Year_Quarter_Month].[All Date€”Year_Quarter_Month].[2007].[Quarter 1].[May]:
[Date€”Year_Quarter_Month].[All Date€”Year_Quarter_Month].[2007].[Quarter 1].[July])
m newbie for reporting services the above query is working on sql management studio but not working on Visual Studio BIwhy is that?pls reply me urgent
View 2 Replies
View Related
Apr 20, 2008
OPEN orabaan
declare
@batch int,
@ttype char(3),
@doc int,
@ttdr float,
@ttcr float,
@diff float,
@s1r int,
@s2r int
WHILE
@@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM orabaan
INTO @batch,
@ttype,
@doc,
@ttdr,
@ttcr,
@diff
if @diff < 0
update
ttfgld102777
set
t_amth_2 = (t_amth_2 + @diff)
where exists
( select top 1 t_amth_2 from orabaan
where
t_dbcr = 1
==> and t_btno = @batch
and t_ttyp = @ttype
and t_docn = @doc )
==============================
I want to add a clause to auto update t_btno when value occur as "t_btno" is variable int
simple data
t_btno t_ttyp t_docn t_dbcr t_amth_2
17 NI1 20050205 1 -3914482498.0
17 NI1 20050205 1 -3914484153.3000002
17 NI1 20050205 2 -3914482497.3000002
17 NI1 20050205 1 -3914482497.3000002
17 NI1 20050205 2 -3914482498.0
17 NI1 20050205 2 -3914484153.3000002
I want to update first row only for each t_btno
thanks regards
View 3 Replies
View Related
May 15, 2007
Hello. I have a question. I have a table that keeps track of
claims being made by clients (like insurance claims). There is a table which
has 2 fields. Field1 and Field2. Field1 has the original claim number. If an
adjustment is made to the claim, a new claim number will be generated. For example
if a person pays $100 and files a claim, he is issued a claim number which goes
into Field1. If that person spends some more money towards the same issue and
then files another claim then he is given a new claim number which is stored in
Field2.
Field1--------------Field2
--------------------------------
100--------------------150
150--------------------200
200--------------------250
250--------------------Null (No more adjustments made)
and so on.
So in the query I will supply a claim number (say 100). I
need to get the history of all the claims attached to it. In this example 100,
150, 200, 250.
Also if the claim number provided is 200 I need to get the
original claim number (which is 100) meaning I need to back track and forward
track too. I need this in SQL Server 2000.
I hope I am clear enough. Thanks.
View 3 Replies
View Related
Sep 26, 2007
i am working on asp.net
i am passing two values through querystring to the next page, that values are comming to next page but i want to display results on these two crieria hats.
i have written following query which working fine in sql server 2000
SQL 2000==> select caterername, ccity from caterer where ccity='matunga' and cateringfor like '%event%'
but when i am trying to do this in asp.net its not working. following code accepting only one value . i want to compair two value. Please guide me how to write above query in asp.net using 'and' and 'like' operatorasp.net ==>select * from addahall where HCity='" + city + "' ==> city is variable
please let me know as early as possible i have very less time.
View 5 Replies
View Related
May 6, 2008
hi frenz:
This is my query:it shows the following
error:Incorrect syntax near the keyword 'as'.plz let me know my error, and how to correct it.
My Query:
SELECT EH.EmpID, EL.UserName,EL.Password, E.FirstName, E.LastName, E.DesignationID,
E.DepartmentID, E.Sex, E.DOB, E.Age, E.Address, E.Email,
'ContactNo'= Case When E.phone is not null Then E.phone When E.phone is null
Then E.Mobile End ,E.DateOfjoining, D.Designation, DE.Department,E.HobbyID
where E.HobbyID in
(select EH.HobbyID from EMP_Tbl_EmployeeHobbies EH inner join EMP_Tbl_Hobby H on EH.HobbyID=H.HobbyID) as item1,
From dbo.EMP_Tbl_Employee E
Inner Join dbo.EMP_Tbl_Designation D On E.DesignationID=D.DesignationID
Inner Join dbo.EMP_Tbl_Department DE On E.DepartmentID=DE.DepartmentID
Inner Join dbo.EMP_Tbl_EmployeeHobbies EH On E.EmpID=EH.EmpID
Inner Join dbo.EMP_Tbl_EmployeeLogin EL On E.Sno=EL.Sno
View 1 Replies
View Related
Apr 27, 2001
Im trying to transfer data from SQL tbl to .xls file through a DTS package.
My problem is that DTS transfers all the data from the source tbl to .xls
file.
But i would like to have the selective data transfer based on some query like ;
select * from tbl where field ='val'
for the val i want to pass different values .
instead of complete data transfer.
Thanks in advance.
Regards
Anand
View 3 Replies
View Related
May 19, 2001
Hi Every1 there,
I have 3 tables
Items
-----
Item_code
item_desc
gp_code
cat_code
and
inv_header
---------
invhkey
trnno
trndate
tot_amount
tot_discount
inv_Details
----------
invdetkey
invhkey
item_code
qty
rate
discount
i want a way in which i should b able to view the information in this format.
Gp_code Item_code item_Description
eg: 01aa abc abcdedf
Sales
May2001 Apr2001 Mar2001 Feb2001 Jan2001 Dec2000 till May2000(i.e 1 year)
if possible i want a flexibility wherein i should b able to give the gp_code and all the items in tht gp_code should b displayed in above format where in the starting monthh will b the current month .
Any help will b highly appreciated.
Thanx.
View 1 Replies
View Related
May 9, 2000
Hi all,
I am running a query which was created by front end application on (9 tables and one view) VIEW was created on 3 tables...Each table is having millions of records.. In this query there nearly 30 where conditions..are there..
When i run query plan , it is using HASH JOIN..
when i run a query, it is giving ERROR 1101..It is occupying all tempdb size, i gave autogrowth of tempdb, then also tempdb memory is not enough for this query...
I am having all possible indexes on all tables including tables which are used in VIEW.
and also i tried to run PERFORM INDEX ANALYSIS on this query , it is running ,after 10 minutes i stopped the PERFORM INDEX ANALYSIS.. because it is taking so much of time..
I believe this query is retrieving millions of records,but i dont know what to do with this one.. Pls anyone suggest me, how my query is taking so much time , is this because of HASH JOIN.
I think if we have service pack2, can avoid this problem, am i right(if we have so many records in table)
Pls suggest the way....
raj
View 3 Replies
View Related
Nov 21, 2001
Hello,
I have a table with 3 cols--- id1,id2 and id3
Total no.of rows-- 18
id1id2id3
11
25
35
45
51
6100
7100
845
944
1045
11100
126
136
141
152
163
17111
18123
id1 is an identity column.
I have to populate third column which is id3 based on the data in id2.
I have to group similar values in id2 together
and insert 1,2,3 accordingly in id3.
For eg: we have three 100's in id2, so we should have values 1,2,3 for id3.
we have two 45's in id2, we should have values 1,2 for id3.
so final output should be:
id1id2id3
111
251
352
453
512
61001
71002
8451
9441
10452
111003
1261
1362
1413
1521
1631
171111
181231
Is it possible?
Please help!!!!!!!
Thanks,
cheryl
View 3 Replies
View Related
