ibrahim_sh_87 (3/25/2009)

---

hey all

i am trying to query from a stored Procedure found from a remote server...and join the results with data found on a table another database.... my sql statment...

Catcha (3/24/2009)

---

Hi All,

Is there any tricks to improve this query not like query, like this?

where deal_no not like 'IMGATD%'

I tried using

left (deal_no,6) <> 'IMGATD'

but the...

Problem with your path provided in Backup statement. for more info see SQL BOL.

Possible, post the script.

Many ways to delete the duplicate records, for more information navigate the following URL's:

http://www.sqlservercentral.com/articles/Advanced+Querying/deletingduplicaterecords/1630/ --> with cursors

http://www.sqlservercentral.com/scripts/TSQL/62866/

http://www.sqlservercentral.com/scripts/Miscellaneous/65420/

http://www.sqlservercentral.com/scripts/duplicate+records/65099/

http://www.sqlservercentral.com/search/?cx=000517265726492607871%3Agqdiynsp-y0&cof=FORID%3A9&q=delete+duplicate+records+in+sql+server&sa=Go#1173

in SQL 2005, one string function exists is "DIFFERENCE",...

Simon Smith (2/9/2009)

---

Good point ! I am running the query via a linked server. Have tried several times but to no avail 🙁

Will have a look at the link as...

Simon Smith (2/9/2009)

---

I have two SQL servers.

One is a 64 bit SQL 2005 server - SP2.

The other is a 32 bit SQL 2000 server - SP4.

I need to run a...

if you have any log file backup, then you can restore the data from log file.

regards.

Hemalatha (2/9/2009)

---

Thanks for the reply Kishore.

i am using sql server 2005. I have not given any rollback or commit Neither do I have any triggers.

Just deleted some 100 records by...

* if you use, begin trans, then you can rollback the operation.

* if you have any delete trigger on that table, then you can get the data.

which version of SQL...

If your operation system is WinXP then, first install SP3 and install...

rembersu (12/22/2008)

---

Hi All,

Can you please advise How to Import Text file with Caret '^' delimiter data format. The import/export wizard does not show the Caret delimiter option.

Thanks in...

try like:

sqlcmd -E -Q "exec xp_readerrorlog 1" -o "C:\out.txt"

it works fine.

prakashdotc (12/22/2008)

---

The Problem is not retreving records in this format, but the Column Header must be Dynamic Date

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

ProductId - Date 1 - Date 2 - Date 3 - Date 4...

700,000 records is not big size in table.

run the following DBCC commands:

> DBCC CHECKTABLE.

> DBCC UPDATEUSAGE ( ), if it is not a production...