Naveen PK (8/27/2013)

---

I have a table with two columns, DealID & NetOutDeals (consider this as foreign key to DealID). I am trying to find the Order in which I can...

Patrick Womack (8/27/2013)

---

Using SQL Server 2008 R2, but also have access to SQL Server 2012

I have this sample data.

ItemNo DueDate Cham

121117 2013-09-05

121098...

Jeff Moden (8/27/2013)

---

Be careful, now. Please see the following article for why ISNUMERIC should never...

OK. I created data for the last of your sample data.

INsert into @OrderDetail Values ( 10, 500)

INsert into @OrderDetail Values ( 20, 500)

INsert into @OrderDetail Values ( 30, 500)

Now to...

Coriolan (8/27/2013)

---

I have a requirement to find all orders that contain the same product. This same product is not defined upfront.

declare @Orderdetail table

(OrderID int,

ProductID int)

INsert into @OrderDetail Values (...

As Steve suggested you can use sql_expression_dependencies (http://technet.microsoft.com/en-us/library/bb677315.aspx)

rocky_498 (8/27/2013)

---

Hi Guys,

I google but couldn't any find help. Here is the issue.

From SSMS if I want to save any sql to .sql from File==>Save SqlQuery.Sql==>ask destination where...

sqlnaive (8/27/2013)

---

Great... So the correct statement should be:

"DELETE is a logged operation while TRUNCATE is not" as the truncate just deallocates the data pages from the table and that is...

That helps clarify. I wouldn't use MERGE for this. I converted your sample ddl into temp tables so it is easier to work with in a test database.

create table #SourceTable

(number...

sqlnaive (8/27/2013)

---

Totally agreed Gail. I have been to so many discussions over so many sites about this particular difference between DELETE & TRUNCATE that I'm confused.

"DELETE can be ROLLED BACK...

Hi and welcome to SSC. I would love to help you but you haven't provided enough information for me to help. In order to help we will need a few...

ningaraju.ne 46825 (8/27/2013)

---

Actually we have used newid() in order by clause to do shuffling.But My Manager is asking me to get the algorithm used for that clause and need to...

ningaraju.ne 46825 (8/27/2013)

---

Hi All,

I have an hierarchy table as below which stores the key data.And the value for this key will be stored in another table.And the Value can be...

vignesh.ms (8/26/2013)

---

hi SSCrazy Eights,

I have 2 table say source and destination.

I'm trying to insert data from source table to destination table ,which are not available in the destination table.

this is...

Guessing you missed it in the OP.

I implemented change data capture, but I found interpreting...