NJDave (6/13/2013)

---

Thanks - but I overwrite the BAK file with a more recent one and always have it in the same directory.

Is there anything in the database that shows what...

SQLRNNR (6/13/2013)

---

Brandie Tarvin (6/13/2013)

---

jasona.work (6/13/2013)

---

Why can I picture something like that actually being buried in the depths of the SQL / SSIS code?

One of those little "bored programmer" things that's...

kshatriya24 (6/13/2013)

---

Can you please help me converting datediff into seconds. I'm using SQL 2008 , the following command error out with pass valid argument.

round((ENDDTTM - BEGINDTTM) * 24 *...

Sean Lange (6/13/2013)

---

SQL_beginner1 (6/13/2013)

---

Hi Lynn,

I get the following error when I parse your script:

I'm using SQL Server 2008...

SQL_beginner1 (6/12/2013)

---

Hi,

I have a table (t_account_code) with the following three columns - AccountCode, StartDate and EndDate. The table does not have an ID column (I know - it was inherited)...

And how is this third column passed to the query?

mrbonk (6/12/2013)

---

Lynn Pettis (6/12/2013)

---

What is also missing is the DDL for the tables you are using along with the current indexes defined on those tables.

Part of the problem you are...

Perhaps you can explain what type of environment you are working in where you are going to be running arbitrary stored procedures (which may or may not take parameters) and...

What is also missing is the DDL for the tables you are using along with the current indexes defined on those tables.

Part of the problem you are having may also...

Yep, easy except you are...

SQL_Enthusiast (6/12/2013)

---

Okay, since you just burst my bubble, let me ask you a question. The SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED is being used on reports only and those reports...

Kaptnik (6/12/2013)

---

Let's say I have this dataset.

UserIDEmail

------------------------------------

1jamesbond@mi6.com

1jbond@mi6.com

1jamesb@mi6.com

2mpenny@mi6.com

3q@mi6.com

3weapons_dept@mi6.com

How do I pick out just one email address for each user id? I'm struggling to write a query to do it.

Just as long...

rick_markham (6/12/2013)

---

thanks for trying to help. I think a DBA out there should be able to point me to the correct setting. I had a DBA show me...

mmartin1 (6/12/2013)

---

try this

declare @MyDate datetime

set @mydate= '20130301'

select...

Just another way to do it:

code="sql"]

declare @AS400Date char(7) = '1130531';

select cast(cast(cast(@AS400Date as int) + 19000000 as char(8)) as date);

[/code]