|
Extract part of Zipcode from full address string
|
|
6
|
11288
|
March 3, 2016
|
|
Select Statement
|
|
4
|
835
|
March 3, 2016
|
|
Newbie - I Dont Know
|
|
7
|
1091
|
March 3, 2016
|
|
Extract numeric values with digits from string
|
|
6
|
3158
|
March 3, 2016
|
|
I got a Stored Procedures that truncate the table TBL1 before insert data from TBL2 table, but before I truncate the table I want to make sure the table TBL2 rowcount <> 0, if rowcount = 0 then PRINT '* Source empty *' and go to end_of_sp ELSE Insert
|
|
1
|
416
|
March 3, 2016
|
|
Show 0 values if they are present
|
|
5
|
1182
|
March 2, 2016
|
|
If Column Exists in Source But Not Destination Then Create New Column
|
|
5
|
1724
|
March 2, 2016
|
|
Way to optimize this sql
|
|
4
|
800
|
March 2, 2016
|
|
Replication Monitor show strange things
|
|
0
|
425
|
March 2, 2016
|
|
Filtering Dates
|
|
10
|
1517
|
March 2, 2016
|
|
Issue with upgrading SQL Server on Virtual machine
|
|
4
|
872
|
March 2, 2016
|
|
Remove .00 from float data type and set it to a whole number
|
|
1
|
609
|
March 2, 2016
|
|
Search my question
|
|
2
|
443
|
March 2, 2016
|
|
Identifier Expected
|
|
1
|
517
|
March 2, 2016
|
|
Unable to execute sql query using CTE and Synonynm
|
|
5
|
1411
|
March 2, 2016
|
|
Database File Size Increased
|
|
11
|
1626
|
March 2, 2016
|
|
SQL Server Join Help (Basic)
|
|
2
|
790
|
March 2, 2016
|
|
Split records in SQL server
|
|
1
|
679
|
March 2, 2016
|
|
Copy large table to table
|
|
17
|
2070
|
March 2, 2016
|
|
Replication Simulation
|
|
1
|
439
|
March 2, 2016
|
|
Ssis transaction not working properly
|
|
0
|
761
|
March 2, 2016
|
|
Need help writing SQL query to insert single row into table using current date information
|
|
5
|
713
|
March 2, 2016
|
|
Runing a script after on alwayson failover SQL Server 2012
|
|
8
|
4607
|
March 1, 2016
|
|
Highlighting text
|
|
6
|
2340
|
March 1, 2016
|
|
Where condition with multiple columns
|
|
1
|
526
|
March 1, 2016
|
|
Need to return rows based on other table
|
|
4
|
691
|
March 1, 2016
|
|
Show all tables where two columns exist - SQL 2008
|
|
5
|
919
|
March 1, 2016
|
|
Help with query
|
|
2
|
648
|
March 1, 2016
|
|
Leap-day problem?
|
|
3
|
932
|
March 1, 2016
|
|
Optimization of this query
|
|
12
|
1534
|
March 1, 2016
|