|
Insert trigger executing on update
|
|
9
|
933
|
October 30, 2017
|
|
Fiscal year get forward from current month
|
|
5
|
733
|
October 29, 2017
|
|
Replacing data
|
|
1
|
432
|
October 29, 2017
|
|
Check duplicate records during insert
|
|
0
|
511
|
October 29, 2017
|
|
Roll over values if NULL
|
|
3
|
1495
|
October 27, 2017
|
|
How to take backup databaseobjects(tables scripts,storeprocedure and functions etc) in sqlserver using sql scripts
|
|
2
|
641
|
October 27, 2017
|
|
For linked server returned message "ROW-00014: 젠⣫update) 饸䠮멥寠餰ꥰ魠᮱㠤ລ੭ ...". Msg 7343, Level 16, State 4, Line 1 The OLE DB provider "ORAOLEDB.Oracle" for linked server "Myoracle" could not UPDATE table "[Myoracle]..[CS1].[ITF_MATERIAL]"
|
|
1
|
1572
|
October 27, 2017
|
|
Convert Varchar round value to 2 decimals
|
|
4
|
3351
|
October 25, 2017
|
|
Formulated Closing Balance Column
|
|
1
|
611
|
October 25, 2017
|
|
How to Store More then 30000 characters in sql server 2012
|
|
4
|
2582
|
October 25, 2017
|
|
String Manipulation
|
|
2
|
573
|
October 25, 2017
|
|
ForEach Loop Connection Fails Due to Slash in Server Name
|
|
3
|
1273
|
October 24, 2017
|
|
Select only duplicates entry with join
|
|
3
|
555
|
October 24, 2017
|
|
Removing Duplicates
|
|
7
|
819
|
October 22, 2017
|
|
Trying to detect incorrect capitalisation in names
|
|
5
|
863
|
October 19, 2017
|
|
Converting rows to columns
|
|
1
|
488
|
October 19, 2017
|
|
Display data from vertical to horizontal
|
|
1
|
489
|
October 19, 2017
|
|
SP is inserting only ONE row of records. Any ideas?
|
|
6
|
874
|
October 18, 2017
|
|
Deployment State Compliance Question
|
|
5
|
595
|
October 18, 2017
|
|
Format Function doesnt work
|
|
6
|
920
|
October 18, 2017
|
|
Problem in Decimal
|
|
7
|
781
|
October 17, 2017
|
|
Trigger is not working
|
|
2
|
675
|
October 17, 2017
|
|
Cached result from stored procedure?
|
|
4
|
1048
|
October 17, 2017
|
|
SQL Query Help
|
|
2
|
479
|
October 17, 2017
|
|
Conversion of hours to minutes using Stored Procedures
|
|
1
|
778
|
October 17, 2017
|
|
Pivot.unpivot
|
|
4
|
555
|
October 16, 2017
|
|
Need matching comma separated value from 1 table column to update in another table column using like
|
|
4
|
654
|
October 16, 2017
|
|
Add row and last found value if row is missing
|
|
4
|
1007
|
October 15, 2017
|
|
Get Date From From Calendar As Per Work Day
|
|
2
|
637
|
October 15, 2017
|
|
Calculate LEN with embedded TABs
|
|
5
|
756
|
October 15, 2017
|