Luis Cazares (9/20/2012)

---

At this moment, I wish I didn't post any response.

Your answers have been rude to someone that is trying to help you by giving a good advise.

This might...

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

But same issue of lack of details. I guess Luis has...

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

But same issue of lack of details. I guess Luis has his mind reading...

erics44 (9/20/2012)

---

you...

Take a look here. It should have everything you are asking about and then some. http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/%5B/url%5D

F8R (9/20/2012)

---

Hi,

I have two Table, Order and OrderDetail

Create Table [Order]

(

Id BigInt Identity(1,1) Primary Key,

OrderTotal Decimal(22,2) Not Null

)

Create Table [OrderDetail]

(

Id BigInt Identity(1,1)...

But same issue of lack of details. I guess Luis has his mind reading cap on today.

This looks a lot like your other question. http://www.sqlservercentral.com/Forums/Topic1361875-391-1.aspx

On neither of these of posts have you provided anywhere near enough detail for anybody to do much but try to decipher...

Take a look here. http://www.connectionstrings.com/%5B/url%5D

This site has connection string details for just about everything.

Simply repeating the question is not helping me understand what you are asking. It seems the English is not your first language, no problem, we can work with that. Can...

ScottPletcher (9/19/2012)

---

Sean Lange (9/19/2012)

---

SQLKnowItAll (9/19/2012)

---

Here's some sample code:

CREATE TABLE #test(id int identity (1,1), filler VARCHAR(1))

GO

INSERT INTO #test(filler)

SELECT 'a'

GO 5

DECLARE @sql VARCHAR(150)

SET @sql = 'BEGIN TRAN SELECT * FROM #test ...

halifaxdal (9/19/2012)

---

Other than waiting and applying...

Boris Pazin (9/19/2012)

---

Hi All,

There is a job which executes each day and copy some records from one table to other.

The query looks something like:

INSERT INTO DestTable

...

SQLKnowItAll (9/19/2012)

---

Here's some sample code:

CREATE TABLE #test(id int identity (1,1), filler VARCHAR(1))

GO

INSERT INTO #test(filler)

SELECT 'a'

GO 5

DECLARE @sql VARCHAR(150)

SET @sql = 'BEGIN TRAN SELECT * FROM #test SELECT * FROM...

Miles Neale (9/19/2012)

---

Hugo Kornelis (9/19/2012)

---

Huh? Why?

SELECT TOP ... without ORDER BY is like saying "give me the first...