Questions & Answers by ahmed_sa - CodeProject

Click here to Skip to main content

Total posts by ahmed_sa: 491

0

answers

Incorrect syntax near keyword as when make pivot so how to solve it ?

11-Apr-21 21:18pm - updated 11-Apr-21 22:20pm

stored-procedure

1

answer

Msg 537, level 16, state 3, procedure recover_truncated_data_proc, line 113 invalid length parameter passed to the LEFT or SUBSTRING function.

8-Apr-21 11:21am - updated 9-Apr-21 1:22am

stored-procedure

2

answers

Can I use over() after from table statment on SQL server 2012 ?

15-Mar-21 11:25am - updated 15-Mar-21 23:09pm

1

answer

How to delete from trades table when part id not exist on mapping table code type from and code value from?

14-Mar-21 12:20pm - updated 14-Mar-21 22:22pm

, +

1

answer

How to increase cell quantity using keyboard up and down arrows ?

13-Mar-21 13:19pm - updated 13-Mar-21 23:36pm

0

answers

How to get value portion key to every rn from 1 to 3 row on one row?

25-Jan-21 21:44pm - updated 7-Mar-21 8:33am

stored-procedure

2

answers

When search on long text on table have 40 milion rows it is very slow so what I do ?

20-Feb-21 12:22pm - updated 20-Feb-21 15:02pm

stored-procedure

1

answer

I get error the multi-part identifier "rhst.name" could not be bound.?

18-Feb-21 0:26am - updated 18-Feb-21 1:12am

stored-procedure

1

answer

When build project error manifest display why and how to solve issue ?

20-Jan-21 15:38pm - updated 20-Jan-21 15:42pm

0

answers

How to call sp and pass parameters to make pivot on sample below?

7-Jan-21 6:01am

stored-procedure

1

answer

File created with name [object formdata] but it must be name delivery.xlsx

7-Dec-20 14:52pm - updated 7-Dec-20 23:39pm

1

answer

When make dynamic query converting name field to numbers give error ?

16-Nov-20 12:31pm - updated 16-Nov-20 22:24pm

SQL-Server-2012

, +

1

answer

When update data on temparts table mass value changed after float point ?

7-Nov-20 8:06am - updated 8-Nov-20 23:44pm

SQL-Server-2012

, +

1

answer

How to get active part for obsolete parts on part ID x on replacement table ?

12-Sep-20 10:36am - updated 12-Sep-20 15:52pm

stored-procedure

1

answer

Can't update status to match characters in case of signature key value is stars?

7-Sep-20 17:28pm - updated 8-Sep-20 6:02am

stored-procedure

1

answer

How to rewrite query to take small time when executed ?

27-Aug-20 4:02am - updated 4-Sep-20 6:59am

stored-procedure

0

answers

Can I get missed rows from temp table where not returned from join to function ?

23-Aug-20 14:37pm - updated 23-Aug-20 14:39pm

stored-procedure

1

answer

WHEN join query with #tempplandcodetype become very slow so how to solve slow performance ?

5-Aug-20 14:32pm - updated 6-Aug-20 0:22am

stored-procedure

2

answers

When run query for only part it take too much time for only one part why ?

21-Jul-20 21:04pm - updated 22-Jul-20 5:58am

stored-procedure

1

answer

How to handle changes on files on git source control before pull last changes?

5-Jul-20 7:35am - updated 5-Jul-20 18:37pm

Interested
Ignored

Last 24hrs

This month

Pete O'Hanlon	40
OriginalGriff	30
Richard MacCutchan	10
Dave Kreskowiak	10
Member 1408653	10

Pete O'Hanlon	1,490
OriginalGriff	1,132
Richard MacCutchan	335
Richard Deeming	300
Dave Kreskowiak	290