say for example , I have to delete space from the below string.

select 'karthik keyan 44768 sql server 2008'

which number i have to use? how many REPLACE i have to...

Interesting image that conjures up. I didn't take in the rest of your post. :w00t:

SomewhereSomehow (9/24/2012)

---

Also found this one:

SSMS Tools Pack add-in

As it's said on the utility page:

Query Execution History logs every SQL statement that you run in a file on your disk or...

Jason-299789 (9/24/2012)

---

Phil,

what about using the Results to File option in SSMS, its a bit cumbersome but should will allow the results to be stored.

Also switch on "Include the...

I'm pretty sure that my unicorn will run faster than your apple:-D

JanTimmermans (9/21/2012)

---

Hi, did you solve it, because I have the same issue.

I also use a cursor, but that has to stay in the procedure.

When running it from SSMS, it flies,...

Grouping...

I feel like I have entered a parallel universe.:alien:

venus.pvr (9/19/2012)

---

I have a parent package(Pkg1) which executes Pkg2 thrice in parallel. And Pkg2 executes Pkg3 thrice in parallel. These packages have variables(with same names between childs and parent) passed...

Eugene Elutin (9/19/2012)

---

Yes it is possible, but what it will give you?

SELECT Col1, Count_Rec

FROM (SELECT Col1, Col2, Count(*) AS Count_Rec

...

One thing which I have noticed with MERGE is that it does not natively provide separate Updated/Inserted/Deleted counts.

You need to code an OUTPUT clause and use $Action to get these....

No. If...

Is that because words are too...

keka4747 (9/19/2012)

---

Hello Gurus,

Im new to SSIS . Need your help to resolve a performance issue.

I have a dimension table with 120 columns in which 80 columns change frequently and...

I second all of Sean's comments.

In addition, I note that you are referencing a column in your example which does not even exist in the table (ri_user_name).

I suggest that you...