General

• Topics

  Started by

  Posts

  Last post

• Count total in a rolling 12 month period?

  I’m trying to count how many times a ProvNum has an Outcome of >= 2 in a 12 month rolling perio…

  kawi6rr

  3 replies

  9 years, 2 months ago

  By: Luis Cazares

• Advice please - how to train up on API integrations

  Hi all My company has a product which is based on SQL Server 2014, and we're looking to add some in…

  nick-1043370

  3 replies

  9 years, 2 months ago

  By: xsevensinzx

• Selecting data in a table that are not in the other table

  Hi I have a problem with selecting. I have an application, where admin can create multiple lists of…

  milancerny2

  2 replies

  9 years, 3 months ago

  By: Gail Shaw

• Parent and child relationship is broken when do the sort based on parent name

  Hi All, I want to sort the name based on 1st level (sort only applicable root id is null or…

  stsivaraj

  5 replies

  9 years, 3 months ago

  By: Jeff Moden

• Changing code within a Select statement

  I have a huge select statement that has to be repeated because the Group By changes at the four dif…

  SW_Lindsay

  2 replies

  9 years, 3 months ago

  By: Hugo Kornelis

• Error with syntax using ;With

  What is wrong with my syntax? IF ( (@Client = 'Winco Foods' AND EXISTS ( ; WITH XMLNAMESPACES('h…

  GrassHopper

  3 replies

  9 years, 4 months ago

  By: GrassHopper

• Export TIFF files from DB

  Hi, I got a database which contains in a table, a column contains files. The column is from type im…

  ran.ovadia

  2 replies

  9 years, 4 months ago

  By: ran.ovadia

• usp stored procedure prefix

  I've been using the usp prefix for years and have been challenged by a collegue about its usage who…

  Olja Dimitrijevic

  24 replies

  9 years, 4 months ago

  By: SqlNightOwl

• SCAN vs. SEEK

  I'm stumped. I have two tables. The first table has a field where I need to extract an alpha-nume…

  greg6363

  7 replies

  9 years, 4 months ago

  By: Steve Jones - SSC Editor

• Usage of CROSS APPLY

  I have a number of queries that contain moderately complex business logic and that logic is used by…

  SqlNightOwl

  2 replies

  9 years, 4 months ago

  By: Hugo Kornelis

• Can't ALTER COLUMN to NOT NULL and ADD PRIMARY KEY in the same SQL Batch?

  I've searched existing posts and this seems so straightforward, I'm convinced that I'm just missing…

  hlrx

  9 replies

  9 years, 5 months ago

  By: Hugo Kornelis

• Defining unique sets of records in a dataset

  I work for a logistics company. Customers send packages from point A to B and pay a certain amount …

  bart.hermans

  4 replies

  9 years, 5 months ago

  By: Steve Jones - SSC Editor

• Purge/Delete records from a table

  hello, have to delete records from a table SELECT * FROM [DB_NAME].[dbo].[Table_Name].Insert_Datet…

  anzz

  5 replies

  9 years, 5 months ago

  By: er.mayankshukla

• Possible to insert unaffected by rollback?

  I'd like to write to a log table, while within a transaction, and not have it affected by a rollbac…

  uncager

  11 replies

  9 years, 6 months ago

  By: Sergiy

• Anti SQL Injection Function

  I have a Stored procedure that has many parameters (all varchar), some parameters are used in where…

  JohnG69

  18 replies

  9 years, 6 months ago

  By: Lynn Pettis