Questions & Answers by Member 10501509 - CodeProject

Click here to Skip to main content

Total posts by Member 10501509: 23

2

answers

please any one explain pivot

7-Apr-14 0:42am - updated 16-Aug-17 2:46am

SQL-Server-2012

1

answer

I Want To Optimize This Store Procedure For One Use It Taking 71.942 Ms I Want To Reduce This Time

15-Oct-14 3:12am - updated 15-Oct-14 10:36am

0

answers

i am not getting profile correctly in the below query

29-Apr-14 20:52pm - updated 2-May-14 3:06am

SQL-Server-2012

0

answers

fecth data for each profile--Platfrom and skills

30-Apr-14 5:17am - updated 30-Apr-14 23:27pm

SQL-Server-2008R2

0

answers

By Combining Below Two Query's I Want To Fetch The Result Profile ,Specialization As Platfrom,Reference_Skills.Skilllookupvalue As Skills

29-Apr-14 23:13pm

SQL-Server-2008R2

1

answer

explain table variable in briefly with examples

8-Apr-14 20:54pm - updated 8-Apr-14 22:44pm

SQL-Server-2012

1

answer

i don't want to pass worked_dates dynamically ,i want to pass worked_dates in between range in pivot

3-Apr-14 23:57pm - updated 4-Apr-14 0:44am

SQL-Server-2008R2

1

answer

using stuff for fullname when task is same for two person even though fullname is not separating with comma

23-Mar-14 22:26pm - updated 24-Mar-14 20:48pm

1

answer

I want to combine these two triggers in to single trigger .how to do that

18-Mar-14 20:11pm - updated 1-Apr-14 15:10pm

2

answers

I have created trigger for after insert now how to do for update with in same trigger

18-Mar-14 3:08am - updated 18-Mar-14 4:02am

2

answers

how to use stuff function

4-Mar-14 23:34pm - updated 5-Mar-14 19:30pm

0

answers

Below Query Giving Correct Workedhours For Single User If I Fetch For All Users I Am Getting Default Value Workedhours =2 Hrs 9 Min For All Users.How To Solve This Problem.

26-Feb-14 22:16pm - updated 27-Feb-14 20:10pm

3

answers

By Using Below the uery vzn

25-Feb-14 2:32am - updated 26-Feb-14 17:14pm

3

answers

I Am Getting Error If I Execute The Below Query (An Expression Of Non-Boolean Type Specified In A Context Where A Condition Is Expected, Near 'Then'.)

15-Jan-14 20:26pm - updated 26-Feb-14 17:13pm

1

answer

If I Execute Below Query I Am Getting two Results One Is For 19Th Date And One More For 20Th Date Separately How To Combine Those Two Result Set In To Single.

25-Feb-14 18:41pm - updated 25-Feb-14 23:09pm

3

answers

By Using Below Query I Am Fetching Absentees And Their Absentee Date Same Thing I Want To Do For Between Dates How To Do That

20-Feb-14 0:46am - updated 25-Feb-14 2:14am

1

answer

i got below problem when changing one database to another database(selecting in drop down ) in ms sql management studio

12-Feb-14 0:24am - updated 12-Feb-14 3:00am

1

answer

How To Select Max Checktime I Am Getting Wrong Out Put

10-Feb-14 0:08am - updated 10-Feb-14 0:47am

1

answer

difference between close and Deallocate cursor ?why we want to Deallocate the cursor after closing cursor

7-Feb-14 1:24am - updated 7-Feb-14 1:32am

1

answer

if profileId=2379 then diaplay other profileid s (organization hierarchy) how to do this query any one can help me

12-Jan-14 20:26pm - updated 12-Jan-14 21:41pm

Interested
Ignored

Last 24hrs

This month

Richard Deeming	115
Pete O'Hanlon	25
OriginalGriff	25
Kevin Marois	10
Dave Kreskowiak	10

Pete O'Hanlon	1,580
OriginalGriff	1,227
Richard Deeming	435
Richard MacCutchan	355
Dave Kreskowiak	330