T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Checking user's AD Group

  Is it possible to check for Active Directory group.. ie see if the user running the Stored Proc, is…

  dwilliscp

  6 replies

  11 years, 8 months ago

  By: benjamin.reyes

• Stored procedure with results

  Hi everyone I am new on the stored procedure area and I have created a stored procedure that return…

  phelisamoss

  4 replies

  11 years, 8 months ago

  By: phelisamoss

• calculate the sum of dates minus repetitive dates

  Hi experts, Today I have got one scenario to calculate the (sum of days difference minus(-) the dat…

  pmadhavapeddi22

  18 replies

  11 years, 8 months ago

  By: pmadhavapeddi22

• 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 months ago

  By: ScottPletcher