Query Problem : Export Data : URGENT PLZ

Jun 1, 2001

Hello!

Can someone help me writting a query to export data in following fashion :

Old Structrure: I've a single table (Countries) with columns CountryID, CountryName, CityName

New Structure: I want to break this single table into two tables now (Countries) and (Cities). New Structure should be like following:

Countries Table:
- CountryID
- CountryName

Cities Table:
- CityID (Auto Generated)
- CountryID (FK from Countries)
- CityName

I would really appreciate if someone can help me to write the query which can export the Data from Countries Table to the new Cities Table.

Thanks.

View 1 Replies


ADVERTISEMENT

Export Data From Excel2003 To Sql Query

Mar 26, 2008

hi
i have a problem
and i hope u can help me

i want to write sql query into vba
how i do that

(i need to take the data from one cell and put it
in my sql query )

thank u all

View 1 Replies View Related

SQL Query (Data Manupilation--URGENT)

May 25, 2004

Hi Guys,

Can you please help me on resolving this puzzle. I will appreciate your help.

At the botton is the data in one of the column (combined) in one of the table.

I need to split these data and insert into 4 different columns.

Structure of the data is this:
eg: if we take the first value in the following description ie: n1^m1^d1^s1
contains 4 different values for the future insert eg: n1 goes to Name column, m1 goes to Title column, d1 goes to Date column and S1 goes to salary column (This is grate).

And this information is separated by ^.
But This combined column can have multiple values for several employees
such as in 2nd value in the following data ie: n2^m2^d2^s2~n3^m3^d3^s3
(this is grate too). here n2 is a employee Name where as n3 is another employee name. These set of data is differentiated by ~.

This combined column can have multiple no of employees information (separted by ~).

Note: The employee may have some of the information missing in its corosponding set of data such as if you look at the 4th set of data, ie:
n5^^^. here we only have employeename information not other informations.
another eg: if we take the last row
ie: n7^^^~n8^^d8^~n9^m9^^~n10^^^s10
second set of data (n8^^d8^) has name(n8),null value for Title,d8 value for date,null value for salary.

So in a nutshell I need to split this data and load into 4 different columns in that table. which data goes which column is totally depend on the ^ and ~ separators.

For eg:
1) The output for the first row data should be like:: for name n1, for title m1,for date d1, for salary s1

2)The output for n6^m6^d6^ should be like : for name n6,for title m6, for date d6, for salary null

Thanks guys, This is making my head spin already and can you guys take a spin of this problem and help me.

Once again thanks for your help.

combined
--------
n1^m1^d1^s1

n2^m2^d2^s2~n3^m3^d3^s3

n4^m4^d4^s4~n4^m4^d4^s4~n5^m5^d5^s5

n5^^^

n6^m6^d6^

n7^^^~n8^^d8^~n9^m9^^~n10^^^s10

View 2 Replies View Related

SQL 2012 :: Export Data To Excel Using Query?

Mar 4, 2015

I need to export the data directly using a query from sql server. This is just a temporary extract. Copy pasting the result in excel is giving mis-alignment.

View 1 Replies View Related

How To Export SQL Data To Excel SpreadSheet Using SQL Query?

Aug 2, 2006

Hi

Im using this query to select ,calculate and format data like Refer here for more understanding:-


Select DateAdd(Hour, DateDiff(Hour, 0, RowDateTime), 0) As RowDateTime,
Avg(Meter1) As Meter1,
Avg(Meter2) As Meter2,
Avg(Meter3) As Meter3
From TableName
Group By DateAdd(Hour, DateDiff(Hour, 0, RowDateTime), 0)


I want the output of the query to be written in the excel Sheet.

Your help will be highly appreciated.

View 13 Replies View Related

How To Use INSERT INTO.... SELECT FROM Query To Export MS SQL Data In FoxPro 2.6 DBF

Nov 28, 2006

Hi all,

This is my very first post to this forum. How to use the INSERT INTO... SELECT FROM query to export MS SQL 2000 data into FoxPro 2.6 DBF file? I want to write a VB 6.0 program, and already connected to MS SQL 2000 Database by MS SQL ODBC connection. Now I want to Export this MS SQL data to FoxPro 2.6 DBF. I found ROWSET option, but don't know how to use it for FoxPro.
Please help me.

