T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Splitting a row into multiple rows based on an attribute

  Hi All I have a seemingly simple TSQL problem which is proving more challenging than I anticipated.…

  pYak

  2 replies

  15 years, 10 months ago

  By: pYak

• Dynamic Crosstab Query

  Hello Folks, I want to create a dynamic crosstab query. I have attached an Excel file that consists…

  erdem1973

  14 replies

  15 years, 10 months ago

  By: LutzM

• Return all characters to the right of a colon in a column

  I'm sure there's something simple for this, but I have 2 tables one has a column with text, a colon…

  Michael Viglas

  6 replies

  15 years, 10 months ago

  By: Paul White

• Decimal Truncation in division

  Hi Look at these SELECT statements. 1. SELECT CAST(1.67574 AS DECIMAL(38,10)) A, CAST(10000 AS DECI…

  dutt

  4 replies

  15 years, 10 months ago

  By: Paul White

• Find all occurances of a word starting with xyz_

  Hi all, recently i was asked to find out dependencies of objects starting with XYZ_ In my project w…

  Shaun-884394

  3 replies

  15 years, 10 months ago

  By: spaghettidba

• Rebuild Indizes with Stored Procedure

  Hi all, because we use the the express Database in some cases we decided to look for an alternative…

  teutales

  1 replies

  15 years, 10 months ago

  By: Paul White

• Partition of rows

  hi, I have a seq number in table i need to take the max seq number then show the results in sucha f…

  descentflower

  8 replies

  15 years, 10 months ago

  By: descentflower

• Quering data from same table

  CREATE TABLE SampleData ( ID INTEGER PRIMARY KEY, UID INTEGER NO…

  pritesh-807803

  9 replies

  15 years, 10 months ago

  By: ChrisM@home

• Convert two row join into one row?

  I have a header column I am trying to join with two rows from a table of fields and make one row. T…

  Sean Grebey-262535

  2 replies

  15 years, 10 months ago

  By: Paul White

• Updating Table 2 with Table 1 from Lastmodifieddate

  We have two tables, Table 1 Customer1 CustomerID, ISActiveFlag , LastModifiedDate -----------------…

  ALIF-662928

  8 replies

  15 years, 10 months ago

  By: John Rowan

• sqlcmd - how to skip empty files?

  Dear All, I am using sqlcmd to export *.txt files from DB with batch. When no data I generate empty…

  toni_nenova

  5 replies

  15 years, 10 months ago

  By: Ray Dai

• Passing IS Null to a variable

  I have a stored procedure and I am hoping this to be a very simple question, but I don't know if I …

  Brad Allison

  4 replies

  15 years, 10 months ago

  By: Brad Allison

• Hierarchy Structure Problem

  I am currently preparing hierarchical data for upload into an Essbase olap database. The hierarchi…

  eseosaoregie

  3 replies

  15 years, 10 months ago

  By: LutzM

• Select distinct question

  I have a table with the following structure CREATE TABLE [RECON_RECORD] ( [Serial] [tinyint] IDEN…

  ali.mahmoud.habib

  23 replies

  15 years, 10 months ago

  By: Paul White

• Issues with INSERT-EXEC

  here is my issue - I am trying to execute a stored procedure over a sybase server link and populate…

  robert.dickens

  1 replies

  15 years, 10 months ago

  By: Paul White