Sorry, did not have much time to...

It's only slow...

Jez-448386 (5/5/2016)

---

Many of the generic triggers that I have seen, including Pop Rivett's, create an SQL statement for each column in the table so with a wide table of say...

Create a calendar table having a record for each day you company has been or will be filing tax reports.

Not sure if it's good or bad, but there are not...

We might be using different Googles.

Because mine one has very little presence of SharePoint in relation to RBS.

First of all, it tells me that:

"Remote Blob Storage (RBS) is a library...

To avoid problems with temp tables caused by server collation i always script them like this:

CREATE TABLE #tbl(

col1 varchar(10) COLLATE DATABASE_DEFAULT

);

Not quite...

I think you're overcomplicating the matter.

There must be already some software which creates and/or saves the sound files in the file storage.

Without it there would not be .wav files.

So, your...

Start studying latest advances in hardware.

They usually do not admit wrong decisions easily, so...

Studio has an XML Parser built in it.

This module is responsible for reading, validating and formatting XML strings when you open it for viewing.

It's a front-end application, not any part...

Are you sure the XML's stored in the table contain line breaks?

shivang.rdesai (5/3/2016)

---

SELECT SalesOrderNumber, sum([Nett])

FROM (([FactSales]

inner join [Date]

on [FactSales].DateKey = [Date].DateKey)

inner join [Product] on [Sales].ProductKey = [Product].ProductKey

inner join [ProductCategory] on [Product].ProductCategoryKey = [ProductCategory].ProductCategoryKey)

inner join [Store] on [Sales].StoreKey = [Store].StoreKey)

where FullDate =...

SELECT date, YEAR(DATEADD(mm, 4, c.Date))%100 FY

FROM dbo.calendar c

WHERE YEAR(DATEADD(mm, 4, c.Date))%100 = 17

Strongly disagree! 🙂

Unless your meaning of "code" includes...

DECLARE @HistoryDate DATETIME

SET @HistoryDate = dateadd(hour,-5, DATEADD(dd, 0, DATEDIFF(dd, 0, getdate() )) )