|
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
|
1473
|
October 27, 2017
|
|
How to take backup databaseobjects(tables scripts,storeprocedure and functions etc) in sqlserver using sql scripts
|
|
2
|
617
|
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
|
3333
|
October 25, 2017
|
|
Formulated Closing Balance Column
|
|
1
|
599
|
October 25, 2017
|
|
How to Store More then 30000 characters in sql server 2012
|
|
4
|
2561
|
October 25, 2017
|
|
String Manipulation
|
|
2
|
546
|
October 25, 2017
|
|
ForEach Loop Connection Fails Due to Slash in Server Name
|
|
3
|
1259
|
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
|
836
|
October 19, 2017
|
|
Converting rows to columns
|
|
1
|
472
|
October 19, 2017
|
|
Display data from vertical to horizontal
|
|
1
|
484
|
October 19, 2017
|
|
SP is inserting only ONE row of records. Any ideas?
|
|
6
|
825
|
October 18, 2017
|
|
Deployment State Compliance Question
|
|
5
|
586
|
October 18, 2017
|
|
Format Function doesnt work
|
|
6
|
847
|
October 18, 2017
|
|
Problem in Decimal
|
|
7
|
745
|
October 17, 2017
|
|
Trigger is not working
|
|
2
|
651
|
October 17, 2017
|
|
Cached result from stored procedure?
|
|
4
|
946
|
October 17, 2017
|
|
SQL Query Help
|
|
2
|
472
|
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
|
623
|
October 15, 2017
|
|
Calculate LEN with embedded TABs
|
|
5
|
739
|
October 15, 2017
|
|
Distinct with SUM and JOINS
|
|
4
|
781
|
October 14, 2017
|