T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Time Intervals

  This is driving me slowly insane. . . :hehe: I've been tasked to create an SSRS report showing whic…

  Cadavre

  4 replies

  14 years, 12 months ago

  By: Cadavre

• help me creating query

  Hi my data is Id amount 213 500 214 600 215 700 215 …

  shyaagi

  6 replies

  14 years, 12 months ago

  By: Eralper

• T-SQL update

  Hi, I am running below query in sql studio and I am getting syntax error near inner, any suggestion…

  biren

  1 replies

  15 years ago

  By: LutzM

• Update Error

  I have a Table A. When I update Table A, I want to insert a record into Table B. Table B looks very…

  Rog Saber

  7 replies

  15 years ago

  By: Rog Saber

• 2 sep. queries are fast except when executed together via UNION ALL

  I have 2 queries that run fast on their own (3 seconds and sub-second) but when I use a UNION ALL b…

  p1nball

  6 replies

  15 years ago

  By: Evil Kraig F

• How to pick specific data from a varchar(250) size column

  I need a query to pick Bold text from following data (each row has atleast src= ) : ?lid={B50A4527-…

  Shamshad Ali

  6 replies

  15 years ago

  By: Brigadur

• My script for index rebuid n reorganize

  Hi All, I create script for index rebuild and reorganize for my dummy database. this is as follows …

  fawwad

  7 replies

  15 years ago

  By: fawwad

• Averaging data streaks

  Hi, I have the following sample data: -- schema IF EXISTS (SELECT * FROM sys.objects WHERE object_…

  keymoo

  7 replies

  15 years ago

  By: keymoo

• Transforming string for ImagePath

  Hello comunity I would like to know how to transform my imagepath from : C:\PROGRAM FILES\DYNAMIC A…

  luissantos

  4 replies

  15 years ago

  By: mister.magoo

• Finding current and prior date

  I receive a list of parts daily with price updates. In the file I get a part number, effective dat…

  Shaira

  5 replies

  15 years ago

  By: Jeff Moden

• simple sp

  Hi i have a table with this format: Filed1 Field2 Field3 the type of Filed3 is bit i want to write …

  nazaninahmady_sh

  7 replies

  15 years ago

  By: Jeff Moden

• Table Normalization

  Hi All, I am new to the Database world. I would be very happy if any body Normalize the below tabl…

  parivedamohan

  1 replies

  15 years ago

  By: Gail Shaw

• Running Total using T-SQL

  I have created a view that combines purchasing data with sales data for items that are bought and s…

  Ralph L. Wahlert

  20 replies

  15 years ago

  By: WayneS

• column value balancing (copy previous value <> NULL)

  Hi, I have the following table with data RowNum Cat Class Loc Date …

  Dick Herberts-320552

  29 replies

  15 years ago

  By: WayneS

• help needed

  Can somebody help writing a function to accept string value like this: N'ABD',N'DYX',N'ALL' And ret…

  Vishal Singh

  8 replies

  15 years ago

  By: Lowell