T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Split a String

  Hello Everyone I hope that everyone is having a great day. I am working with some horrible data, an…

  AndrewSQLDBA

  8 replies

  13 years, 5 months ago

  By: Jeff Moden

• Input Validation

  Hi I want to validate my input parameter, which is policy Id (int) So I have: declare @Valid_Policy…

  hoseam

  10 replies

  13 years, 5 months ago

  By: Dwain Camps

• How do I get database space used

  Hi, How do I get database space used (not database size) for all given databases? At this moment, I…

  sql-lover

  16 replies

  13 years, 5 months ago

  By: Jeff Moden

• Total number of DMV in SQL Server

  Hi all, Since there are number of DMV's present and there is no proper presentation on it. So if su…

  Shadab Shah

  3 replies

  13 years, 5 months ago

  By: Lowell

• Format date time

  I need to output datetime data in this format: 11/19/2012 8:54:59 AM, so mm/dd/yyyy (h)h:mm:ss AM/…

  schleep

  7 replies

  13 years, 5 months ago

  By: schleep

• Query Analyzer

  Whenever I click on New Query window by default " Begin Transaction Rollback" statement appears.…

  kapil_kk

  3 replies

  13 years, 5 months ago

  By: kapil_kk

• Need help with a script to identify count of negative and positive numbers in a record

  Hello All, I need help with a tsql query. Below is the table structure. CREATE TABLE [dbo].[TableN…

  Pyman

  13 replies

  13 years, 5 months ago

  By: Pyman

• Performance Issue

  We have a procedure which performs _NO_ update or delete operation but only read. This procedure ru…

  sqlnaive

  6 replies

  13 years, 5 months ago

  By: Robert Klimes

• returning all dates that match year and month

  SELECT MachineName, ModeName, FileName, UserName, StartDate, StartTime, EndDate, EndTime, Ru…

  jerome.morris

  7 replies

  13 years, 5 months ago

  By: Sean Lange

• Avoiding cursor: Help with getting only first match after previous match

  Hi I'm sure there is a better name for this problem, and its probably quite a common one with a hop…

  t.brown 89142

  18 replies

  13 years, 5 months ago

  By: Eugene Elutin

• CASE Statement in SELECT clause to convert into the where clause

  ??? MCSE SQL Server 2012\2014\2016

  lkennedy76

  4 replies

  13 years, 5 months ago

  By: math martinez

• Convert values of mulitiple rows into single column with no duplicate entries

  hi all, i went through the forum and found out a way of concatenating row values into column using …

  sayedkhalid99

  6 replies

  13 years, 5 months ago

  By: sayedkhalid99

• T-SQL Query Help

  Hi, I have a table that looks like the following: CREATE TABLE [dbo].[EmployeePerms]( [EmployeeGr…

  Mike Scalise

  3 replies

  13 years, 5 months ago

  By: Mike Scalise

• Convert field from YYYYMMDD format to MM/DD/YYYY ?

  Hello, I have a date filed in the YYYYMMDD format ,want to convert it into MM/DD/YYYY. I have tried…

  SQL SERVER ROOKIE

  11 replies

  13 years, 5 months ago

  By: Sean Lange

• Creating square box polygon from Geography/Geometry Point

  Hi, I have a set of world grid points (lat/long) values. For each point, I have a 'geography' poin…

  darrin.wilkinson.66

  1 replies

  13 years, 5 months ago

  By: mickyT