You could (protect your identity by 😉

1. Script the database

2. Run the create table part only at the destination

3. Use Import wizard to transfer the data, enable identity insert...

My 2 cent;

An apostrophe is a valid character in a surname so that should be catered for.

Hi,

You can use the ROW_NUMBER function to produce the desired results.

Is this what you are looking for?

SELECT

A.[CHAIN VALUES]

,A.TIPE

,A.CORR

,A.OPERATION_ID

,A.[DUE DATE 1]

,A.[DUE DATE 2]

FROM (

SELECT

ROW_NUMBER() OVER

(PARTITION BY...

The N denotes the N(VAR)CHAR type, without it the N it would be (VAR)Char.

😎

Making way for the new CONCAT function in...

This query uses the LAG function;

select t1.ClientID, t1.Rn, t1.EndMonth

,t1.OrderAmt

,LAG(t1.OrderAmt,1,0) OVER

(

PARTITION BY ClientID

ORDER BY EndMonth ASC

) AS ...

Not to mention all the fish 😀

Can you provide any DDL?

Look into STPointN and other Geography/Geometry functions.

Very interesting, wouldn't jump to any conclusions yet, what are the server specs? Disk and mem I/O?

Using Bob's DDL, here's a Window function version

CREATE TABLE #tmp(id int,

dt date);

INSERT INTO #tmp

VALUES(53,'2014-01-01'),...

Jonathan Marshall (3/24/2014)

---

Hey guys,

Looking to pass in the @targetDbName into the Open Query.

The target DB is PostGres and requires 2 single quotes around the dataset name.

Is this...

Thanks Dwain :Wow:

this time the answer is 44 😎

Simple as

select char(39) + column + char(39)

Jeff Moden (3/24/2014)

---

Eirikur asked me to review it (seems like a couple/three months ago) and I'm tickled...