There seems to be something fundamentally poorly designed given all the challenges you are facing here. You...

DBA_Learner (9/12/2012)

---

Ya, I am not implementing any spcific logic..here is the way i am doing..

CREATE TABLE LOG_TABLE (Add_dttm datetime DEFAULT (GetDate()), TABLE_NAME sysname, Activity char(6),login_sname sysname DEFAULT SUSER_SNAME())

GO

DECLARE @sql varchar(8000),...

The best place to find approved study materials is from Microsoft. The exam page is here. http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-451&locale=en-us#tab3

They list some resources but not a lot for direct prep materials for this...

First of all you only posted 1 table (Content). What about ContentVersion, ContentFormat, License, Website?

Your where clause is absolutely insane. Holy Cast insanity batman!!!!

(N'STRY' IS NULL) OR...

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...