Hello Experts I have a table like this ID CommaSeperatedString 1 a,b,c,d,e 2 x,y,z What I want is to...
Hello Experts I have 2 tables TblA and TblB TblA has records as shown ID Names 1 SomeName 2 Some Other Name TblB has Records as shown...
Hello Experts I have a view with data as shown below. Col1 Col2 Col3 Col4 abc NULL NULL NULL NULL def NULL NULL ghi NULL NULL NULL...
I have this requirement. I have table A which has ID_A_A, ID_B_A and ID_C_A I have table B Which has ID_A_B,ID_B_B,ID_C_B I want to write a query to...
Hello Experts My requirment is this. I have a master table say (MasterID, Recname1,RecName2...) I have a child table that looks like this...
Hello Friends, I just want to share with a bug which i have found. Some of you may know this. But curious to know if this issue has been...
I have 2 choices but dont know what to take 1. Seperate Stored Procedures for every Static Query 2. A stored PRocedure with Index Parameters IF...
Hello I need to obtain the value from dynamic SQL Query in a stored procedure SET @MyRetvalue=EXEC 'SELECT myretvalue from my table' how can i assign...
Hello my requirement is as follows, I have 2 tables Called MainItems and SubItems. Each MainItems have n number of SubItems ( But n is same for all...
Hello 1. I have 2 tables. One contains Main Group Items and other contains Sub Group Items. 2. Each main Group Items will contain all sub Group...
Hello i have a field with comma seperated string values. eg, norway,denmark,germany,england etc i want to pull the text only say germany ie after 2...
Hello I need to create Index for 60 tables of Same Structure. Is there a way to create them using SQL Scripts instead of using Enterprise Manager...
Hello I have created interdependent Views. Like View 5 was done using View 4 and View 4 was done using 3 etc.. Now i have done some changes to View3...
Hello Is it possible to use a case staement in where query to pull data my requirment is like this i have 6 fields and based on the value i recieve...
Hello I need to remove all null values from all columns how do i use a query to get the column name and column datatype and update either empty...
Hello Here is my issue 1. I have a table with Primary Key , A Name Field. Sample Data 1 name1 2 name1 3 name1 4 name2 5 name3 What i need is...
Hello I need to Pull Primary Key values from a table and Assign them as comma seperated values to a nvarchar variable and return that variable...
Hello I have an identity Field and i have done some test and so it incremented the values from 1 to some numbers. Now after i have deleted the...
Hello I need one help. I need to change (Alter) the first Column of All table in my database from integer field to Identity Integer Field.I have...
Hello I need to develop a fast track application with limited time frame. So inorder to save time and coding what i have did was combined similar...
Separate names with a comma.
