ravi@sql (4/29/2014)

---

Hi All ,

Am trying to open ssis packge but it is giving error saying

"There were errors while the pacakge was being loaded . The pacakge might be corrupt...

Diffraction (light)

ganteng1 (4/23/2014)

---

Hi,

I tried the following, but it still didn't work when trying to return a date as DD-MM-YYYY. Please see the expression below:

(DT_DBDATE)(DT_WSTR,2)(SUBSTRING(DATE,1,2) + "-" + (DT_WSTR,2)SUBSTRING(DATE,4,2) + "-" +...

RantaSanta (4/21/2014)

---

I want to capture and manipulate any SCRIPT which runs "DROP PROC" in my SQL server .

To explain further , How I can capture the PROC in...

gurbanov.1984 (4/21/2014)

---

hi guys

my sql code so

delete from numbers

declare @i as int

set @i = 3440000

while(@i < 3442047)

begin

insert into...

Concept

It is nice you got your solution.Actually it is very generic query to...

Out of curiosity i want to ask you that where did you get this problem 🙂

However as dwain mentioned it is not going to be easy one....

Hey Prasanna,

It would be also useful to provide table DDL and sample DML to get your answer quickly.If you don't mind, please post it.

Can you please explain more about your requirement as I could not understand the resultset you want ?

Can you please post your query, you have tried so far. may be...

hey,this is not done. I got only +1 😛

I got 4/5 right.Bur for getting the 5th one needs to change the default settings which could have mentioned in the question.

Steve - I want +1 for it 😉

as...

jasona.work (10/8/2012)

---

Cliff Jones (10/8/2012)

---

JAZZ Master (10/8/2012)

---

Daniel Bowlin (10/8/2012)

---

Stuart Davies (10/8/2012)

---

rhythmk (10/7/2012)

---

True Beauty("www.youtube.com/watch?v=7781W7cjupE

")...

mubarak.a (10/8/2012)

---

Hi,

I'm new in SQL Server, i want the working process of STUFF & ISNULL. How it works & how it concatenate the row level data into a single data?...

True Beauty("www.youtube.com/watch?v=7781W7cjupE

") Poetry by Thomas Carew