Thank you Satya,Adriaan and Frankkalis for the information. Sorry for not following up on this, was having a short vacation.
The format I am looking...
Hello Frank Kalis
Say I have a UDF function called SplitCSVToTable which returns a table of splited items.
I have another table
TableA --> ID...
Vielen Dank Frank Kalis.
This is exactly what I was looking for.
Have a nice day!
I have a table like this
What I want is to...
Thanks Adriaan for the help.
You are the man.
Have a nice evening!
Thanks and Regards
Do you mean like this?
Select A.ID, A.Name from TblB A
WHERE Not Exists
(Select B.ID, B.Name from TblA B WHERE A.ID=B.ID AND...
I have 2 tables TblA and TblB
TblA has records as shown
2 Some Other Name
TblB has Records as shown...
Thanks for the reply. The following script provides me the cross tab view of the table.
But I want to remove the null values in...
I have a table say ID, FieldName
I am breaking this into a cross tab by 4 categories using a Case Statement
Thanks Adriaan for the reply
This is just a form of cross tab view I obtained from a table with 4 different categories (4 columns)
Now I need to...
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...
You are the man. Thanks a lot for your help. I owe you a dinner at some point for all the help you provide.
Have a great weekend!
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...
I have tried this query but it takes too long to process the query.
I have created a Temp Table and loaded the records and...
My requirment is this.
I have a master table say (MasterID, Recname1,RecName2...)
I have a child table that looks like this...
Guten Tag. Ich Danke Ihnen fuer die link.
Thanks for the reply. I always use prefixed columns, but I got this error when I was doing some testing on the query analyzer....
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...
Thanks Adriaan for the reply.
It is not unfiltered data but mix of both. I am moving all SQL stuff to stored procedures from my front...
I mean My_SP_Table1,My_SP_Table2,My_SP_Table3,My_SP_Table4,My_SP_Table5 say these 5 stored procedures each has a table or...
Separate names with a comma.