|
Insert trigger executing on update
|
|
9
|
904
|
October 30, 2017
|
|
Fiscal year get forward from current month
|
|
5
|
716
|
October 29, 2017
|
|
Replacing data
|
|
1
|
427
|
October 29, 2017
|
|
Check duplicate records during insert
|
|
0
|
501
|
October 29, 2017
|
|
Roll over values if NULL
|
|
3
|
1475
|
October 27, 2017
|
|
How to take backup databaseobjects(tables scripts,storeprocedure and functions etc) in sqlserver using sql scripts
|
|
2
|
618
|
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
|
1565
|
October 27, 2017
|
|
Convert Varchar round value to 2 decimals
|
|
4
|
3335
|
October 25, 2017
|
|
Formulated Closing Balance Column
|
|
1
|
599
|
October 25, 2017
|
|
How to Store More then 30000 characters in sql server 2012
|
|
4
|
2563
|
October 25, 2017
|
|
String Manipulation
|
|
2
|
551
|
October 25, 2017
|
|
ForEach Loop Connection Fails Due to Slash in Server Name
|
|
3
|
1260
|
October 24, 2017
|
|
Select only duplicates entry with join
|
|
3
|
555
|
October 24, 2017
|
|
Removing Duplicates
|
|
7
|
796
|
October 22, 2017
|
|
Trying to detect incorrect capitalisation in names
|
|
5
|
838
|
October 19, 2017
|
|
Converting rows to columns
|
|
1
|
474
|
October 19, 2017
|
|
Display data from vertical to horizontal
|
|
1
|
485
|
October 19, 2017
|
|
SP is inserting only ONE row of records. Any ideas?
|
|
6
|
829
|
October 18, 2017
|
|
Deployment State Compliance Question
|
|
5
|
588
|
October 18, 2017
|
|
Format Function doesnt work
|
|
6
|
882
|
October 18, 2017
|
|
Problem in Decimal
|
|
7
|
748
|
October 17, 2017
|
|
Trigger is not working
|
|
2
|
653
|
October 17, 2017
|
|
Cached result from stored procedure?
|
|
4
|
1029
|
October 17, 2017
|
|
SQL Query Help
|
|
2
|
475
|
October 17, 2017
|
|
Conversion of hours to minutes using Stored Procedures
|
|
1
|
772
|
October 17, 2017
|
|
Pivot.unpivot
|
|
4
|
533
|
October 16, 2017
|
|
Need matching comma separated value from 1 table column to update in another table column using like
|
|
4
|
630
|
October 16, 2017
|
|
Add row and last found value if row is missing
|
|
4
|
987
|
October 15, 2017
|
|
Get Date From From Calendar As Per Work Day
|
|
2
|
624
|
October 15, 2017
|
|
Calculate LEN with embedded TABs
|
|
5
|
739
|
October 15, 2017
|