[T-SQL] Funnies on Views??? |
- Funnies on Views???
- Query Help
- Query Help
- I want to write validation Query which should return invalid parents if any....
- having problem in creating table from another table
- Why would you ever use EXECUTE AS CALLER?
| Posted: 27 May 2013 12:13 AM PDT Hi allJust a quick one. As we all know a view is a set of columns from a table we want non-admins to see.Now I am having a strange problem. When I make an amendment to a table (structural wise), the view breaks.All my view are written as "select * from"...and idea's why this happens? |
| Posted: 26 May 2013 11:34 PM PDT Hi,Can some one throw some light on how to approach this....CREATE TABLE A (ID1 VARCHAR(10),ID2 VARCHAR(10))INPUTTABLE A Id1 ID2A BB CD EF Gand I want the Output to be as followsID1 ID2A CB ED GThanks..... |
| Posted: 26 May 2013 10:44 PM PDT Create table #temp( ID int identity(1,1), ActivityName varchar(max), ActivityDate datetime)Insert into #tempValues('Successfully Login into Dynamic Portal Application','2013-05-20 13:22:21'),('Login Success into Liferay SAMl Application','2013-05-21 15:28:08'),('Login Success into Zoho SAMl Application','2013-05-21 15:28:08'),('Login Success into Intranet Non SAMl Application','2013-05-23 13:04:22'),('Logout Successfully from application','2013-05-21 18:20:07'),('Successfully Login into Dynamic Portal Application','2013-05-20 14:22:21'),('Login Success into Liferay SAMl Application','2013-05-21 16:28:08'),('Login Success into Zoho SAMl Application','2013-05-21 16:29:08'),('Login Success into Intranet Non SAMl Application','2013-05-21 15:04:22'),('Logout Successfully from application','2013-05-21 19:20:07')Desired Output:ActivityName LoginTime LogOutTimeLiferay SAMl Application 2013-05-21 15:28:08 2013-05-21 18:20:07Zoho SAMl Application 2013-05-21 15:28:08 2013-05-21 18:20:07Intranet Non SAMl Application 2013-05-23 13:04:22 2013-05-21 18:20:07Liferay SAMl Application 2013-05-21 16:28:08 2013-05-21 19:20:07Zoho SAMl Application 2013-05-21 16:29:08 2013-05-21 19:20:07Intranet Non SAMl Application 2013-05-21 15:04:22 2013-05-21 19:20:07LogOut time of the Activities will be the logout time of application.... |
| I want to write validation Query which should return invalid parents if any.... Posted: 26 May 2013 05:53 PM PDT I have a table for which I want to validate where each parent intermediary is also a parent to itself. It means I want to write validation Query which should return invalid parents I If any..COLUMN DATATYPE DESCRIPTIONIntermediaryPK int SourceSystemID tinyint Intermediary sourceIntermediaryID nvarchar(20) Intermediary IDIntermediaryName nvarchar(200) Intermediary nameIntermediaryTypeID nvarchar(1) Intermediary typeParentIntermediaryID nvarchar(20) Intermediary parentIntermediaryTypePK tinyint Intermediary typeIntermediaryCategoryPK smallint Intermediary categoryParentIntermediaryPK int Parent intermediary PKGrandParentIntermediaryPK int Grand parent intermediary PK.. |
| having problem in creating table from another table Posted: 26 May 2013 03:41 PM PDT Hi all, I have a table with 2 columns named Depot_Id & Depot_Name, i have to make another table from the values inserted into Depot_Name as the columns of new table. I dont have any idea for that...kindly suggest me solution for this. this is Depot Table:- Depot_Id Depot_Name 1 A2 B3 C Now i need another table in which column name should b A,B and C.. |
| Why would you ever use EXECUTE AS CALLER? Posted: 26 May 2013 01:18 PM PDT Since it is the default, I don't understand what the point of this option would be. |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / T-SQL (SS2K8) To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment