T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Selecting Max and Min Rows in one SQL Statement

  I have a table that has an BuildingID, UserID, DateID columns. There could be many rows for a Build…

  DBloc

  7 replies

  13 years, 4 months ago

  By: DBloc

• T-SQL Dynamic Stored procedure for SQL2K5

  Hi guys, I'm really struggling with this one - I generally use SQL2K8 and i'm used to the format on…

  jon.hall 50545

  25 replies

  13 years, 4 months ago

  By: TheSQLGuru

• DMV to gather history on queries run 2 days ago ?

  Is there any way to find if there was any query run which had high CPU and IO and ran for x number …

  chopperGuy

  4 replies

  13 years, 4 months ago

  By: Grant Fritchey

• Delete data from table issue

  Hi all, i have a table city having these values Id Name 1 ABC 2 …

  MuhammadShafiq

  6 replies

  13 years, 4 months ago

  By: jcb

• try/catch halting on error... am I missing something?

  Hi Guys, I have a program that needs to copy data from various sources. Some of these sources are n…

  BenWard

  5 replies

  13 years, 4 months ago

  By: BenWard

• STR function

  It's friday morning and i'm not sure if i'm going mad. PRINT STR(98.43075,28,14) returns 98.4307500…

  jasonmorris

  9 replies

  13 years, 4 months ago

  By: Phil Parkin

• uncommitted transactions

  I have a script that contains about 10 queries to import records from tables in one db to another. …

  Stef Teal

  8 replies

  13 years, 4 months ago

  By: amit_adarsh

• Min & Max Date from DateTime Field based on Case

  Hi All, I have following Query and below is output, I need your help to get following results. I ha…

  waheed71

  11 replies

  13 years, 4 months ago

  By: Dave Brooking

• Searching for Single Quotation Marks in a Table's Text Column

  It's easy to find double quotation marks in a column with LIKE '%"%' But how do you search for sin…

  mtillman-921105

  2 replies

  13 years, 4 months ago

  By: mtillman-921105

• table asking for user input as class and displays the list of studetns and the course taught in that class

  I am using MS SQL SERVER 2005 and for application logic and user interface using C# I have designed…

  nischalinn

  2 replies

  13 years, 4 months ago

  By: Gail Shaw

• The maximum recursion 100 has been exhausted before statement completion

  Dear Expert, I want to find the number of Working days in a year, so i passed the two date values t…

  windows_mss

  18 replies

  13 years, 5 months ago

  By: Jeff Moden

• Is there a way to insert a record and then select that record

  I have a table with a Column "ID" (int) with an Identity Specification; it increments by one. Is th…

  Ken at work

  3 replies

  13 years, 5 months ago

  By: GSquared

• Latest record but with extra info from previous one

  Hi, I have the following table and has some data like below (not necessarily in date order): Audit …

  Adelphi

  4 replies

  13 years, 5 months ago

  By: spaghettidba

• Encrypted fields

  Hello, This DB was not built by me. SQL 2005 DB. Basics Employee code, name and certain things are …

  durai nagarajan

  12 replies

  13 years, 5 months ago

  By: GSquared

• What is the User Actions History Best practice?

  In Our company we want to log User history in our web application,for example when a user come to a…

  b.ghadami

  5 replies

  13 years, 5 months ago

  By: spaghettidba