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
16 votes
3 answers
188k views

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

10 votes
3 answers
168k views

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

65 votes
4 answers
142k views

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

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?

9 votes
3 answers
52k views

Why is this Full Outer Join not working?

4 votes
2 answers
50k views

Access denied when trying to run an agent job

7 votes
2 answers
36k views

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

11 votes
4 answers
23k views

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

3 votes
3 answers
21k views

VBA Maximize Access Application Main Window

2 votes
1 answer
20k views

SSIS How can I write to a Specific Cell in an Excel Sheet

11 votes
3 answers
17k views

SSIS keeps force changing excel source string to float

2 votes
3 answers
16k views

SSIS Expressions Date Format get just YY for year

12 votes
4 answers
14k views

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

2 votes
1 answer
11k views

SQL Server JOIN not working

6 votes
1 answer
10k views

Update "NULL" string to Actual NULL value

4 votes
1 answer
10k views

Agent job will not run

5 votes
3 answers
10k views

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

3 votes
1 answer
9k views

SQL Server - DELETE from subquery/derived table

7 votes
1 answer
9k views

SSIS - Fixed width flat file mapping tool/technique

1 vote
4 answers
9k views

How should I Schedule SQL Server 2008 queries to run every month?

3 votes
2 answers
9k views

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

5 votes
3 answers
9k views

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

2 votes
1 answer
7k views

Why do I only see SYS and INFORMATION_SCHEMA tables? Access 2007 ODB to SQL Server 2008

2 votes
1 answer
7k views

SSIS Package Data Flow Task RollBack on Error

1 vote
1 answer
7k views

SSRS error - A scope is required for all aggregates in the page header or footer which reference fields

3 votes
1 answer
7k views

Create Temp Table From Stored Procedure Result

0 votes
2 answers
6k views

SSIS File System Task (Copy File Operation) OverWriteDestination functionality

7 votes
1 answer
6k views

Double Unpivot?

0 votes
1 answer
6k views

SSIS Connection String Expression at Run Time and during Execution