Can you provide the DDL (CREATE TABLE statement) for the target table and a sample of the data you are attempting to import, and what the expected results should be...

Double post, please post replies here.

As Gail indicated, SQL Server will not release memory unless the OS is under memory pressure and forces SQL Server to releasse memory.

As she also said, you may want to...

Not really an error, more of an informational message. I had a SSIS package at a previous employer that returned the same message when opened. The query in...

chetanr.jain (9/8/2010)

---

Hi,

I require a little help on string query.

I have two table ( Table A and Table B) each having employee column with string values.

I want to search that does...

vani_r14 (9/8/2010)

---

[font="Tahoma"]Hi all

I have a table with the some Statistical data... I am working on a SSIS package to extract this and email it out to people...

I am stuck in...

Mariza van Wyk (9/8/2010)

---

Hi,

Why don't you try this instead of using IF @@ROWCOUNT = 0:

IF EXISTS (SELECT *

...

Your INSEERT statement will only run if the @@ROWCOUNT = 0.

Here is the excerpt from your code. If the UPDATE updates any rows, the INSERT won't run:

IF @@ROWCOUNT =...

WayneS (9/8/2010)

---

Steve Jones - Editor (9/8/2010)

---

I think Lutz has some bad karma going. It seems every weird thread I come across with a difficult OP is one in which Lutz...

Brandie Tarvin (9/8/2010)

---

This is my post to whine that none of you have yet answered the post I put in in another forum.

Surely I should have my answer not 5...

With respect, the fact that you say you will run...

First, did...

Mashikoo,

First, please read the article that Lutz has indicated in his signature block (you'll also find it the first article I reference below in my signature block). Following the...

Wanted, one word term for lazy and obnoxious OP.

Received a PM from a newbie (noobie, no posts as of yet) asking for help. Told him to post on appropriate...

WayneS (9/5/2010)

---

Lynn Pettis (9/5/2010)

---

Jeff Moden (9/5/2010)

---

Sooooo... now that we've taught someone how to accomplish SQL Injection, I have to ask... will he use it to avoid injection or carry out...