Thanks in Advance.

Regards,
Rajeev Vandakar

View 5 Replies View Related

SQL Tools :: Export Data To PDF And Send It By Mail Using A Query

Jul 8, 2015

i like to know if there is a way to export data to pdf and send it by mail using a query same way used to export to csv or text file "sp_send_dbmail".

View 6 Replies View Related

Automating Export Using Dts (urgent)

Feb 15, 2001

i want to automate the exporting of data from an excel database to sql using dts.i don't want this to do manually.can u help me out in solving this.what are the things i have to do for this ?expecting u'r earliest reply

View 2 Replies View Related

Urgent DB Export Issue

Jul 23, 2005

hi everybody,iam soory maybe my question is easy, i heard about a product that cansolve such problems, but i forgetted.the problem:we have several foxpro6 systems, each one with seperated DB.Now we build a new complete DB for all systems using MS_SQL Server2000, we need to transfer/export old Data to new DB taking allsituations such as the data for one system (SALARY system) thatworking on employee table is not comaptible with other data from othersystem (emplyees system) that worked on the same table employee. Howwe can solve such issue using MS products or other products ifavailable.thanks inadvance for any advice.best regardseng thaarCNS

View 1 Replies View Related

Export To PDF In Landscape (Urgent)

Oct 12, 2007

Hello, I have a report that I am creating in sql reporting services, I want my report to be exported in landscape PDF file format. I Went to the report properties then set the width = 11 in and height 8.5.

When i export my report to a PDF file it did not display it in landscape format!

Do i need to make the report go sideways? if yes how! for example

how would i write a textbox which has the label Time sideways?

Thanks


View 4 Replies View Related

SQL Server 2012 :: Select Query To XLS Output - Export Data In Columns To Separate Tabs In Excel

Apr 21, 2015

Using below script to export the select statement result to .xls

declare @sql varchar(8000)
select @sql = 'bcp "select * from Databases..Table" queryout c:bcpTom.xls -c -t, -T -S' + @@servername
exec master..xp_cmdshell @sql

But result is not exporting in seperate tabs, all 4 column details are exporting in single cell.

how to export the data in columns to separate tabs in excel.

View 2 Replies View Related

Script For Import/export URGENT!!

Jan 16, 2001

Can anyone give me an idea where I can find the equivalent SQL scripts for the GUI process(DTS) for importing or exporting any DB from a given ODBC source.
Thanks!

View 1 Replies View Related

How Can I Export Foreing Key And Primary Key With SQL2005 Management Studio/Database/Tasks/Export Data Wizard.

Jan 4, 2008

How can I Export Database with foreing Key and primary key.

Operation is that
SQL2005 Management Studio/Database/Tasks/Export Data


Before Version is SQL2000 we can Selected Copy Object and data between server and then Use Default Options click checked and Select Copy Index, Copy Foreing Primary key vs vs

But this options is not found in the SQL2005 Management Studio/Database/Tasks/Export Data wizard or I can't found it.

How can I export foreing Key and primary key with SQL2005 Management Studio/Database/Tasks/Export Data wizard.

Best Regards,

Athena.

View 1 Replies View Related

Using RS.EXE To Export A Report From Command Line (URGENT)

Oct 26, 2007


' File: Test.rss
Dim format as string = "Excel"
Dim fileName as String = "C:Export2.xls"
Dim reportPath as String = "/TimeByEmployee"

Public Sub Main()

' Prepare Render arguments
Dim historyID as string = Nothing
Dim deviceInfo as string = Nothing
Dim showHide as string = Nothing
Dim results() as Byte
Dim encoding as string
Dim mimeType as string = "ms-excel"
Dim warnings() AS Warning = Nothing
Dim reportHistoryParameters() As ParameterValue = Nothing
Dim streamIDs() as string = Nothing
rs.Credentials = System.Net.CredentialCache.DefaultCredentials

Dim parameters(3) As ParameterValue
parameters(0) = New ParameterValue()
parameters(0).Name = "Employee"
parameters(0).Value = " "
parameters(1) = New ParameterValue()
parameters(1).Name = "Departments"
parameters(1).Value = " "
parameters(2) = New ParameterValue()
parameters(2).Name = "Week Number"
parameters(2).Value = WeekNumber
results = rs.Render(reportPath, format, _
Nothing, Nothing, parameters, _
Nothing, Nothing, encoding, mimeType, _
reportHistoryParameters, warnings, streamIDs)

