T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Iterating a variable through a table and then resetting it without using cursors

  Hi, new to the boards, been using SQL Server for about a month. I will show an example of what I am…

  huston.dunlap

  6 replies

  16 years, 7 months ago

  By: RBarryYoung

• Find all the vehicleid's of top tree and all the subtrees of each subtree

  I have a table with 3 columns: Fleetname, FleetId, ParentFleetId. Another table with column: Vehicl…

  kevin_nikolai

  1 replies

  16 years, 7 months ago

  By: LutzM

• Invoice age and excluding valus of 0.00

  Hello I have a couple of issues I cannot get my head around 🙁 1. I have invoice.InvDate and what I …

  graham.hilton23

  2 replies

  16 years, 7 months ago

  By: graham.hilton23

• Find Max Unique Value

  I have inherited a database application that takes tests from users and tracks the results. Users …

  benjones62

  3 replies

  16 years, 7 months ago

  By: Jeff Moden

• Converting Datetime Field To Text

  I have a datetime field that I want to convert to text in another field and also have the full name…

  Roger Abram

  4 replies

  16 years, 7 months ago

  By: Jeff Moden

• Rows returned with null values in a criteria field.

  Ok, so I have an issue. There is a table that has a status field on it. When I query that status fi…

  Timothy.Cloud

  1 replies

  16 years, 7 months ago

  By: Garadin

• Running DOS Command Prompt(cmd) command thought SSMS

  Hi All, Is it possible to run DOS command prompt commands through T-Sql Statement or by some proce…

  naveenreddy.84

  18 replies

  16 years, 7 months ago

  By: Jeff Moden

• Nested Case statement

  SELECT 'OPEN' as [AREA_DESCRIPTION] ,'OPEN' as [METRIC_DESCRIPTION] ,C.[IPC_SITE] ,C.[VALUE_STREAM]…

  pitso.maceke

  27 replies

  16 years, 7 months ago

  By: Lynn Pettis

• CTE's, Do you use them on an everyday basis?

  Just wondering how many people actually use Common Table Expressions?

  Bradley Jacques

  4 replies

  16 years, 7 months ago

  By: Jeff Moden

• Storing MySQL Stored Procedure resultset in a SQL Server temp table

  Hi All, I have a MySQL 5.0 db server connected via a linked server (using MySQL ODBC DSN) and I can…

  ttsang

  3 replies

  16 years, 7 months ago

  By: ttsang

• Join Three tables in single resultset (For tree like structure)

  I have three tables Category, SubParent & Master.. below are details. I am trying to populate …

  netpicker9

  3 replies

  16 years, 7 months ago

  By: Mark Cowne

• possibleto create View with Variable inside

  Is it possible to create a SQL Server 2008 view that houses a variable? For example: create view V_…

  Express12

  6 replies

  16 years, 7 months ago

  By: The Dixie Flatline

• Mulit-part Identifier error

  Ok, so I tried working on this for a while before I posted on here, just can't get it. When I'm wa…

  jordon.shaw

  2 replies

  16 years, 7 months ago

  By: kramaswamy

• Restore does not restore all stored procedure permissions.

  Hi SQL 2005. I have a production server which I backup and restore to a test server. However, whils…

  peter.lane

  7 replies

  16 years, 7 months ago

  By: Grant Fritchey

• GROUP BY on a column not in the SELECT list

  Does a GROUP BY on a column that is not in the select list have any bearing on the SELECT results? …

  Dustin W. Jones

  5 replies

  16 years, 7 months ago

  By: Dustin W. Jones