Ray M (4/3/2013)

---

Lynn Pettis (4/3/2013)

---

Does this help you figure out how to query the data into a format you can use? Personally, I'd load the data as is from...

erikd (4/3/2013)

---

Lynn Pettis (4/3/2013)

---

erikd (4/3/2013)

---

There is...

Does this help you figure out how to query the data into a format you can use? Personally, I'd load the data as is from Excel into a staging...

So, does...

DBA12345 (4/3/2013)

---

I need to pull the info from excel to the Database table through SSIS. I need logic for below scenario.

Excel Look like below:

Server ...

erikd (4/3/2013)

---

Hi,

So, even though my company has nothing to do with telemarketing, we've been asked to bump phone numbers for one project up against the national DNC list. It's a...

It was worth a shot, but what I talked...

5280_Lifestyle (4/3/2013)

---

As for the ANSI joins, when I tried switching to ANSI some of the rows were left out. With the old outer joins, the output was 243 rows. With...

There is no guarantee of order if you do not specify an ORDER BY in your select query.

Biggest suggestion I have, don't use date as a column name. It is also a datatype starting with SQL Server 2008.

This:

create table #temp

(CalendarDate datetime,

IsWeekDay int,

SchoolDay int)

insert into #temp values('2011-08-06 00:00:00.000',0,0)

insert into #temp values('2011-08-07 00:00:00.000',0,0)

insert into #temp values('2011-08-08 00:00:00.000',0,0)

insert into #temp values('2011-08-09 00:00:00.000',0,0)

insert into #temp values('2011-08-10 00:00:00.000',0,0)

insert...

erikd (4/3/2013)

---

Sean Lange (4/3/2013)

---

Using your dynamic code as an example this will produce the same results but as a single query instead of 1 query for each column.

declare @thing...

kapil_kk (4/3/2013)

---

Hi all, I have created a sp in which I want to extract last identity value after doing insertion....

But its giving me error that @new_identity parameter is not...

GilaMonster (4/3/2013)

---

jasona.work (4/3/2013)

---

So my worst-case solution to reduce the size of data in the TLogs is to do the following:

1. After-hours, switch all DBs from Full Recovery to Simple,...

I have seen people actually configure job steps to quit the job reporting failure for the On success action.

You may want to check this.