Skip to main content
Share Your Experience: Take the 2024 Developer Survey
Juan Velez's user avatar
Juan Velez's user avatar
Juan Velez's user avatar
Juan Velez
  • Member for 12 years, 2 months
  • Last seen more than 1 year ago
  • In the Cloud
65 votes
4 answers
142k views

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

16 votes
3 answers
188k views

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

12 votes
4 answers
14k views

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

11 votes
3 answers
17k views

SSIS keeps force changing excel source string to float

11 votes
4 answers
23k views

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

10 votes
3 answers
168k views

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

9 votes
3 answers
52k views

Why is this Full Outer Join not working?

9 votes
3 answers
68k views

Converting Non Unicode string to Unicode string SSIS

9 votes
2 answers
68k views

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

7 votes
1 answer
9k views

SSIS - Fixed width flat file mapping tool/technique

7 votes
1 answer
6k views

Double Unpivot?

7 votes
1 answer
398 views

Table order in Join Query

7 votes
2 answers
36k views

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

6 votes
2 answers
1k views

Connecting to a Remote SQL Server 2008 Instance

6 votes
3 answers
383 views

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

6 votes
1 answer
10k views

Update "NULL" string to Actual NULL value

5 votes
3 answers
9k views

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

5 votes
3 answers
10k views

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

4 votes
1 answer
10k views

Agent job will not run

4 votes
2 answers
50k views

Access denied when trying to run an agent job

4 votes
4 answers
2k views

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

4 votes
2 answers
6k views

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

3 votes
2 answers
9k views

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

3 votes
1 answer
9k views

SQL Server - DELETE from subquery/derived table

3 votes
1 answer
7k views

Create Temp Table From Stored Procedure Result

3 votes
1 answer
88 views

What does this code do?

3 votes
1 answer
2k views

Changing Query Results?

3 votes
2 answers
643 views

SQL Server 2008 ODBC

3 votes
2 answers
2k views

SQL Server 2008 Query Saved in Logs?

3 votes
2 answers
1k views

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