mtkr Posted October 30, 2012 Report Share Posted October 30, 2012 [quote name='DARLING...' timestamp='1351608698' post='1302710603'] nee daggara SSIS resumes untey pampistaava naaku oka chinna pani undi, SSIS meeda ekkuva ponts unnavi pampinchavaa I wil PM you the Mail ID [/quote] nen helping seyyochhaaa!!! Link to comment Share on other sites More sharing options...
sqlhelp Posted October 30, 2012 Report Share Posted October 30, 2012 oka scenario ki help kavli.. 2 instances lo same database.. backup restore chesanu from one instance to other .. question : how to compare user permissions between these 2 instances.. same unayi ani telyali ? Link to comment Share on other sites More sharing options...
Darling999 Posted October 30, 2012 Report Share Posted October 30, 2012 [quote name='mtkr' timestamp='1351610596' post='1302710743'] nen helping seyyochhaaa!!! [/quote] baa pm chesaa plz see and send me resumes Link to comment Share on other sites More sharing options...
deals2buy Posted October 30, 2012 Report Share Posted October 30, 2012 [quote name='DARLING...' timestamp='1351608558' post='1302710596'] ooh kk eeyala chestaanu kudiritey [/quote] hmmm...ok [quote name='DARLING...' timestamp='1351608698' post='1302710603'] nee daggara SSIS resumes untey pampistaava naaku oka chinna pani undi, SSIS meeda ekkuva ponts unnavi pampinchavaa I wil PM you the Mail ID [/quote]ippudu levu mama..evng intikellaka pampinchagalanu kaavalante [quote name='mtkr' timestamp='1351610218' post='1302710712'] ///////////deshamudhuru Deals2buy time date//////////////////// idi antha oke single column lo data naa!!!! or diff columns aaa??? oka sari excel file ni copy chesukoni aaa column format change chesi chuduu [/quote]multiple columns anukunta..btw em format change cheyyamantunnav? [quote name='sqlhelp' timestamp='1351610686' post='1302710749'] oka scenario ki help kavli.. 2 instances lo same database.. backup restore chesanu from one instance to other .. question : how to compare user permissions between these 2 instances.. same unayi ani telyali ? [/quote]Database meeda right click chesi 'Properties' lo ki velthe 'Permissions' ani untadi ga...ala chudochemo ga nenu DBA kaadu..so antha peddaga teleedu.. inka vere method emaina use chestaro emo naaku teleedu Link to comment Share on other sites More sharing options...
mtkr Posted October 30, 2012 Report Share Posted October 30, 2012 Developers in general ga administrative tasks em em perform cheyyagalaru.... day 2 day job lo?? Link to comment Share on other sites More sharing options...
mtkr Posted October 30, 2012 Report Share Posted October 30, 2012 ////////////////[color=#282828][font=helvetica, arial, sans-serif]btw em format change cheyyamantunnav?///////////////////[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]excel file lo column meeda rt clk chesthe format cells ani ostadi gaa..( general...time...currency)[/font][/color] Link to comment Share on other sites More sharing options...
deals2buy Posted October 30, 2012 Report Share Posted October 30, 2012 [quote name='mtkr' timestamp='1351620814' post='1302711874'] Developers in general ga administrative tasks em em perform cheyyagalaru.... day 2 day job lo?? [/quote] nothing anukunta [quote name='mtkr' timestamp='1351620936' post='1302711891'] ////////////////[color=#282828][font=helvetica, arial, sans-serif]btw em format change cheyyamantunnav?///////////////////[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]excel file lo column meeda rt clk chesthe format cells ani ostadi gaa..( general...time...currency)[/font][/color] [/quote]endukala change cheyyadam? naaku ardham kaaledu..nuvvu asalu em chepdam anukuntunnavo Link to comment Share on other sites More sharing options...
mtkr Posted October 30, 2012 Report Share Posted October 30, 2012 [quote name='deals2buy' timestamp='1351624306' post='1302712304'] nothing anukunta endukala change cheyyadam? naaku ardham kaaledu..nuvvu asalu em chepdam anukuntunnavo [/quote] like aaa ' mark ostundhi kadaa...might format(datatypes) miss match avutundhi emooo anii(jus for chkng) Link to comment Share on other sites More sharing options...
deals2buy Posted October 30, 2012 Report Share Posted October 30, 2012 [quote name='mtkr' timestamp='1351629260' post='1302712890'] like aaa ' mark ostundhi kadaa...might format(datatypes) miss match avutundhi emooo anii(jus for chkng) [/quote] kaadu...nuvvu manual ga edit chese daniki inka SSIS enduku? edaina nuvvu tool lo ne cheyyali.. Link to comment Share on other sites More sharing options...
mtkr Posted October 30, 2012 Report Share Posted October 30, 2012 [quote name='deals2buy' timestamp='1351629381' post='1302712907'] kaadu...nuvvu manual ga edit chese daniki inka SSIS enduku? edaina nuvvu tool lo ne cheyyali.. [/quote] ala chesinappudu data crrt ga kanipisthundi ante datatypes miss mtch aitunnai ani anukovochu kadaaa aniii Link to comment Share on other sites More sharing options...
deals2buy Posted October 30, 2012 Report Share Posted October 30, 2012 [quote name='mtkr' timestamp='1351629988' post='1302712984'] ala chesinappudu data crrt ga kanipisthundi ante datatypes miss mtch aitunnai ani anukovochu kadaaa aniii [/quote] ledu mama..oka vela datatypes mismatch avutunnayi anukunte nuvvu munde adi tool lo options edit cheyyali...even though if you miss some values say like..nee table lo oka column lo 001, 002, ala unte sometimes there is chance of missing those leading zeroes so all the time u need to do ur edits in tool only...nuvvu excel file ni asalu kelakkudadu Link to comment Share on other sites More sharing options...
mtkr Posted October 30, 2012 Report Share Posted October 30, 2012 [quote name='deals2buy' timestamp='1351630135' post='1302712999'] ledu mama..oka vela datatypes mismatch avutunnayi anukunte nuvvu munde adi tool lo options edit cheyyali...even though if you miss some values say like..nee table lo oka column lo 001, 002, ala unte sometimes there is chance of missing those leading zeroes so all the time u need to do ur edits in tool only...nuvvu excel file ni asalu kelakkudadu [/quote] ya gelakakudadhu... knai error kosam try chesi chudu antunna.... n aaa leading zeros kosam....like excel file first 7 rows ni chusukuntadiii... n then it decides datatype for tht column.. adi driver settings lo change cheyyochu r excel source/ destin lo change cheyyochuuuu.... Link to comment Share on other sites More sharing options...
deals2buy Posted October 30, 2012 Report Share Posted October 30, 2012 [quote name='mtkr' timestamp='1351634557' post='1302713538'] ya gelakakudadhu... knai error kosam try chesi chudu antunna.... n aaa leading zeros kosam....like excel file first 7 rows ni chusukuntadiii... n then it decides datatype for tht column.. adi driver settings lo change cheyyochu r excel source/ destin lo change cheyyochuuuu.... [/quote] hmmm Link to comment Share on other sites More sharing options...
deals2buy Posted October 31, 2012 Report Share Posted October 31, 2012 [b] Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE[/b] [i]How to insert data from one table to another table efficiently? How to insert data from one table using where condition to anther table? How can I stop using cursor to move data from one table to another table?[/i] There are two different ways to implement inserting data from one table to another table. I strongly suggest to use either of the method over cursor. Performance of following two methods is far superior over cursor. I prefer to use Method 1 always as I works in all the case. [b]Method 1 : INSERT INTO SELECT[/b] This method is used when table is already created in the database earlier and data is to be inserted into this table from another table. If columns listed in insert clause and select clause are same, they are are not required to list them. I always list them for readability and scalability purpose. [color=blue]USE [/color][color=black]AdventureWorks GO[/color] [color=green]----Create TestTable[/color] [color=blue]CREATE TABLE [/color][color=black]TestTable [/color][color=gray]([/color][color=black]FirstName [/color][color=blue]VARCHAR[/color][color=gray]([/color][color=black]100[/color][color=gray]), [/color][color=black]LastName [/color][color=blue]VARCHAR[/color][color=gray]([/color][color=black]100[/color][color=gray]))[/color] [color=green]----INSERT INTO TestTable using SELECT[/color] [color=blue]INSERT INTO [/color][color=black]TestTable [/color][color=gray]([/color][color=black]FirstName[/color][color=gray], [/color][color=black]LastName[/color][color=gray])[/color] [color=blue]SELECT [/color][color=black]FirstName[/color][color=gray], [/color][color=black]LastName[/color] [color=blue]FROM [/color][color=black]Person.Contact[/color] [color=blue]WHERE [/color][color=black]EmailPromotion [/color][color=blue]= [/color][color=black]2[/color] [color=green]----Verify that Data in TestTable[/color] [color=blue]SELECT [/color][color=black]FirstName[/color][color=gray], [/color][color=black]LastName[/color] [color=blue]FROM [/color][color=black]TestTable[/color] [color=green]----Clean Up Database[/color] [color=blue]DROP TABLE [/color][color=black]TestTable GO[/color] [b]Method 2 : SELECT INTO [/b] This method is used when table is not created earlier and needs to be created when data from one table is to be inserted into newly created table from another table. New table is created with same data types as selected columns. [color=blue]USE [/color][color=black]AdventureWorks GO[/color] [color=green]----Create new table and insert into table using SELECT INSERT[/color] [color=blue]SELECT [/color][color=black]FirstName[/color][color=gray], [/color][color=black]LastName[/color] [color=blue]INTO [/color][color=black]TestTable[/color] [color=blue]FROM [/color][color=black]Person.Contact[/color] [color=blue]WHERE [/color][color=black]EmailPromotion [/color][color=blue]= [/color][color=black]2[/color] [color=green]----Verify that Data in TestTable[/color] [color=blue]SELECT [/color][color=black]FirstName[/color][color=gray], [/color][color=black]LastName[/color] [color=blue]FROM [/color][color=black]TestTable[/color] [color=green]----Clean Up Database[/color] [color=blue]DROP TABLE [/color][color=black]TestTable GO[/color] Both of the above method works with database temporary tables (global, local). If you want to insert multiple rows using only one insert statement refer article [url="http://blog.sqlauthority.com/2007/06/08/sql-server-insert-multiple-records-using-one-insert-statement-use-of-union-all/"]SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL[/url]. Link to comment Share on other sites More sharing options...
deals2buy Posted November 1, 2012 Report Share Posted November 1, 2012 [b] MDX Guide for SQL Folks: Part I - Navigating The Cube[/b] http://www.sqlservercentral.com/articles/MDX/91228/ ee article chadavandi vaa...MDX queries ela raayalo basics nundi clear ga explain chesindu...manalo evadiki SSAS raadu ani naaku telusu so start learning here... ATB everyone Link to comment Share on other sites More sharing options...
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts