T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Recursive Update Trigger

  I am trying to create an update trigger that updates isactive field depending on different criteria…

  Erin.

  2 replies

  13 years ago

  By: Dwain Camps

• Time Problem

  Hi, I'm trying to figure out a way to calculate a weighted average, but having trouble with the tim…

  dajonx

  9 replies

  13 years ago

  By: Dwain Camps

• Split A String into 4 parts

  Hello Everyone Thank you all for the suggestions yesterday. I have written a SSIS package that now …

  AndrewSQLDBA

  7 replies

  13 years ago

  By: Dwain Camps

• IF EXISTS doesn't work for me

  I'm trying to chekck the existance of a table first and then get a value ONLY IF when the table is …

  Biank

  2 replies

  13 years, 1 months ago

  By: Biank

• Word wrapping query output

  This one is probably very simple, but I can't find the answer to save my life. I have a query that …

  Mick Opalak

  6 replies

  13 years, 1 months ago

  By: Alan Burstein

• Convert String to Time Format

  Hello Everyone I have been working most of the morning to try and figure out how I can convert a st…

  AndrewSQLDBA

  4 replies

  13 years, 1 months ago

  By: AndrewSQLDBA

• Data Insertion into Access DB using T-SQL

  Hi Guys, I am trying to insert data from SQLServer into an access database,using T-SQL I used OPENR…

  lraju10

  8 replies

  13 years, 1 months ago

  By: Don Urquhart

• Performance Problems converting data into columns

  Hello, I am in need of some help with an SSIS package (SQL 2008). I am trying to extract data out o…

  Craig Pa

  1 replies

  13 years, 1 months ago

  By: Craig Pa

• Converting Rows to columns

  i want to convert rows to columns 2 2 0 output 2 2 0

  sqlbi

  3 replies

  13 years, 1 months ago

  By: Sean Lange

• How to create a query which kill CPU?

  Hi For some tests I need to create a query or set of queries which overloads my test machine which …

  b.ozga

  4 replies

  13 years, 1 months ago

  By: b.ozga

• Advanced String Manipulation

  I have a string that needs some serious help... I need to rewrite many strings with the aggregate v…

  brickpack

  5 replies

  13 years, 1 months ago

  By: Sergiy

• Reporting on report execution over the last 12 months

  Hi guys, I'm looking to create a report that will detail how many times each SSRS report was execut…

  Chris-475469

  2 replies

  13 years, 1 months ago

  By: Chris-475469

• FOR XML and trying to avoid nested cursors

  Alright, history first. I've got a bit of a mess I've inherited. Groups inheriting groups inherit…

  Evil Kraig F

  9 replies

  13 years, 1 months ago

  By: Evil Kraig F

• sysjobsteps.last_run_outcome = 0 or is it?

  I'm trying to create some code to quickly run on each server to get a listing of failed jobs curren…

  John Waclawski

  2 replies

  13 years, 1 months ago

  By: John Waclawski

• Creating Stored Procedure

  Hi, I have below table: ID URL 1 https://google.com 2 https://facebook.com 3 https://yahoo.c…

  dsrapid

  3 replies

  13 years, 1 months ago

  By: Alan Burstein