What do you mean by "help on...

Joy Smith San (9/12/2012)

---

Experts,

One of the interviewer asked me something like below question. It was not clear to me anyway.

"When we get an SQL query how do we determine if...

sbk2007 (9/12/2012)

---

OfficeId WeekdayId ...

dianne.howard (9/12/2012)

---

I'm new to SQL all together, but I have the following issue I really need help solving;

We have a list of customer transactions that are grouped together by customer....

SQL Mad Rafi (9/12/2012)

---

Surprise! this is my first time i see no one is answering my question.

as i thought may be this could have been answered a lot, even i...

I see that you are pretty new around here. Welcome. In order to provide detailed assistance and code we need to have something to work with. The best way to...

DBA_Learner (9/12/2012)

---

Hello All,

We all know that in SQL Server standard edition we cannot do any auditing on Server and DB Level. So, alternative for...

By now you know that ddl and sample data go a long way towards a viable answer....

Is there a way using this info that I can build a result set...

carlosaamaral (9/11/2012)

---

SELECT table1.column1,

'99',

left(table1.column2, 2),

max(table1.column3),

'Yes',

'Test'

FROM table1

WHERE NOT EXISTS ( SELECT 1

FROM...

vinay.varaala (9/11/2012)

---

my delivery entry screen shows

referenceid deliverydate deliverysttime deliveryendtime

1 2012-09-11 ...

oscarooko (9/11/2012)

---

I am trying to delete old records from a table, and insert them into another table. Problem is that it is taking too long. The table has about...

bslchennai (9/11/2012)

---

Hi,

I am facing one problem with re-index, while doing the re-index on 40gb database one table is taking 40mins, but thing is every day the same table is not...

This is entirely too vague to provide an answer. There are a number of...

Artoo22 (9/11/2012)

---

Note, @@FETCH_STATUS contains one of the following values:

0: The FETCH statement was successful.

-1: The FETCH statement failed or the row was beyond the result set.

-2: The row fetched...

I would start by looking closely at your split function. I am going to take a guess that is either a loop or xml based. Take a look at the...