I have a table like this
What I want is to...
I have 2 tables TblA and TblB
TblA has records as shown
2 Some Other Name
TblB has Records as shown...
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...
My requirment is this.
I have a master table say (MasterID, Recname1,RecName2...)
I have a child table that looks like this...
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
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...
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...
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.
What i need is...
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...
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...
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.