Julien Vavasseur's user avatar
Julien Vavasseur's user avatar
Julien Vavasseur's user avatar
Julien Vavasseur
  • Member for 7 years, 1 month
  • Last seen this week
  • Paris
25 votes

If positive, sum all items. If negative, return each one

23 votes
Accepted

Alias of COUNT is not being "recognized" by SQL Server

22 votes
Accepted

Was Management Studio removed from SQL Server 2016 installation media?

20 votes
Accepted

How do I count the number of columns in each table?

18 votes

Determine whether mixed mode auth is enabled without logging in?

17 votes
Accepted

Get rows having different values for a column based on the duplicate values of combination of other 3 columns

17 votes
Accepted

Recursive CTE to find Total for all children

17 votes
Accepted

SQL Server restore database with active connections

16 votes

Should the index on an identity column be nonclustered?

16 votes
Accepted

Find all IP's or users who access a specific SQL Server

16 votes
Accepted

select rows having condition met for group (without temporary table)

15 votes
Accepted

Logon Trigger preventing any connection

15 votes

SQL Server passing variable to a string in a stored proc

10 votes
Accepted

Convert int to RGB or hex color

10 votes
Accepted

Extract MIN and MAX values related to datetime values on Postgres 9+

9 votes
Accepted

Adding Where Clause Skews Data

9 votes

Counting rows from a subquery

9 votes
Accepted

Using Echo statement writes Echo is ON in the text file

9 votes

How to get multiple row data into a row with multiple columns

9 votes

Why does my query search datetime not match?

8 votes
Accepted

How to grant connect and read/write permission to ALL databases?

8 votes
Accepted

Is there a way to SELECT n ON (like DISTINCT ON, but more than one of each)

8 votes

How to insert numerous data into temporary table?

7 votes

Find how many SQL Server instances are installed

7 votes
Accepted

Passing comma separated values to parameters in stored procedure

7 votes
Accepted

Insert data from multiple rows into multiple columns

7 votes
Accepted

Datetime as date only

7 votes

How to update only part of a field

6 votes

Conversion failed when converting date and/or time from character string

6 votes

Unable to mirror a database SQL Server 2012

1
2 3 4 5
7