SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• How to use replace function

  I have an ID column data that is having space at the last, and i am comparing this column data with…

  mcfarlandparkway

  3 replies

  5 years, 10 months ago

  By: ScottPletcher

• COUNT DATE

  I need some help counting a date field. I tried the examples below and no luck COUNT(CAST(CONVERT(C…

  TJ_T

  4 replies

  5 years, 10 months ago

  By: John Mitchell-245523

• Transaction handling in sql server

  Hi All, Have some questions related to transaction management in sql server. 1. What is the differe…

  vsamantha35

  8 replies

  5 years, 10 months ago

  By: ScottPletcher

• how to merge 3 different temp tables data into one

  Is there any better way to do this?   create table #student (StudentName varchar(20) null, Std…

  mcfarlandparkway

  6 replies

  5 years, 10 months ago

  By: Phil Parkin

• SQL Query with CTE or other...!

  Any one can help me please with this issue? I really appreciate this help. The number of Answer is …

  carloscris

  7 replies

  5 years, 10 months ago

  By: Steven Bates

• Table with all computed columns -vs- View (Pros-Cons)

  I plan to do some testing on this (if I can find the time) but thought I would post the question to…

  Budd

  6 replies

  5 years, 10 months ago

  By: MVDBA (Mike Vessey)

• query plan related questions

  Hi All, I have few questions on query plans. 1. Wanted to check for how long a query plan will stay…

  vsamantha35

  2 replies

  5 years, 10 months ago

  By: vsamantha35

• MIN is not giving me the lowest value

  How do I pull the employee with the lowest person_id along with their first name? I have a "person …

  wallywizard

  9 replies

  5 years, 10 months ago

  By: ktflash

• Extract rows from a table/CTE when a column matches

  HI All I have been struggling with what seems to be a fairly simple piece of t-sql code. I have a C…

  pnr8uk

  4 replies

  5 years, 10 months ago

  By: The Dixie Flatline

• Jr vs Sr Developer

  Whats diff of job tasks between junior developer and senior sql developer u all would say? Thanks

  CoolKid40

  4 replies

  5 years, 10 months ago

  By: Jeff Moden

• Non-technical question

  Hi All, This is a non-technical question and want to know your sincere opinions on this. In our org…

  vsamantha35

  11 replies

  5 years, 10 months ago

  By: vsamantha35

• SQL Data file issue

  Hi All , I have a problem with big database that occupies some space in a drive , This drive is run…

  WhiteLotus

  5 replies

  5 years, 10 months ago

  By: WhiteLotus

• ETL for 4 Databases into a Single Distributed database

  So, I have a massive undertaking, at least I believe it will be. I’ve asked a similar question in a…

  SQLDude

  5 replies

  5 years, 10 months ago

  By: Jeff Moden

• Report every week, beginning 1st of month and ending last day of month

  Hello! I need to run weekly report for each month on Friday, beginning the first day of each month,…

  PJ_SQL

  5 replies

  5 years, 10 months ago

  By: MVDBA (Mike Vessey)

• How to get previous value(last matched records results) in SQL query result

  Hi Every one, I need your help to achieve results. Can you please help me any one? My requirement i…

  manavairajan

  11 replies

  5 years, 10 months ago

  By: manavairajan