Jump to content

Sql Experts Help Cheyyandi

bevarse

By bevarse
in Old Discussions

 Share

Recommended Posts

dotnetrockz LEGEND

dotnetrockz

Posted
Posted

[quote name='Kaarthikeya' timestamp='1360273808' post='1303244034']
okkk...nuvvu SQL meedane na bhayya pani chesedi?
[/quote]
.Net

  • Replies 35
  • Created
  • Last Reply

Top Posters In This Topic

  • deals2buy

    11

  • dotnetrockz

    6

  • cool_dude

    5

  • littlemoon

    4

Popular Days

Top Posters In This Topic

Popular Days

deals2buy Celebrity

deals2buy

Posted
Posted

[quote name='Nissan' timestamp='1360274133' post='1303244076']
.Net
[/quote]
okk... parallel ga SQL kuda chestunduntaaru ga

dotnetrockz LEGEND

dotnetrockz

Posted
Posted

[quote name='Kaarthikeya' timestamp='1360274210' post='1303244087']
okk... parallel ga SQL kuda chestunduntaaru ga
[/quote]
yeah..sql .net ssrs..anni..

littlemoon Celebrity

littlemoon

Posted
Posted

[quote name='Nissan' timestamp='1360272754' post='1303243884']
[size=2][color=#0000ff][size=2][color=#0000ff][size=2]declare @Xml [/size][size=2][color=#0000ff][size=2][color=#0000ff]text[/color][/size][/color][/size][/color][/size][/color][/size]

[size=2][color=#0000ff][size=2][color=#0000ff]EXEC[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#800000][size=2][color=#800000]sp_xml_preparedocument[/color][/size][/color][/size][size=2][color=#0000ff][size=2][color=#0000ff] [/color][/size][/color][/size][size=2][color=#000000]@Idoc [/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]OUTPUT[/color][/size][/color][/size][size=2][color=#808080][size=2][color=#808080],[/color][/size][/color][/size][size=2][color=#000000] @Xml[/color][/size]

[size=2][color=#0000ff][size=2][color=#0000ff]set[/color][/size][/color][/size][size=2] @XmlPath [/size][size=2][color=#808080][size=2][color=#808080]=[/color][/size][/color][/size] [size=2][color=#ff0000][size=2][color=#ff0000]'/Info/Data'[/color][/size][/color][/size]

[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff]Insert[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]Into[/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2]@T[/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2]([/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2])[/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff]select[/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2]e_user_name[/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#0000ff]from[/color][/size][/color][/size][size=2] [/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#0000ff]openxml [/color][/size][/color][/size][size=2][color=#808080][size=2][color=#808080]([/color][/size][/color][/size][size=2]@Idoc[/size][size=2][color=#808080][size=2][color=#808080],[/color][/size][/color][/size][size=2] @XmlPath[/size][size=2][color=#808080][size=2][color=#808080])[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080]with[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080]([/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080][size=2]e_user_name [/size][size=2][color=#0000ff][size=2][color=#0000ff]VarChar[/color][/size][/color][/size][size=2][color=#808080][size=2][color=#808080]([/color][/size][/color][/size][size=2]50[/size][size=2][color=#808080][size=2][color=#808080])[/color][/size][/color][/size] [size=2][color=#ff0000][size=2][color=#ff0000]'@e_[/color][/size][/color][/size][size=2][color=#ff0000][size=2][color=#ff0000]user_name[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]

[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080])[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080][size=2][color=#0000ff][size=2][color=#0000ff]EXEC[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#800000][size=2][color=#800000]sp_xml_removedocument[/color][/size][/color][/size][size=2][color=#0000ff][size=2][color=#0000ff] [/color][/size][/color][/size][size=2][color=#000000]@Idoc[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[/quote]
excel kuda possible avthunda?

littlemoon Celebrity

littlemoon

Posted
Posted

[quote name='Nissan' timestamp='1360272754' post='1303243884']
[size=2][color=#0000ff][size=2][color=#0000ff][size=2]declare @Xml [/size][size=2][color=#0000ff][size=2][color=#0000ff]text[/color][/size][/color][/size][/color][/size][/color][/size]

[size=2][color=#0000ff][size=2][color=#0000ff]EXEC[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#800000][size=2][color=#800000]sp_xml_preparedocument[/color][/size][/color][/size][size=2][color=#0000ff][size=2][color=#0000ff] [/color][/size][/color][/size][size=2][color=#000000]@Idoc [/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]OUTPUT[/color][/size][/color][/size][size=2][color=#808080][size=2][color=#808080],[/color][/size][/color][/size][size=2][color=#000000] @Xml[/color][/size]

[size=2][color=#0000ff][size=2][color=#0000ff]set[/color][/size][/color][/size][size=2] @XmlPath [/size][size=2][color=#808080][size=2][color=#808080]=[/color][/size][/color][/size] [size=2][color=#ff0000][size=2][color=#ff0000]'/Info/Data'[/color][/size][/color][/size]

[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff]Insert[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]Into[/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2]@T[/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2]([/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2])[/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff]select[/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2]e_user_name[/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#0000ff]from[/color][/size][/color][/size][size=2] [/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#0000ff]openxml [/color][/size][/color][/size][size=2][color=#808080][size=2][color=#808080]([/color][/size][/color][/size][size=2]@Idoc[/size][size=2][color=#808080][size=2][color=#808080],[/color][/size][/color][/size][size=2] @XmlPath[/size][size=2][color=#808080][size=2][color=#808080])[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080]with[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080]([/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080][size=2]e_user_name [/size][size=2][color=#0000ff][size=2][color=#0000ff]VarChar[/color][/size][/color][/size][size=2][color=#808080][size=2][color=#808080]([/color][/size][/color][/size][size=2]50[/size][size=2][color=#808080][size=2][color=#808080])[/color][/size][/color][/size] [size=2][color=#ff0000][size=2][color=#ff0000]'@e_[/color][/size][/color][/size][size=2][color=#ff0000][size=2][color=#ff0000]user_name[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]

[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080])[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080][size=2][color=#0000ff][size=2][color=#0000ff]EXEC[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#800000][size=2][color=#800000]sp_xml_removedocument[/color][/size][/color][/size][size=2][color=#0000ff][size=2][color=#0000ff] [/color][/size][/color][/size][size=2][color=#000000]@Idoc[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[/quote]
excel kuda possible avthunda?

dotnetrockz LEGEND

dotnetrockz

Posted
Posted

[quote name='littlemoon' timestamp='1360274397' post='1303244120']
excel kuda possible avthunda?
[/quote]
hmm idea ledhu.......ante excel document nunchi direct ga sql table s lo ki import cheyyadama using stored proc?

littlemoon Celebrity

littlemoon

Posted
Posted

[quote name='Nissan' timestamp='1360274544' post='1303244145']
hmm idea ledhu.......ante excel document nunchi direct ga sql table s lo ki import cheyyadama using stored proc?
[/quote]
yes.. just curious undi adgthuna...

deals2buy Celebrity

deals2buy

Posted
Posted

[quote name='littlemoon' timestamp='1360274732' post='1303244171']
yes.. just curious undi adgthuna...
[/quote]
yep bulk insert use chesi cheyyochu

littlemoon Celebrity

littlemoon

Posted
Posted

[quote name='Kaarthikeya' timestamp='1360274774' post='1303244175']
yep bulk insert use chesi cheyyochu
[/quote]
:) query unte pls share

cool_dude Side Hero

cool_dude

Posted
Posted

[quote name='littlemoon' timestamp='1360274732' post='1303244171']

yes.. just curious undi adgthuna...
[/quote]

You can also do thru import and export wizard. ..

deals2buy Celebrity

deals2buy

Posted
Posted

[quote name='littlemoon' timestamp='1360275051' post='1303244200']
:) query unte pls share
[/quote]
[CODE]
CREATE TABLE [dbo].[#tblImport](
[Field1] [int] not null,
[Field2] [varchar] (255) null,
[Field3] [varchar] (255) null,
[Field4] [datetime] null)
[/CODE]

To open the Excel datasource, you use the SQL Command OPENDATASOURCE as follows:

[CODE]
OPENDATASOURCE(provider_name,init_string)
[/CODE]


So, assuming that the Excel data source is named [i]My Data.xls[/i] and is located in the root of the [i]C:[/i] drive, the OPENDATASOURCE statement would look like this:

[CODE]
OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','C:\My Database.mdb')

[/CODE]

Now we need to import the data.

To import the data into the temporary table created above, use the following:

[CODE]
INSERT INTO [dbo].[#tblImport]
Field1,Field2,Field3,Field4
SELECT [Field1],[Field2],[Field3],[Field4] FROM OPENDATASOURCE_
('Microsoft.Jet.OLEDB.4.0','C:\My Database.mdb')...[TableName]
[/CODE]

Note the ...[TableName] at the end of the statement. The THREE dots are essential, and the TableName is the name of the source table you are importing from.

Once the import stage above is complete, transform the data as necessary to import to your SQL tables.

If, like me, you've used a temporary table to do the initial import, don't forget to drop it once you've finished!!

[CODE]
DROP TABLE [dbo].[#tblImport]
[/CODE]

[b] Conclusion[/b]

Importing data using T-SQL is a very powerful way of controlling the final result, and the possibilities of what you can do with the imported data re: transformation are endless if you have a good command of SQL.

PS: Google chesa s%H# idi work avvakapothe repu office ki vellaka manchi query isthaanu @3$%

deals2buy Celebrity

deals2buy

Posted
Posted

Here is the exact query littlemoon

[CODE]
Insert INTO tbl_Report
select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\sql_report_tables.xls', [tbl_Report$])
[/CODE]

deals2buy Celebrity

deals2buy

Posted
Posted

[quote name='cool_dude' timestamp='1360275774' post='1303244261']
You can also do thru import and export wizard. ..
[/quote]

only Databases install chesinappudu avanni raavu kada mama tool lo

cool_dude Side Hero

cool_dude

Posted
Posted

[quote name='Kaarthikeya' timestamp='1360278441' post='1303244517']

only Databases install chesinappudu avanni raavu kada mama tool lo
[/quote]

If I am not wrng..Naku telisi Database install chesinappudu IMport Export wizard kuda untundi..

Endukante when we want to import data from table or excel..

We will right click on the database --> Import - Datasource (Here we will give req provider, we will also have Excel provider)

I'm not sure wt I am saying..kani the abv process matram pakka untundi DB right click chesthe..

deals2buy Celebrity

deals2buy

Posted
Posted

[quote name='cool_dude' timestamp='1360278827' post='1303244562']

If I am not wrng..Naku telisi Database install chesinappudu IMport Export wizard kuda untundi..

Endukante when we want to import data from table or excel..

We will right click on the database --> Import - Datasource (Here we will give req provider, we will also have Excel provider)

I'm not sure wt I am saying..kani the abv process matram pakka untundi DB right click chesthe..
[/quote]


idantha DB right click cheste na? nenu mamuluga oka tool vastundi kada SQL Server install chesinappuduu..adi anukunnnanu..nuvvu cheppindi naaku idea ledu

 Share
Go to topic listing
×
×
  • Create New...