|
Roll over values if NULL
|
|
3
|
1470
|
October 27, 2017
|
|
How to take backup databaseobjects(tables scripts,storeprocedure and functions etc) in sqlserver using sql scripts
|
|
2
|
616
|
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
|
3328
|
October 25, 2017
|
|
Formulated Closing Balance Column
|
|
1
|
599
|
October 25, 2017
|
|
How to Store More then 30000 characters in sql server 2012
|
|
4
|
2552
|
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
|
793
|
October 22, 2017
|
|
Trying to detect incorrect capitalisation in names
|
|
5
|
829
|
October 19, 2017
|
|
Converting rows to columns
|
|
1
|
471
|
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
|
585
|
October 18, 2017
|
|
Format Function doesnt work
|
|
6
|
846
|
October 18, 2017
|
|
Problem in Decimal
|
|
7
|
741
|
October 17, 2017
|
|
Trigger is not working
|
|
2
|
649
|
October 17, 2017
|
|
Cached result from stored procedure?
|
|
4
|
945
|
October 17, 2017
|
|
SQL Query Help
|
|
2
|
470
|
October 17, 2017
|
|
Conversion of hours to minutes using Stored Procedures
|
|
1
|
771
|
October 17, 2017
|
|
Pivot.unpivot
|
|
4
|
532
|
October 16, 2017
|
|
Need matching comma separated value from 1 table column to update in another table column using like
|
|
4
|
629
|
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
|
780
|
October 14, 2017
|
|
Count the number of rows for different row
|
|
1
|
505
|
October 13, 2017
|
|
How to get Duplicate substrings in DB2 SQL
|
|
3
|
808
|
October 12, 2017
|
|
Multiple Table Joins
|
|
1
|
473
|
October 10, 2017
|