SELECT Prod.EnglishProductName, DATEPART(yyyy, FIS_Part.OrderDate), DATEPART(month, FIS_Part.OrderDate), SUM(UnitPrice*OrderQuantity)

FROM FactInternetSales_Part FIS_Part JOIN DimProduct Prod

ON Prod.ProductKey = FIS_Part.ProductKey

WHERE DATEPART(yyyy, FIS_Part.DueDate)=2005 AND DATEPART(month, FIS_Part.DueDate)=7 AND DATEPART(dd, FIS_Part.DueDate)=13

GROUP BY Prod.EnglishProductName, DATEPART(yyyy, FIS_Part.OrderDate), DATEPART(month, FIS_Part.OrderDate)

ORDER BY...

CREATE DATABASE practise

USE practise;

CREATE TABLE xTable (xCol xml);

GO

DECLARE @xml nvarchar(max)='

<Root>

<SQLLEVEL>

MCM

</SQLLEVEL>

</Root>

'

INSERT INTO xTable (xCol) VALUES(@xml)

with reference to http://technet.microsoft.com/en-us/library/ms191184.aspx

E. Bulk exporting XML data

My purpose is to export the data

bcp syntax...

sorry should be

SELECT ISNULL(NULL,1)

1

Why 1 look like the function's name is very misleading....thanks

SELECT name, type, schema_id FROM sys.all_objects where name = 'xml_schema_namespace'

return me an empty set.

from http://technet.microsoft.com/en-us/library/ms190316.aspx

I have placed a carriage returned at the end of both file text1.txt file and values.fmt

and I encounter the following err

Msg 4832, Level 16, State 1, Line 1

Bulk load: An...

after changing security to sql server and windows authentication and restarting the server,

I was able to login using either sa or schemauser.

thanks

Are you able to login with the credentials using Manamgement Studio?

Yes I'm able to login to Manamgement Studio using windows authentication as an admin

But I'm not able to login as...

if that being the case,

for clustering, if one VM required 4G and since in previous post by jasona.work that I need to set up 4VM,

wouldn't that mean 4*4G, i.e. 16G...

Hi from

http://technet.microsoft.com/en-us/library/ms143506(v=sql.100).aspx

would allocating 1GB for each machine enough?

thanks

what should be the virtualization technology use? VMWare? Must I use microsoft virtualization software?

also I need to purchase 4 OS licenses for learning this technology? Should I buy client or...