SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• How to get highest bonus and second highest bnus paid freelancer for each group

  I have a table below: Freelancer(id, fl_name, bonus, fl_group) Create table Freelancer (id int, fl_…

  PasLe Choix

  23 replies

  5 years, 9 months ago

  By: Steve Jones - SSC Editor

• handling Nulls in case series

  Why is the "is null" throwing a syntax error?: UPDATE [GCDF_DB].[dbo].[People] SET [educationtext] …

  DaveBriCam

  3 replies

  5 years, 9 months ago

  By: Michael L John

• Partition by and count

  I'm trying to write a query that will count (N) all members within a specific city but without repe…

  DaveBriCam

  6 replies

  5 years, 9 months ago

  By: Matt Miller (4)

• [SOLVED]Migrating databases - error on login 4064 (cannot open default database)

  Hello, I am trying to figure out how to create a script to generate Login mappings to databases. I'…

  richlion2

  10 replies

  5 years, 9 months ago

  By: richlion2

• Scalar function use results of exec(@sql)

  Hi, I have a TVF that pulls column details from sys.tables so that it can produce some dynamic sql …

  david_h_edmonds

  11 replies

  5 years, 9 months ago

  By: Jeff Moden

• Format date into a common format having two types of values in it.

  I have a table and it has a column of nVarchar(max) data type. It has values in it as shown below. …

  Sanz

  1 replies

  5 years, 9 months ago

  By: pietlinden

• Count with different intervals

  Hi Experts I try to count calls in different interval's for example by by day in 10 min intervals  …

  andy.egli

  2 replies

  5 years, 9 months ago

  By: ScottPletcher

• Requesting help for advanced SQL generating automatic counts based on dates

  Hi, challenging query I have that I can only get part of and am looking for expertise. I have a col…

  cuseman03

  12 replies

  5 years, 9 months ago

  By: John Mitchell-245523

• Query is getting Timed out

  Hi All, One of the query on Production, it is running over 5 overs and still not yet done. How can …

  vsamantha35

  3 replies

  5 years, 10 months ago

  By: Chris Harshman

• t-sql 2012 insert into a temp table

  Can you show me a better way to place hardcoded values into a sql server 2012 temp table with selec…

  wendy elizabeth

  2 replies

  5 years, 10 months ago

  By: drew.allen

• Strange behaviour relating to TEMPDB

  Hi all, I'm the classic accidental DBA and I'm trying to troubleshoot an issue with a vendor-manage…

  farren.minns

  2 replies

  5 years, 10 months ago

  By: John Mitchell-245523

• Query tuning help

  Hi All, Query is taking more than 10 mins. Don't know whats happening. Seeking for inputs in tuning…

  vsamantha35

  16 replies

  5 years, 10 months ago

  By: David Burrows

• how to lock the record

  Hello, i have a table called Codes and having below columns Declare table Codes(IdCode int identity…

  KGJ-Dev

  18 replies

  5 years, 10 months ago

  By: KGJ-Dev

• Need help to insert Data into 2 Tables

  I've table and data as following, CREATE TABLE [dbo].[EMPMAS_DATA]( [UniqueId] [int] IDENTITY(1,1)…

  Adelia

  4 replies

  5 years, 10 months ago

  By: Lowell

• How to speed up the query speed between different server tables

  There is a SQL statement to select data from 2 SQL Server tables, and the the collation of these 2 …

  892717952

  10 replies

  5 years, 10 months ago

  By: 892717952