' Open a file stream and write out the report
Dim stream As FileStream = File.OpenWrite(fileName)
stream.Write(results, 0, results.Length)
stream.Close()

End Sub

'End of script



here is how i run it



rs -i RunReport.rss -s http://localhost/reportserver -v WeekNumber=90 -e mgmt2000



this is the error i get:

The value of parameter 'Parameters' is not valid. also how can i cgange this line to pdf

Dim mimeType as string = "ms-excel" i tried this but it did not

work

Dim mimeType as string = "ms-pdf"


Thanks

View 1 Replies View Related

Using RS.EXE To Export A Report From Command Line (URGENT)

Oct 26, 2007

' File: Test.rss
Dim format as string = "Excel"
Dim fileName as String = "C:Export2.xls"
Dim reportPath as String = "/TimeByEmployee"

Public Sub Main()

' Prepare Render arguments
Dim historyID as string = Nothing
Dim deviceInfo as string = Nothing
Dim showHide as string = Nothing
Dim results() as Byte
Dim encoding as string
Dim mimeType as string = "ms-excel"
Dim warnings() AS Warning = Nothing
Dim reportHistoryParameters() As ParameterValue = Nothing
Dim streamIDs() as string = Nothing
rs.Credentials = System.Net.CredentialCache.DefaultCredentials

Dim parameters(3) As ParameterValue
parameters(0) = New ParameterValue()
parameters(0).Name = "Employee"
parameters(0).Value = " "
parameters(1) = New ParameterValue()
parameters(1).Name = "Departments"
parameters(1).Value = " "
parameters(2) = New ParameterValue()
parameters(2).Name = "Week Number"
parameters(2).Value = WeekNumber
results = rs.Render(reportPath, format, _
Nothing, Nothing, parameters, _
Nothing, Nothing, encoding, mimeType, _
reportHistoryParameters, warnings, streamIDs)

' Open a file stream and write out the report
Dim stream As FileStream = File.OpenWrite(fileName)
stream.Write(results, 0, results.Length)
stream.Close()

End Sub

'End of script

here is how i run it

rs -i RunReport.rss -s http://localhost/reportserver -v WeekNumber=90 -e mgmt2000

this is the error i get:
The value of parameter 'Parameters' is not valid. also how can i cgange this line to pdf

Dim mimeType as string = "ms-excel" i tried this but it did not
work
Dim mimeType as string = "ms-pdf"
Thanks

View 1 Replies View Related

Query Works In 'test Query' But Refuses To Show Up In The Datagrid On A Web Page - Urgent!

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="&#9;SELECT dbo.DERIVATIVES.DERIVATIVE_ID, count(*) AS Matches&#13;&#10;&#9;FROM dbo.MAKES INNER JOIN&#13;&#10;&#9;&#9;&#9;&#9; dbo.MODELS ON dbo.MAKES.MAKE_ID = dbo.MODELS.MAKE_ID INNER JOIN&#13;&#10;&#9;&#9;&#9;&#9; dbo.DERIVATIVES ON dbo.MODELS.MODEL_ID = dbo.DERIVATIVES.MODEL_ID INNER JOIN&#13;&#10;&#9;&#9;&#9;&#9; dbo.[VALUES] ON dbo.DERIVATIVES.DERIVATIVE_ID = dbo.[VALUES].DERIVATIVE_ID INNER JOIN&#13;&#10;&#9;&#9;&#9;&#9; dbo.ATTRIBUTES ON dbo.[VALUES].ATTRIBUTE_ID = dbo.ATTRIBUTES.ATTRIBUTE_ID&#13;&#10;&#9;WHERE ((ATTRIBUTES.ATTRIBUTE_ID = @ATT_ID1 and (@VAL1 is null or VALUE = @VAL1)) or&#13;&#10;&#9;&#9; (ATTRIBUTES.ATTRIBUTE_ID = @ATT_ID2 and (@VAL2 is null or VALUE = @VAL2)) or&#13;&#10;&#9;&#9; (ATTRIBUTES.ATTRIBUTE_ID = @ATT_ID3 and (@VAL3 is null or VALUE = @VAL3)) or&#13;&#10;&#9;&#9; (ATTRIBUTES.ATTRIBUTE_ID = @ATT_ID4 and (@VAL4 is null or VALUE = @VAL4)) )&#13;&#10;&#9;GROUP BY dbo.DERIVATIVES.DERIVATIVE_ID&#13;&#10;&#9;HAVING count(*) >= CASE WHEN @VAL1 IS NOT NULL THEN 1 ELSE 0 END +&#13;&#10;&#9;&#9;&#9;&#9;&#9;&#9;&#9;&#9;&#9; CASE WHEN @VAL2 IS NOT NULL THEN 1 ELSE 0 END +&#13;&#10;&#9;&#9;&#9;&#9;&#9;&#9;&#9;&#9;&#9; CASE WHEN @VAL3 IS NOT NULL THEN 1 ELSE 0 END +&#13;&#10;&#9;&#9;&#9;&#9;&#9;&#9;&#9;&#9;&#9; CASE WHEN @VAL4 IS NOT NULL THEN 1 ELSE 0 END -2&#13;&#10;&#9;ORDER BY count(*) DESC&#13;&#10;">
<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

