C Nation Posted June 12, 2011 Report Posted June 12, 2011 [quote author=HAPPYNESS link=topic=201842.msg2463642#msg2463642 date=1307848697]parametrized reports ante enti ??? mana Mass basha lo cheppu burraki baaga ekkuthundi sCo_^Y sCo_^Y sCo_^Y[/quote]parametrized report ante some thing like where clause anukunta.inputs(where clause lo values) change chesthu output thisukodam anukunta. naaku deeni meedha pedhaga knowledge ledhu[url=http://www.youtube.com/watch?v=vB9iDurRtRM#]Intro to Parameters and Parameterized Reports in SSRS[/url]
stewiegriffin Posted June 12, 2011 Report Posted June 12, 2011 [quote author=HAPPYNESS link=topic=201842.msg2463661#msg2463661 date=1307849099] sCo_^Y sCo_^Y sCo_^Y sCo_^Y kudurtundi leee marchei @3$% @3$% @3$% ennno cheesam idokkati cheyyalema @3$% @3$%[/quote] @3$% @3$%try chesa...sql server tidutondi
C Nation Posted June 12, 2011 Report Posted June 12, 2011 [quote author=stewiegriffin link=topic=201842.msg2463657#msg2463657 date=1307849026]i have a doubt....i've two tables..one with composite primary key(id,sid) and another with out any keys...now i want to alter the second table nd change the sid in it, to foreign key of first...kudurutunda[/quote]i dont think so baaa.
stewiegriffin Posted June 12, 2011 Report Posted June 12, 2011 [quote author=C Nation link=topic=201842.msg2463666#msg2463666 date=1307849277]i dont think so baaa.[/quote][img]http://ist1-3.filesor.com/pimpandhost.com/1/_/_/_/1/s/Y/g/9/sYg9/In%20Bruges%20GIF.gif[/img]mari solution enti...
C Nation Posted June 12, 2011 Report Posted June 12, 2011 [quote author=stewiegriffin link=topic=201842.msg2463672#msg2463672 date=1307849444][img]http://ist1-3.filesor.com/pimpandhost.com/1/_/_/_/1/s/Y/g/9/sYg9/In%20Bruges%20GIF.gif[/img]mari solution enti...[/quote]two tables lo data undha?lekhapothe drop chesi malli create cheyyi. @3$% @3$% @3$%data unte I am helpless. em cheyyalo naaku telvad
stewiegriffin Posted June 12, 2011 Report Posted June 12, 2011 [quote author=C Nation link=topic=201842.msg2463674#msg2463674 date=1307849528]two tables lo data undha?lekhapothe drop chesi malli create cheyyi. @3$% @3$% @3$%data unte I am helpless. em cheyyalo naaku telvad[/quote]okavela malli create chesina ide problem ga...composite primary key unte, inko table lo sid ni foreign key cheyalem ga... sSa_j@il
C Nation Posted June 12, 2011 Report Posted June 12, 2011 [quote author=stewiegriffin link=topic=201842.msg2463682#msg2463682 date=1307849684]okavela malli create chesina ide problem ga...composite primary key unte, inko table lo sid ni foreign key cheyalem ga... sSa_j@il[/quote]oh. nenu primary key thisesi foreign key chesthavemo anukunna. ee issue koncham complicate ga undhi bhayya. sorry bhayya. no CITI#H@ from side
stewiegriffin Posted June 12, 2011 Report Posted June 12, 2011 [quote author=C Nation link=topic=201842.msg2463697#msg2463697 date=1307849927]oh. nenu primary key thisesi foreign key chesthavemo anukunna. ee issue koncham complicate ga undhi bhayya. sorry bhayya. no CITI#H@ from side[/quote] sorry2 endukule ... H&*() F@#da F@#da
Gachibowli_Diwakar Posted June 12, 2011 Report Posted June 12, 2011 ERROR:ORA-01017: invalid username/password; logon denied &D_@@ &D_@@ &D_@@ &D_@@
chelsea Posted June 12, 2011 Report Posted June 12, 2011 [quote author=stewiegriffin link=topic=201842.msg2463682#msg2463682 date=1307849684]okavela malli create chesina ide problem ga...composite primary key unte, inko table lo sid ni foreign key cheyalem ga... sSa_j@il[/quote]try to drop composite primary key in first table and try to alter the sid in 2nd table and create again composite primary key in first table sCo_^Y sCo_^Y sCo_^Y sCo_^Y
stewiegriffin Posted June 12, 2011 Report Posted June 12, 2011 [quote author=Musugu_Veerudu link=topic=201842.msg2463708#msg2463708 date=1307850279]ERROR:ORA-01017: invalid username/password; logon denied &D_@@ &D_@@ &D_@@ &D_@@[/quote]Msg 2812, Level 16, State 62, Line 1Could not find stored procedure '[size=14pt]AFDB[/size]'. F@#da F@#da
stewiegriffin Posted June 12, 2011 Report Posted June 12, 2011 [quote author=chelsea link=topic=201842.msg2463713#msg2463713 date=1307850475]try to drop composite primary key in first table and try to alter the sid in 2nd table and create again composite primary key in first table sCo_^Y sCo_^Y sCo_^Y sCo_^Y[/quote]artham avvala... sCo_^Y sCo_^Ysecond table already has sid...i want to alter table2 to change it as foreign key
chelsea Posted June 12, 2011 Report Posted June 12, 2011 [quote author=stewiegriffin link=topic=201842.msg2463717#msg2463717 date=1307850652]artham avvala... sCo_^Y sCo_^Ysecond table already has sid...i want to alter table2 to change it as foreign key[/quote]then u should simply use alter table add constraints constraint name sCo_^Y sCo_^Y sCo_^Y sCo_^Y
king420 Posted June 12, 2011 Author Report Posted June 12, 2011 [quote author=C Nation link=topic=201842.msg2463662#msg2463662 date=1307849115]parametrized report ante some thing like where clause anukunta.inputs(where clause lo values) change chesthu output thisukodam anukunta. naaku deeni meedha pedhaga knowledge ledhu[url=http://www.youtube.com/watch?v=vB9iDurRtRM#]Intro to Parameters and Parameterized Reports in SSRS[/url][/quote] thankyou thankyou thankyou thankyouWhat is meant by Dynamic SQL??? sCo_^Y sCo_^Y sCo_^Y
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts