T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Hierarchical data for TreeView Control, CTE or Cursors

  I’m trying to replace cursors in stored procedures to retrieve hierarchical data from a table. The …

  DeWet

  1 replies

  17 years ago

  By: DeWet

• Getting datepart to work for query

  Hi, I have a report where I need to see all current activity in a mfg shop from 4:30 am of yesterda…

  shree dhavale

  7 replies

  17 years ago

  By: Michael Valentine Jones

• Concatenating fields with possible additional character

  Hello: I need to concatenate a number of fields in my SQL Server database for export to an external…

  lk-681111

  8 replies

  17 years ago

  By: Florian Reischl

• Help with importing data

  Hi I really appreciate your help, I am not being lazy and trying to get someone to sort it I really…

  olibbhq

  11 replies

  17 years ago

  By: AmolNaik

• Deleting 1 record is taking 4:30 minutes

  Hi all, I am experiencing an issue when deleting a record. use MyDatabase go delete from dbo.MyTa…

  JohnDBA

  11 replies

  17 years ago

  By: Ian Scarlett

• tsql multiple rows select statement

  hi i need some help,i have a table and i want to check a condition if this happen i want to insert …

  mai_tbaileh

  1 replies

  17 years ago

  By: John Rowan

• Obtaining the name of machine you are running a SQL statement from

  Is there any way in SQL to obtain the name of the machine you are connecting from to issue a comman…

  thegreatelectron

  9 replies

  17 years ago

  By: thegreatelectron

• First come first serve table

  Hi all, my first post, stunning forum! I have a table with a list of job numbers: JobID JobCode Is…

  hein-1120388

  9 replies

  17 years ago

  By: hein-1120388

• How do I get the max, min, avg, current at the same time

  Hi guys, I have a table with structure as following: ID, Stock, RiQi, ShouShi For each Name, there…

  halifaxdal

  2 replies

  17 years ago

  By: halifaxdal

• To Pivot or not to Pivot

  Hi All, I want to be able to transform the following data [font="Courier New"] Name Month …

  Paul Anderson-304005

  2 replies

  17 years ago

  By: Paul Anderson-304005

• How to transpose from Row to Columns with out using Pivot

  Hi I'm using SQL Server 2005 and have a table with telephone nr in. When I link it back to main tab…

  chris.stuart

  33 replies

  17 years ago

  By: chris.stuart

• How do I query my data with multiple groups

  Hi guys, I have data like this: ID Field Group 1 aaaa 2 bbbb 3 cccc 4 dddd .... Now, all the data…

  halifaxdal

  4 replies

  17 years ago

  By: halifaxdal

• server side [?] query execution time

  hi, I would like to know what is query execution time but without overhead added by : ---transferr…

  rw30

  13 replies

  17 years ago

  By: rw30

• BETWEEN In Join Condition

  I suppose the subject and description say it all but does a BETWEEN in the join condition make a tr…

  allen davidson

  4 replies

  17 years ago

  By: allen davidson

• Formatting data from two rows

  Hi All. I have a SPROC that inserts data into a table in following format. LASTNAME FIRSTNAME …

  indio0617

  8 replies

  17 years ago

  By: Jeff Moden