Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Can we make the the chages By Using the Sql
if u know any function or process please inform me

Actuall result:
BRK1 Break 1 Part 1 00:01:00:00 60
BRK1 Break 1 Part 2 00:01:00:00 60
BRK2 Break 2 Part 1 00:01:00:00 60
BRK2 Break 2 Part 2 00:01:00:00 60
BRK2 Break 2 Part 3 00:01:00:00 60
BRK3 Break 3 Part 1 00:01:00:00 60
BRK3 Break 3 Part 2 00:01:00:00 60


Desired O/P:


BRK1 Break 1 Part 1 00:01:00:00 60
Part 2 00:01:00:00 60
BRK2 Break 2 Part 1 00:01:00:00 60
Part 2 00:01:00:00 60
Part 3 00:01:00:00 60

Question Posted / sreeram84n

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What are the differences between user defined functions and stored procedures?

0 Answers  

what is a transaction and what are acid properties? : Sql server database administration

0 Answers  

What are the purposes of floor and sign functions?

0 Answers  

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

0 Answers  

what's the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

0 Answers  

How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers   TCS,

What do you do in data exploration

0 Answers   EXL,

Does index slows down insert statements?

0 Answers  

Can you explain various data region available in ssrs with their use?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories