Comments by vani suresh

vani suresh 30-Sep-16 3:13am View

Can you post with a print screen where the white space are occuring in table ?... normally LTRIM,RTRIM shoul'd work ..

vani suresh 30-Sep-16 3:08am View

Can you put your whole query for update..So that we can verify where is the problem.

vani suresh 8-Sep-16 0:08am View

Can you please elaborate your question with more details...

vani suresh 8-Sep-16 0:05am View

What i understand you are calculating the value column from second table
Ex: 'A' is present in second table value is 1
'E' is not present in second table value is 0
is it correct ?

vani suresh 13-Aug-16 10:24am View

Deleted

Hi ,

you can contact me here

vani suresh 12-Aug-16 4:37am View

You already, Downvoted my answer and whatever i did as per your comments and questions,
And again your query is doesn't work means then it's not my problem.

But anyhow, Have you put the SET NOCOUNT ON
And Declare variables for all fields?

Because,Those information was missing in your query.

And why the declare variables are different in FETCH Line and values.
Always will be the same , There is no @Equipment type in Fetch line.

Please correct all your query.

vani suresh 10-Aug-16 1:51am View

Hi,

Please check the query ,updated as per your comments.

vani suresh 10-Aug-16 1:23am View

Hi,

Please check the query i am only fetching name and department code and inserting into third table,
Inside the third table it have it's own ID (auto increment).But it's up to you Third table design.

vani suresh 9-Aug-16 10:06am View

Hi ,

The output should be like this ?
Id Name Department code
1 vani ENG-001
2 vani MATH-002
3 vani SOCIAL-001
4 vani GENSCIENCE-002
5 vani GEOGRAPHY-001
6 Ravi ENG-001
Let me know , If i miss any columns in third table

vani suresh 9-Aug-16 2:07am View

how come my question is downvoted? The question is not reasonable?

vani suresh 9-Aug-16 2:00am View

Hi poly,

Thanks for you help, but i already reported to Code project "Spam & abuse"
This link help me to find the solution.
http://www.codeproject.com/Questions/311615/Spam-message-in-my-code-project-article-How-to-rem

The red flag will appear based on a reputation, my reputation is low. that's why i can't see the red flag.

vani suresh 9-Aug-16 1:43am View

Hi, I didn't see any thing like a red flag

vani suresh 4-Aug-16 2:44am View

Hi,

Can you post the sample data from the join tables..Let me try for you

vani suresh 26-Jun-14 9:57am View

Welcome..

vani suresh 26-Jun-14 3:13am View

Deleted

Hi you want a code for restore and back for database in C#

Comments by vani suresh (Top 15 by date)