SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Row number not exactly working

  Using row number function with partitioning, I do not get the desired result. Attached image shows …

  Bhagat

  3 replies

  6 years, 7 months ago

  By: drew.allen

• Group by on 120 pivotted columns

  Hi, I have the next case with a challenge on grouping records on 120 pivotted columns. Objectnames …

  michielbijnen

  3 replies

  6 years, 8 months ago

  By: Jeff Moden

• DATEADD(DAY, -30, GETDATE())

  Dear Everyone I wanted to know the statement below will it delete everything in the last 30 days or…

  hurricaneDBA

  5 replies

  6 years, 8 months ago

  By: as_1234

• SSIS and flat file column headings with special characters in them

  Thanks in advance for any help! I have a csv file that has a header row in which the header column …

  dbodell

  4 replies

  6 years, 8 months ago

  By: Jeffrey Williams

• update table all 0 values to null single query

  Hi Team, please help on this below update query. My data looks like: create table #a(a int,b int,c …

  kbhanu15

  4 replies

  6 years, 8 months ago

  By: jcelko212 32090

• XML file

  Hello This topic was modified 6 years, 8 months ago by SqlServerLover. This topic was…

  SqlServerLover

  3 replies

  6 years, 8 months ago

  By: SqlServerLover

• Group by and a list.

  Suppose I want to do a count, grouped by an article and some columns I do not want to group on but …

  ben.brugman

  7 replies

  6 years, 8 months ago

  By: ben.brugman

• Macro in SSIS, pops up for user name password

  Hi Guys, I am running a Macro file in SSIS VB script task. My macro pulls data from a https url and…

  SqlServerLover

  2 replies

  6 years, 8 months ago

  By: SqlServerLover

• How to group by the first column and limit its results?

  Hi Everyone I made a query to display the following:   IDENTITY        NAME                   …

  hurricaneDBA

  14 replies

  6 years, 8 months ago

  By: hurricaneDBA

• trying to get all data to line up

  Hello, first, thank you all who helped or took the time to look at my last issue, but now i got 1 m…

  Siten0308

  2 replies

  6 years, 8 months ago

  By: Steve Jones - SSC Editor

• Purging Old data - what would you monitor to demonstrate success?

  Executive summary: What SQL statistics would you be gathering now to demonstrate the overall improv…

  rtrim(ltrim(' '))

  2 replies

  6 years, 8 months ago

  By: Ken McKelvey

• Get the correct order of the results.

  Hi Team, my data looks like below. please help to get the correct data. create table #Year ( Year V…

  kbhanu15

  6 replies

  6 years, 8 months ago

  By: ScottPletcher

• 1 table but many different counts on 1 line

  Hello, trying to think what is the best way to tackle this... i have 1 table, and the requirements …

  Siten0308

  4 replies

  6 years, 8 months ago

  By: Siten0308

• week startdate and enddate

  hi, looking for script to populate all the weeks in current   year  like below. Any suggestions ple…

  adisql

  7 replies

  6 years, 8 months ago

  By: Jeff Moden

• Create GEOJSON with TSQL

  I'm trying to create an export file in GeoJson, but I'm having a hard time reading and creating a f…

  delizat4g

  1 replies

  6 years, 8 months ago

  By: delizat4g