Henrico Bekker (9/6/2012)

---

yes, but define "Database Testing" what testing will be done/required? or are you 4-5 developers? Or...

Sql database Testing team consisting 4-5 people.

If you have only these two fix scenario.Then you can...

avesh_h (9/4/2012)

---

Hello,

i am generating a matrix report using Visual studio 2005. The report as data contains project names on a daily basis assigned to resources. I want to display...

SQLSACT (9/4/2012)

---

Hi All

I am very new to SSIS and dealing with packages

Please help me with something.

When a package is created, is it always created in BIDS?

When you save the...

Will send you the invitation on the same.However I am not frequently using it.

Also please avoid to put your personal detail(email id) on...

venki.msg (9/3/2012)

---

Hi all i need to do increment a number like aa001 to aa999 then again ab001 to ab999

aa001a0 to aa999a0 then aa001b0 to aa999b0.

Can any one help me out...

sathiyan00 (9/3/2012)

---

Hi all,

I'm new to sql server,so please help me to know about this.

1) whether the ssis package will process 1 row at a time or whole...

li_ning123 (9/3/2012)

---

Jeff Moden (9/3/2012)

---

Be careful now... That uses a "counting Recursive CTE" and they're notorious for bad performance. Please see the following article for why you shouldn't use...

richesflow (9/3/2012)

---

SELECT FirstName + '' + LastName AS 'Employee Name'

FROM dbo.Employees

ORDER BY STR (LEN(FirstName + '' + LastName))

+ STR (CHARIDEX('a', @Location;)+ RIGHT('SUBSTRING', 5);

I keep getting and error...

thomasrichardson2000 (9/3/2012)

---

Thanks so far, I will clarify further. The requirement is that i update the version field with the letters 'BT' at the end, So if the column is defined...

thomasrichardson2000 (9/3/2012)

---

Basically what I am trying to achieve is to update the last two character spaces of a column which is defined as varchar(40),

my update statement looks like this

UPDATE Vehicle...

Krissh_pallu (9/3/2012)

---

I am using a cursor inside my store procedure. This store procedure is performing some opertaions on thousands of records..

I am executing this stored procudure manually..

My question:

If i...

marygrace_laurente23 (9/2/2012)

---

Hi Everyone,

Just want to ask if anyone have "script" or jobs that will automatically check database blocking. I want to automate this kind of scenario and also create an...

Over !!!