microsoft.public.sqlserver.programming

1–30 of 181738

0 selected

Ammammata, Erland Sommarskog6

Apr 6

[SAP B1] create a VIEW with UNION and WHILE

Il giorno Tue 06 Apr 2021 05:22:57p, *Ammammata* ha inviato su microsoft.public.sqlserver.programming

unread,

[SAP B1] create a VIEW with UNION and WHILE

Il giorno Tue 06 Apr 2021 05:22:57p, *Ammammata* ha inviato su microsoft.public.sqlserver.programming

Apr 6

Bimith Kunhiraman, Erland Sommarskog2

10/8/20

Bimith Kunhiraman (bimithgmc@gmail.com) writes: > using with cte , i need to skip row when the

unread,

Bimith Kunhiraman (bimithgmc@gmail.com) writes: > using with cte , i need to skip row when the

10/8/20

Robert Tuck, … Michael Cole5

8/31/20

BCP or Bulk Insert file containing quoted strings, embedded delimiters

Code The Crab presented the following explanation : > On Thursday, 11 December 2003 at 01:57:00

unread,

BCP or Bulk Insert file containing quoted strings, embedded delimiters

Code The Crab presented the following explanation : > On Thursday, 11 December 2003 at 01:57:00

8/31/20

sstia...@gmail.com, Erland Sommarskog2

4/22/20

SQL job never ending

(sstiakakis@gmail.com) writes: > It looks like it has to do with the change in step 9. However, by

unread,

SQL job never ending

(sstiakakis@gmail.com) writes: > It looks like it has to do with the change in step 9. However, by

4/22/20

disc...@iphone.bell.com

4/19/20

iPhone SUPER 80% discounts

*** iPhone SUPER-SPECIAL-DISCOUNT 80% OFF --- UNBEATABLE SUPER-PRICES !!! *** Save LOTS OF CASH on a

unread,

iPhone SUPER 80% discounts

*** iPhone SUPER-SPECIAL-DISCOUNT 80% OFF --- UNBEATABLE SUPER-PRICES !!! *** Save LOTS OF CASH on a

4/19/20

kill...@coronavirus.com

4/18/20

coronavirus COVID-19

coronavirus COVID-19 http://www.grex.org/~henced/coronavirus.html

unread,

coronavirus COVID-19

coronavirus COVID-19 http://www.grex.org/~henced/coronavirus.html

4/18/20

John Hall, Erland Sommarskog14

4/16/20

How do I order the columns on a pivot table?

John Hall (foundarecord@gmail.com) writes: > It was strange. I replaced the TestID with

unread,

How do I order the columns on a pivot table?

John Hall (foundarecord@gmail.com) writes: > It was strange. I replaced the TestID with

4/16/20

Erland Sommarskog

4/12/20

Re: Ordering the columns in a pivot table

