Interesting 🙂

KumarSQLDBA (9/14/2012)

---

Hi Guys,

I am getting below error.

Error77System.UnauthorizedAccessException: Access to the path 'E:\Backup_data\lity_dump\Automation_script\lity\lity\bin\Package.dtsx' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.SetAttributes(String path,...

gorenak (9/14/2012)

---

Hi sorry for question, but I didn`t find answer.

can i do something like;

declare @i int

cursor

begin

select [ @i] from table -- or some other name...

Again I would...

hoseam (9/14/2012)

---

Hi

I have this code below and I need calculate the last Amount, which has to be the lowest value between [Original_Investment_Value] and (Encashment_Value + [Top-Up_Commission]), I need to return...

Shadab Shah (9/13/2012)

---

Thanks Subbareddy for the solution. But i am trying to learn SQL Server. So...

But do you think that dropping the index will save your time ?

Because as you mentioned that the table...

venkatesh.b 88975 (9/13/2012)

---

Dear all,

I had a requirement like, I have...

Reservation 🙁

Anju Renjith (9/12/2012)

---

Step:1

CREATE TABLE tbl_Group_Test

(

_ID INT IDENTITY,

_Place VARCHAR(50),

_Name VARCHAR(100)

)

Step:2

INSERT INTO tbl_Group_Test VALUES('Tamil Nadu','Abdul Kalam')

INSERT INTO tbl_Group_Test VALUES('Tamil Nadu','Karunanidhi')

INSERT INTO tbl_Group_Test VALUES('Tamil Nadu','Jayalalitha')

INSERT INTO tbl_Group_Test VALUES('Tamil Nadu','Robin Singh')

INSERT INTO tbl_Group_Test...

danielfountain (9/12/2012)

---

Hey all,

When you import data from SSIS - how does it work with the row order?

Does the row order stay the same in the excel file as it would...

suvo.kundu (9/10/2012)

---

I am getting the out put of a query as

SN NodeName NodeValue

1...

Thanks to all for your valuable inputs 🙂

opc.three (9/6/2012)

---

Wow, tough assignment. Are your team members skilled as developers? i.e. will they be writing unit tests to exercise code other developers have written? What kind of tools will...

vivekkam (9/5/2012)

---

I have two identical queries with only one filter difference between the two queries. Can anybody suggest me a solution using "case" statement as how I can reduce the...