Your insert statements don't work. Here is the results.

String or binary data would be truncated.

The statement has been terminated.

Msg 8152, Level 16, State 2, Line 30

String or binary data would...

mxy (7/25/2014)

---

how to alter all objects in database i want to find if can any syntax errors in my database after restoring from sql 2008 to 2012. i Can create...

rajsin7786 (7/25/2014)

---

Hi Eirikur Eiriksson,

Thanks for your response

I've attached two SQL plans here, one is with product_dim and one without it. do let me know if you are unable to find...

dwilliscp (7/25/2014)

---

dwilliscp (7/25/2014)

---

I have a massive table (company, plant, resource, part number) that I need to create a from part number, to part number for every part within "Company, Plant,...

Peanut butter?

lubricant

jbalbo (7/23/2014)

---

Hi Sean

Thanks for the help with this..

As usual I can't explain myself.

Everything work except the carraage return.

I tried CHR13, but when I copy and paste into say .....

pdanes (7/23/2014)

---

Found it - there are a series of chained VBScript routines that activate all this, and one of them was sending a bad parameter to the stored procedure. Simple...

jbalbo (7/23/2014)

---

Sean helped me with this awhile back..

I need to add a carriage return between each record and I seem stuck !!

Once I get the carriage return it getting...

rxm119528 (7/22/2014)

---

;with CTE as

(select ROW_NUMBER() over( partition by CustomerID order by invoiceid) as rn,* from #invoices)

select

t1.invoiceid,t1.customerid,t1.total

from CTE t1

left outer join CTE...

Lynn Pettis (7/22/2014)

---

Sean Lange (7/22/2014)

---

Sean Lange (7/21/2014)

---

First you have to define what you mean by previous. I am guessing you mean InvoiceID? If you can post some consumable ddl and...

Sean Lange (7/21/2014)

---

First you have to define what you mean by previous. I am guessing you mean InvoiceID? If you can post some consumable ddl and sample data I can...

Of course you can have the same time on both machines. There is nothing that says a computer must use a certain timezone because of its physical location. I suspect...

How long does your procedure take? I am wondering if your are running into concurrency issues because you have multiple backups being run at the same time. 15 minutes is...

Steve Jones - SSC Editor (7/21/2014)

---

Sean Lange (7/17/2014)

---

SQLRNNR (7/17/2014)

---

The Dixie Flatline (7/16/2014)

---

Woohoo!! Done with work for the evening, and in the morning we're heading to New Orleans for a...