Where Can I Find The Import Data/Export Data Options If I Only Have The SQL Server Management Express Studio?

Oct 4, 2007



Hi all,

It looks like these options are only available in the SQL Server Management Studio? I installed SQL Server Management Express Studio and I can't even find the DTSWizard.exe on my machine.

Can you please help how I can import data from excel or where can I download the SQL Server Management Studio?

Your prompt response is greatly appreciated.

Thanks!!
Tram

View 8 Replies View Related

Export Wizard Disturb The Order Of Data While Exporting Data To Acess 2003 From SQL Server 2005

Feb 24, 2007

 
I am using the following query to export data from sql server to ms access in export data wizard:
 
SELECT * FROM myView where myID = 123
Order by varcharColumnName1,varcharColumnName2 ,intColumnName3
 
This query will fetch about 7, 00,000 records.
 
SQL server 2005 shows the correct order, but Data in access table shows Incorrect data.
 
Please give me the solutions.

View 4 Replies View Related

Reporting Services :: SSRS Export To Excel Showing Data Type As General For All Data Types

Sep 16, 2015

One of my report has different data types like decimal,percentage and integer values.

When I exported the report to excel , all the values are showing as "general" data type.

How to get excel data type same as ssrs report data type by default when exported to excel?

View 2 Replies View Related

SQL 2012 :: Master Data Service Export Data On-demand?

Feb 17, 2014

Background: In my current company the business users maintain a huge quantity of master data using excel. Then a series of SSIS jobs are edited and manually executed.

Goal: the challenge is to replace this process using MDS. One of the requested features is the possibility for the users to edit or insert new master data using the Web UI or the Excel Add-in and when they are done perform a merge of the master data in the target, in this case in the reporting DB.

The perfect solution for me is something like trigger the execution of a SSIS package to export the data from the subscription views to the reporting DB after the business rules are apply to a specific entity.

View 1 Replies View Related

Copying Data Problem With Export Data Tool

Nov 14, 2007

I Have a problem when copying data from one server to another in Management studio, I need to create and exact copy of the original because of primary key relationships,

Currently when I export the data the data will run through an insert type statement, which means that all PKs are reissued, rather than being duplicated from the original, How can I be sure that the data will be copied exactly how it is on one server to the other.

View 4 Replies View Related

Export A Query Result To Somewhere.

May 1, 2008

Suppose I want to query a table, how can I convert it into a word file table.
I want submit a report to my boss.

I am using SQL Server 2005 Management Studio Express.

Thanks

View 7 Replies View Related

Urgent !!! Query Help ?

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

Urgent: Need Help In SQL Query

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

Sql Query Help - Very Urgent

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

Sql Query Help Urgent !!

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

Query Help - Urgent

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

Urgent !!! Query Help?

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

Urgent !!! Query Help ?

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

Query Its Urgent

Apr 20, 2006

DATEDIFF([day], dbo.Nonconformances.OpenDate, GETDATE()) AS [Days Still Active],

what is its function ?

View 1 Replies View Related

Is This Query Right? (urgent)

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

Need Urgent Help In Mdx Query

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

Urgent SQL Query

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







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