SELECT PE.TestID, MIN(CASE PU.PresentOrder WHEN 1 THEN PE.TextValue END) AS Param1, MIN(CASE PU.

unread,

Re: Ordering the columns in a pivot table

SELECT PE.TestID, MIN(CASE PU.PresentOrder WHEN 1 THEN PE.TextValue END) AS Param1, MIN(CASE PU.

4/12/20

Michael Cole, Erland Sommarskog2

6/25/19

Indexing for View Containing UNION

Michael Cole (micheal.cole@invalid.com) writes: > The intent is "C" is not an actual

unread,

Indexing for View Containing UNION

Michael Cole (micheal.cole@invalid.com) writes: > The intent is "C" is not an actual

6/25/19

Michael Cole, Erland Sommarskog2

2/5/19

Storage of "Do Not Show This Again" Flags

Michael Cole (invalid@invalid.com) writes: > For our application, we now want to introduce the

unread,

Storage of "Do Not Show This Again" Flags

Michael Cole (invalid@invalid.com) writes: > For our application, we now want to introduce the

2/5/19

1/13/19

Us congress hearing of maan alsaan Money laundry قضية الكونغجرس لغسيل الأموال للمليادير معن الصانع

YouTube videos of US Congress money laundering hearing of Saudi Billionaire " Maan Al sanea

unread,

Us congress hearing of maan alsaan Money laundry قضية الكونغجرس لغسيل الأموال للمليادير معن الصانع

YouTube videos of US Congress money laundering hearing of Saudi Billionaire " Maan Al sanea

1/13/19

Andy Dufresne, Erland Sommarskog2

1/10/19

Converting NTEXT to NVARCHAR(MAX) in a MSSQL 2016 database

Andy Dufresne (andyza@webmail.co.za) writes: > That seems to have worked fine on all the tables.

unread,

Converting NTEXT to NVARCHAR(MAX) in a MSSQL 2016 database

Andy Dufresne (andyza@webmail.co.za) writes: > That seems to have worked fine on all the tables.

1/10/19

asoluti...@gmail.com, labinot...@gmail.com2

9/27/18

A First Course in Differential Equations with modeling applications , By Dennis G. Zill , 9th zill

On Wednesday, August 22, 2018 at 3:34:56 PM UTC+2, asoluti...@gmail.com wrote: > solutions books

unread,

A First Course in Differential Equations with modeling applications , By Dennis G. Zill , 9th zill

On Wednesday, August 22, 2018 at 3:34:56 PM UTC+2, asoluti...@gmail.com wrote: > solutions books

9/27/18

solutions....@gmail.com

8/22/18

Vector Mechanics for Engineers STATICS , By Beer & Johnston , 10th ed

solutions.for.student@hotmail.com solutions . for . student @ hotmail . com solutions(dot)for(dot)

unread,

Vector Mechanics for Engineers STATICS , By Beer & Johnston , 10th ed

solutions.for.student@hotmail.com solutions . for . student @ hotmail . com solutions(dot)for(dot)

8/22/18

solutions....@gmail.com

6/26/18

solutions manual & e-books

solutions.for.student@hotmail.com solutions . for . student @ hotmail . com solutions(dot)for(dot)

unread,

solutions manual & e-books

solutions.for.student@hotmail.com solutions . for . student @ hotmail . com solutions(dot)for(dot)

6/26/18

Mike Arney, Erland Sommarskog11

5/9/18

How to add a datetime column for a 24 hour period

Mike Arney (mikespcnet.net@gmail.com) writes: > I found a temporary solution, in my program, that

unread,

How to add a datetime column for a 24 hour period

Mike Arney (mikespcnet.net@gmail.com) writes: > I found a temporary solution, in my program, that

5/9/18

Ma...@getfucked.com

11/10/17

Uploads - What is wrong with Easynews

Looking for Star Trek Discovery season 1 Episodes 6 onwards in english. Why does it seem there are no

unread,

Uploads - What is wrong with Easynews

Looking for Star Trek Discovery season 1 Episodes 6 onwards in english. Why does it seem there are no

11/10/17

10/25/17

Cause of "The referenced entity ‘tablename’ was modified during DDL execution" (error 2021)?

Folks: Our application has a helper SP that creates lightly-customized work SPs from a generic SP

unread,

Cause of "The referenced entity ‘tablename’ was modified during DDL execution" (error 2021)?

Folks: Our application has a helper SP that creates lightly-customized work SPs from a generic SP

10/25/17

neox, … buddy_...@yahoo.com4

10/25/17

freelance asp.net / php / sharepoint developer

Yes I am looking for work. Let me know if you still have this position open ?? Regards Leo

unread,

freelance asp.net / php / sharepoint developer

Yes I am looking for work. Let me know if you still have this position open ?? Regards Leo

10/25/17

csvand...@gmail.com, Erland Sommarskog3

8/4/17

update a sum between two tables in ado vb6

(csvanderwerf@gmail.com) writes: > I am building an account-program, for that: > > I want to

unread,

update a sum between two tables in ado vb6

(csvanderwerf@gmail.com) writes: > I am building an account-program, for that: > > I want to

8/4/17

lach...@gmail.com, Erland Sommarskog7

5/24/17

logging stored procedure fails when inserting via linked server

> Because i have parameterized both the linked server name and the > database it is in is not

unread,

logging stored procedure fails when inserting via linked server

> Because i have parameterized both the linked server name and the > database it is in is not

5/24/17

eighthman11, … Erland Sommarskog12

4/29/17

Bulk Insert Erratic insert order. Any Help Greatly Appreciated.

(deanseawa@gmail.com) writes: > As long as your file is a text file, with each row terminated with

unread,

Bulk Insert Erratic insert order. Any Help Greatly Appreciated.

(deanseawa@gmail.com) writes: > As long as your file is a text file, with each row terminated with

4/29/17

Mary Phelps, … maize...@gmail.com3

12/23/16

Select last column amongst group of columns where value>0

On Thursday, December 1, 2016 at 12:21:44 PM UTC-4, Mary Phelps wrote: > Here is data in my table

unread,

Select last column amongst group of columns where value>0

On Thursday, December 1, 2016 at 12:21:44 PM UTC-4, Mary Phelps wrote: > Here is data in my table

12/23/16

12/16/16

SSRS Tutorial for free @mindmajix

SSRS TUTORIAL This tutorial gives you an overview and talks about the fundamentals of SSRS. WHAT IS

unread,

SSRS Tutorial for free @mindmajix

SSRS TUTORIAL This tutorial gives you an overview and talks about the fundamentals of SSRS. WHAT IS

12/16/16

bharat...@gmail.com, paulh...@gmail.com2

11/8/16

Automation Testing of Stored Procedures in SQL Server

On Monday, November 7, 2016 at 1:35:07 PM UTC, bharat...@gmail.com wrote: > Hi, I am a newbie in

unread,

Automation Testing of Stored Procedures in SQL Server

On Monday, November 7, 2016 at 1:35:07 PM UTC, bharat...@gmail.com wrote: > Hi, I am a newbie in

11/8/16

fniles, … 007kpc...@gmail.com28

10/21/16

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

On Monday, January 24, 2011 at 8:43:12 AM UTC-6, fniles wrote: > Also, around the same time our

unread,

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

On Monday, January 24, 2011 at 8:43:12 AM UTC-6, fniles wrote: > Also, around the same time our

10/21/16

Frans, … Michael Cole9

10/13/16

Create function: Could not find type xxx in assembly yyyy (msg 650

Erland Sommarskog pretended : > Michael Cole (invalid@invalid.com) writes: >> swetha.

unread,

Create function: Could not find type xxx in assembly yyyy (msg 650

Erland Sommarskog pretended : > Michael Cole (invalid@invalid.com) writes: >> swetha.

10/13/16

vasuin...@gmail.com

9/12/16

Big data Tutorials

What is big data? It's a phrase used to put into numbers data sets that are so large and complex

unread,

Big data Tutorials

What is big data? It's a phrase used to put into numbers data sets that are so large and complex

9/12/16

bingo...@gmail.com, Erland Sommarskog2

7/18/16

Need SQL script for: Rolling Total By Year and Month

(bingopinath@gmail.com) writes: > Using version: SQL Server 2008 R2 > > I have data as seen

unread,

Need SQL script for: Rolling Total By Year and Month

(bingopinath@gmail.com) writes: > Using version: SQL Server 2008 R2 > > I have data as seen

7/18/16

Nicholas Randall Forystek

7/12/16

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

unread,

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

7/12/16

Search

Clear search

Close search

Google apps

Main menu