Looks like BOL has an error:

😎

OVER ( [ partition_by_clause ] order_by_clause)

partition_by_clause divides the result set produced by the FROM clause into partitions to which the...

Quick question, have you tried to run the packages with the dtexec Utility?

😎

I suspect that this may be a quirk in the Visual Studio interface, certainly you don't intend to...

ROFL, can I call you...

Surely you meant "Not posh enough":-D

😎

normally do these things on linux using sqsh[/url].

Hi and welcome to the forum.

Just a quick question, can you elaborate a little further on your request, i.e. describing the input and the results, how you are going to...

Hi Luis,

thank you for the feedback, happy to be of assistance

😎

Quick thought, create the user login and grant the appropriate permissions

😎

SQLJocky (4/25/2015)

---

Just uninstalled SQL 2012 Standard and reinstalled SQL 2012 Developer on a server that we have taken from production to development. But when I reinstalled and moved all...

doug-583247 (4/26/2015)

---

Thanks for the suggestion Eirikur, but that still produces a syntax error as shown below. I then removed the semicolon and then the syntax error moved the "...

Quick suggestion

😎

Create Trigger trgInsertSalesForce

on dbo.CustomerQuote

AFTER Insert

as

begin

Update CQ

set CQ.SalesForceId = (select

...

Quick suggestion, check the articles on this page Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5[/url]

😎

Quick suggestion, use CROSS JOIN, here is a quick example

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_GROUP') IS NOT NULL DROP TABLE dbo.TBL_GROUP;

CREATE TABLE dbo.TBL_GROUP

(

[Group] ...

Jeff Moden (4/24/2015)

---

To be honest, the front end is storing the data incorrectly. The data should be sorted with just one IP address per row and, once the table...

The problem here is that the inserts are not in an ever increasing order, possible option would be adding an Identity column for the primary key and then a unique...

This is a very efficient method when aggregating with different grouping / level of details, comes close to the divide and...