Viewing 15 posts - 10,756 through 10,770 (of 15,381 total)
ramadesai108 (9/12/2012)
The site is used by over 100,000 users. Version of Excel cannot change.
There seems to be something fundamentally poorly designed given all the challenges you are facing here. You...
September 12, 2012 at 1:47 pm
DBA_Learner (9/12/2012)
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),...
September 12, 2012 at 12:53 pm
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...
September 12, 2012 at 10:55 am
yb751 (9/12/2012)
Attached requested files...
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...
September 12, 2012 at 10:25 am
robert.hemley (9/12/2012)
Thank you again, I know this is a SQL forum but can you help on referencing to c# i am using asp.net.Regards Rob
What do you mean by "help on...
September 12, 2012 at 10:08 am
Joy Smith San (9/12/2012)
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...
September 12, 2012 at 10:05 am
sbk2007 (9/12/2012)
September 12, 2012 at 9:57 am
dianne.howard (9/12/2012)
We have a list of customer transactions that are grouped together by customer....
September 12, 2012 at 9:24 am
SQL Mad Rafi (9/12/2012)
as i thought may be this could have been answered a lot, even i...
September 12, 2012 at 9:17 am
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...
September 12, 2012 at 9:07 am
DBA_Learner (9/12/2012)
We all know that in SQL Server standard edition we cannot do any auditing on Server and DB Level. So, alternative for...
September 12, 2012 at 8:49 am
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...
September 11, 2012 at 3:05 pm
carlosaamaral (9/11/2012)
'99',
left(table1.column2, 2),
max(table1.column3),
'Yes',
'Test'
FROM table1
WHERE NOT EXISTS ( SELECT 1
FROM...
September 11, 2012 at 2:57 pm
vinay.varaala (9/11/2012)
my delivery entry screen shows
referenceid deliverydate deliverysttime deliveryendtime
1 2012-09-11 ...
September 11, 2012 at 10:02 am
oscarooko (9/11/2012)
September 11, 2012 at 8:53 am
Viewing 15 posts - 10,756 through 10,770 (of 15,381 total)