Thanks drew.allen,
Thats exactly what I want

Well, Let me explain the scenario of this procedure
I have 3 tables 
Suggestions, Complains, Payments
I'm getting a notification of New or Unread of Suggestion and Complains and I...

Hello Thom A,
it seems there is something wrong with the last query, if there are more than 1 record it return the same error again

any suggestion ?

Thank you Thom A,
thats exactly what I need to...

I'm aiming to have a table with 6 columns
SuggestionID  - NewSuggestions - ComplainID - NewComplains - KidID - Name

my problem here I'm getting the data from...

using union will make them in the same column which is not correct in my case

Thanks Drew for your reply,

Actually I will need it for some other reasons related to reports (Customer's requirements)

I did it and it is now working perfectly, just I have a...

Hello,

After some tries I did it as the below

SELECT *,

(select COUNT(*) from Table1 where myfield = 'False') as Expr1,

(select COUNT(*) from Table2 where myfield = 'False') as Expr2,

(select COUNT(*) from...

Thanks for the quick and easy reply 🙂

Appreciated

Thanks John it looks a great tutorial I will read it 🙂

Thanks guys for help I will test it out and give a reply soon

GilaMonster,

After our last discussion I started to read some about the SQL Injection

I think using the dynamic...

Thanks dwain.c

But I cannot create a table, its a Web Application and many users use it at the same time

and it will slow down my application too

can you please tell me how to do it ?

I tried it many times but I got many errors

thanks

it works when I write the coulmn name instead of the variable

the '@AddItemVal' is declared as nvarchar

'@Myval' is nvarchar

Column2 is nvarchar

@MyColumn is nvarchar

the problem happens only when I...

I'm 100% accept what you said, But

I'm a beginner and I don't know how to use Inner Join, Outer Join and such functions so I think I have to work...