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. Really appreciated Have a nice day!
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...
Thanks Adriaan for the help. You are the man. Have a nice evening! Thanks and Regards
Hello Adriaan 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...
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 Adriaan 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 ID...
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...
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...
Hello Adriaan 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...
Thanks Adriaan 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...
Hello Experts My requirment is this. I have a master table say (MasterID, Recname1,RecName2...) I have a child table that looks like this...
Halo FrankKalis, Guten Tag. Ich Danke Ihnen fuer die link. Grus vimalpercy
Hello Adriaan Thanks for the reply. I always use prefixed columns, but I got this error when I was doing some testing on the query analyzer....
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...
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...
Hello Dinakar, 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.
