T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Ranking rows on basis of SUM of records

  Hi Team, Following is my table structure IDRowCount PagID 1448 2267 3297 4216 5405 6254 7…

  rhd110

  5 replies

  11 years, 10 months ago

  By: ChrisM@Work

• Why is this code deleting only 1 row at a time instead of using the condition and deleting many rows?

  /****** Object: StoredProcedure [dbo].[dbo.ServiceLog] Script Date: 07/18/2014 14:30:59 ******/…

  davidsalazar01

  9 replies

  11 years, 10 months ago

  By: davidsalazar01

• Enhancing SQL Skills

  So I feel that I can write in general now any query for a report that my company would require of m…

  npatel 17252

  5 replies

  11 years, 10 months ago

  By: Ed Wagner

• T-SQL: Cumulative SUM

  Hello: Below is my T-SQL query. Also, attached are its results. My focus, primarily, is on the YRA…

  John Roy Ellis

  5 replies

  11 years, 10 months ago

  By: josjonkmans

• Replace WHILE Loop with Recursive CTE(?)

  Hi Everyone, I would like to replace the code below with a set based solution. Any help is apprecia…

  kiril.lazarov.77

  4 replies

  11 years, 10 months ago

  By: kiril.lazarov.77

• how to write a proc to upload the xml files into above tables

  Hi There are two tables in my database HotelList_Temp, AsiaHotelChildrenAges_Temp I need to write a…

  edara1234

  10 replies

  11 years, 10 months ago

  By: edara1234

• Join 2 table based on Date

  Hi forum, I have 2 tables: Table Transaction ----------------- EmpID TransDate 00001 1/1/2014 000…

  msi.soloinfo

  4 replies

  11 years, 10 months ago

  By: msi.soloinfo

• Use a Like in a Replace Cast sentence?

  Hi, i would appreciate suggest the SQL sentence, thanks CREATE TABLE [dbo].[instructions]( [site_no…

  cphspain

  4 replies

  11 years, 10 months ago

  By: cphspain

• SQL Query Help needed - Thank you.

  Hello Folks, I'm in need of your kind help here, I have two tables listed below, the first table ha…

  DiabloSlayer

  5 replies

  11 years, 10 months ago

  By: Cadavre

• How do I drop the DROP DATABASE ENCRYPTION KEY & DROP MASTER KEY ?

  How do I drop the DROP DATABASE ENCRYPTION KEY & DROP MASTER KEY ? I tried but I was unsuccess…

  Welsh Corgi

  2 replies

  11 years, 10 months ago

  By: Lynn Pettis

• Replace a Cursor

  Hi All Could anyone help me on getting the below Cursor query convert to a Recursive CTE or with a …

  ksrikanth77

  20 replies

  11 years, 10 months ago

  By: Sean Lange

• Converting Integer Values to Datetime

  Hi, As a DBA, I am working on a project where an ETL process(SSIS) takes a long time to aggregate a…

  chandan_jha18

  4 replies

  11 years, 10 months ago

  By: ScottPletcher

• merging intervals with identical data

  I'm having issues building a cte sql statement for merging intervals and I would greatly appreciate…

  N_Muller

  3 replies

  11 years, 10 months ago

  By: N_Muller

• Isolating a list with pattern search

  Hi, I'm trying to pull up a report of restored databases from our bug tracking software to audit an…

  sqldriver

  6 replies

  11 years, 10 months ago

  By: sqldriver

• String occurrence count with Cross apply

  Hi All, See sample data below. I'm trying to count the number of occurrences of strings stored in t…

  kiril.lazarov.77

  10 replies

  11 years, 10 months ago

  By: kiril.lazarov.77