User Juan Velez

65 votes

4 answers

141k views

Does SQL Server CASE statement evaluate all conditions or exit on first TRUE condition?

asked May 29, 2013 at 18:33

16 votes

3 answers

186k views

SQL Server Isnull Returning 1900-01-01 when field is null

asked Jan 22, 2015 at 16:52

12 votes

3 answers

14k views

SQL Server Insert Into - How to identify the column that is causing truncation error

asked Jul 10, 2017 at 12:46

11 votes

3 answers

16k views

SSIS keeps force changing excel source string to float

asked Apr 4, 2013 at 15:41

11 votes

4 answers

22k views

Checking if 2 tables ( on different servers ) have the same exact data

asked Aug 13, 2012 at 16:08

10 votes

2 answers

168k views

How to Get the Sum (total) of a column in a query result set

asked Mar 13, 2012 at 13:34

9 votes

3 answers

51k views

Why is this Full Outer Join not working?

asked Mar 20, 2012 at 19:24

9 votes

3 answers

68k views

Converting Non Unicode string to Unicode string SSIS

asked May 6, 2013 at 16:13

9 votes

2 answers

67k views

How can I resolve SSIS Excel Connection Manager Error 0xC0209303?

asked Sep 18, 2015 at 20:11

7 votes

1 answer

9k views

SSIS - Fixed width flat file mapping tool/technique

asked Oct 16, 2015 at 18:16

7 votes

1 answer

6k views

Double Unpivot?

asked Feb 9, 2017 at 21:50

7 votes

1 answer

398 views

Table order in Join Query

asked Apr 16, 2012 at 20:16

7 votes

2 answers

36k views

SSIS File System Task Copy File Could not find part of the path error

asked Mar 27, 2013 at 19:53

6 votes

2 answers

1k views

Connecting to a Remote SQL Server 2008 Instance

asked Aug 22, 2012 at 17:34

6 votes

3 answers

383 views

Which is the most efficient way to run a particular select query?

asked Mar 14, 2012 at 14:36

6 votes

1 answer

10k views

Update "NULL" string to Actual NULL value

asked Apr 18, 2013 at 18:37

5 votes

3 answers

8k views

SSIS Data Flow Task Excel to SQL table NULL value will not work for small INT datatype

asked Apr 3, 2013 at 16:13

5 votes

3 answers

10k views

How can you save all user-defined functions to txt files on your local hard drive?

asked Jul 19, 2012 at 19:42

4 votes

1 answer

10k views

Agent job will not run

asked Dec 2, 2012 at 6:04

4 votes

2 answers

50k views

Access denied when trying to run an agent job

asked Dec 4, 2012 at 17:37

4 votes

4 answers

2k views

Programmatically finding minimum set of fields necessary to create a unique composite key

asked Nov 16, 2015 at 14:52

4 votes

2 answers

5k views

SSIS: Check file for row delimiter and dynamicly update row delimiter in Flat File Connection Manager at run time

asked Jan 18, 2016 at 16:46

3 votes

2 answers

9k views

Why is using a CTE so much faster than using a #Temp Table in this query?

asked Oct 20, 2015 at 19:12

3 votes

1 answer

9k views

SQL Server - DELETE from subquery/derived table

asked Nov 5, 2015 at 18:34

3 votes

1 answer

7k views

Create Temp Table From Stored Procedure Result

asked Mar 19, 2013 at 19:12

3 votes

1 answer

88 views

What does this code do?

asked Aug 1, 2012 at 13:57

3 votes

1 answer

2k views

Changing Query Results?

asked Apr 27, 2012 at 19:15

3 votes

2 answers

643 views

SQL Server 2008 ODBC

asked Jun 11, 2012 at 15:15

3 votes

2 answers

2k views

SQL Server 2008 Query Saved in Logs?

asked Jul 6, 2012 at 16:19

3 votes

2 answers

1k views

Rearranging Data in an MS Access 2007 table into a new table format/Result Output

asked Jan 26, 2014 at 22:56

Stack Exchange Network

62 Questions

Does SQL Server CASE statement evaluate all conditions or exit on first TRUE condition?

SQL Server Isnull Returning 1900-01-01 when field is null

SQL Server Insert Into - How to identify the column that is causing truncation error

SSIS keeps force changing excel source string to float

Checking if 2 tables ( on different servers ) have the same exact data

How to Get the Sum (total) of a column in a query result set

Why is this Full Outer Join not working?

Converting Non Unicode string to Unicode string SSIS

How can I resolve SSIS Excel Connection Manager Error 0xC0209303?

SSIS - Fixed width flat file mapping tool/technique

Double Unpivot?

Table order in Join Query

SSIS File System Task Copy File Could not find part of the path error

Connecting to a Remote SQL Server 2008 Instance

Which is the most efficient way to run a particular select query?

Update "NULL" string to Actual NULL value

SSIS Data Flow Task Excel to SQL table NULL value will not work for small INT datatype

How can you save all user-defined functions to txt files on your local hard drive?

Agent job will not run

Access denied when trying to run an agent job

Programmatically finding minimum set of fields necessary to create a unique composite key

SSIS: Check file for row delimiter and dynamicly update row delimiter in Flat File Connection Manager at run time

Why is using a CTE so much faster than using a #Temp Table in this query?

SQL Server - DELETE from subquery/derived table

Create Temp Table From Stored Procedure Result

What does this code do?

Changing Query Results?

SQL Server 2008 ODBC

SQL Server 2008 Query Saved in Logs?

Rearranging Data in an MS Access 2007 table into a new table format/Result Output