T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Identify column value updated in a Trigger

  I am attempting to send an email notification when the Location or EventDate column has been update…

  Express12

  3 replies

  13 years, 7 months ago

  By: GSquared

• Need assistance to CAST the StartDate

  HI Need help to get 2 things out of the below result set. 1) Make the StartDateTime as '2012-xx-xx …

  Mac1986

  17 replies

  13 years, 7 months ago

  By: Mac1986

• Help with Count over days (but not per day) ... the total up until that day through the date range.

  I am having an issue trying to wrap my head around this. I am trying to get the count of something …

  Kevlarmpowered

  6 replies

  13 years, 7 months ago

  By: Kevlarmpowered

• Consolidate Overlapping Date Periods

  Getting late in the day and I could use some support from those who are feeling fresh! 🙂 Suppose I …

  Phil Parkin

  16 replies

  13 years, 7 months ago

  By: Dwain Camps

• how to add indexes in all tables in a database

  hi i want to create foreign key indexes on all the base tables in a database ,i need to check in ev…

  achtro

  5 replies

  13 years, 7 months ago

  By: Lowell

• search levels

  Hello all, I'm wondering if it is possible to do the following. I have a table with locations in th…

  Mike Saunders NL

  7 replies

  13 years, 7 months ago

  By: laurie-789651

• How to usdate records after some time periode of its insretion in table.

  hello friends I am working on a application where we are sending OTP as password to users but this …

  amitsingh308

  6 replies

  13 years, 7 months ago

  By: Dwain Camps

• Date Comparison Error

  Dear All, Greetings!!!! Today I face a problem in Date Comparison please help me in out thanks in a…

  dipanshu.mittal

  1 replies

  13 years, 7 months ago

  By: laurie-789651

• I need to compare and split the string and then save it in the detail_tb but dont know how ?

  Some one post this code in forum and it work fine except i didnt got any clue,How to map these val…

  maida_rh

  13 replies

  13 years, 7 months ago

  By: Dwain Camps

• Rollup issues

  I cannot figure out how to add columns or ordering to my query which has a Rollup without it changi…

  tshad

  3 replies

  13 years, 7 months ago

  By: tshad

• query to get dates for a number of weeks

  I need a query that will produce rows of dates given a starting date and incrementing that date for…

  chrismat

  3 replies

  13 years, 7 months ago

  By: Lynn Pettis

• insert rows

  hi i want to insert 1000 rows in a table without any loop. how can i do it?

  harri.reddy

  9 replies

  13 years, 7 months ago

  By: Jeff Moden

• Avoid using cursors

  DECLARE @RNum int DECLARE @DDate datetime DECLARE @MaxBolTime int DECLARE @GGallons numeric (14…

  PSB

  6 replies

  13 years, 7 months ago

  By: Sean Lange

• Help with storing timezone

  I have a web application where the users will be entering time based on the different time zones th…

  Guras

  8 replies

  13 years, 7 months ago

  By: Sean Lange

• Change Data Capture , Change value in [msdb].[dbo].[cdc_jobs]

  Hi Team, I am working setting up CDC for a table on a database and i understand that we need to cha…

  kumar-378458

  2 replies

  13 years, 7 months ago

  By: kumar-378458