T-SQL

• Topics

  Started by

  Posts

  Last post

• Select based on filed length?

  Hi all, Relative newbie here in the world of SQL. How can I do a select on a text as well as an int…

  WaIIy

  5 replies

  17 years ago

  By: WaIIy

• Top 1 for each group

  Hi, I know there are great ways to solve this in SQL 2005 and beyond, but this server is SQL 2000: …

  TB-462197

  4 replies

  17 years ago

  By: RBarryYoung

• UPDATE STATEMENT and using DATEDIFF Function getting crazy resulst

  Hi, I put in example data and the UPDATE STATEMENT, and for the life of me I can't figure out why m…

  john.steinbeck

  5 replies

  17 years ago

  By: john.steinbeck

• Using Count and Max on the Same field

  I am trying to do a count on my Lesson CatId to find Instructors that have the highest number of bo…

  cindy_sinath

  3 replies

  17 years ago

  By: Matt Miller (4)

• Which PK Generation system variable is reliable?

  [font="Verdana"][font="Verdana"][/font] I am new to sql server and I need you suggestions: which on…

  Aur_Ek_SQL

  5 replies

  17 years ago

  By: Vladan

• Display duplicate rows

  I have written a little script to determine the number of duplicates based on having a certain cod…

  eseosaoregie

  4 replies

  17 years ago

  By: eseosaoregie

• Select statement running very slow on a table

  Hi, I have a table when I run a select statements it is taking lot of time and returning 17000 row.…

  Kiran Kumar MP

  6 replies

  17 years ago

  By: SwePeso

• inner join issue

  I have written the follow query in sql server to match nhs numbers to various patients in a table, …

  eseosaoregie

  7 replies

  17 years ago

  By: Garadin

• T-sql query...

  hello, Any command is there to delete records.. Problem, I have one database name is --- …

  dastagirid

  6 replies

  17 years ago

  By: Johan Bijnens

• Searching for a specific value in any database on a server

  The SQL Server host holds several databases for an application. Some of them are defined the same a…

  J-440512

  2 replies

  17 years ago

  By: J-440512

• Using CASE in a delete statement

  The goal is to keep a rolling 13 months of data within a table. The following query is what I am u…

  Molly-239126

  7 replies

  17 years ago

  By: Lynn Pettis

• BCP error

  hi all i got a BCP error : FARM2-BACKUP\SQL2005,NOC_DRIVER_REPORT_RYDER_H,STEP,,Executed as user: F…

  ayoshpe

  1 replies

  17 years ago

  By: Kishore.P

• How To Debug a lengthy Stored Proc in Sql Server 2000 ,that contains 5000 lines of code

  anyway i don't want to use a error log , and track that log file, would like to know any other alte…

  Anu-923127

  18 replies

  17 years ago

  By: J-440512

• DISTINCT AND COUNT

  I have an issue I am using to count the number of records in a table. When i execute the following …

  eseosaoregie

  4 replies

  17 years ago

  By: Christopher Stobbs

• How to run the job through T-SQL statements

  How to run the job through T-SQL statements

  afzal_1201

  1 replies

  17 years ago

  By: SQLZ