T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Tally table ASCII validator - Anyone ever did this?

  Hi all, I'm trying to validate a database data, as we found some unknown characters in the descript…

  J-F Bergeron

  10 replies

  15 years, 10 months ago

  By: Paul White

• Need corresponding Month in int value

  My requirement is, I am passing some month names to query like as follows January 2009,March 2009 …

  venu_ksheerasagaram

  1 replies

  15 years, 10 months ago

  By: arun.sas

• Performance

  I have a stored procedure where First : I drop a table table1...with 50000 rows(col 1 int(5), col…

  mtz676

  2 replies

  15 years, 10 months ago

  By: Jeff Moden

• T-SQL Coding - What is the difference between SQL Server DDL and DML commands? Can you name some examples of each?

  T-SQL Coding - What is the difference between SQL Server DDL and DML commands? Can you name some ex…

  Arjun SreeVastsva

  25 replies

  15 years, 10 months ago

  By: Paul White

• merge output

  Hi all, I have to merge data for a table is nothing is available actually, I have a query that pick…

  sql_learner29

  5 replies

  15 years, 10 months ago

  By: Ray Dai

• Mulit-part identifier error

  I am having an issue with a process and would like to request another set of eyes to assist. I bel…

  cprice 70451

  5 replies

  15 years, 10 months ago

  By: Matt Miller (4)

• Comparing date fields in the same Row

  I'm having some trouble writing the logic on this one. What I need to do is check the dates in sev…

  rlwilde

  2 replies

  15 years, 10 months ago

  By: rlwilde

• Updatea table without degrading performance

  I have to update values to the Memkey and state fields in the TableA (Empkey,Memkey,State...) where…

  Tara-1044200

  20 replies

  15 years, 10 months ago

  By: Paul White

• deleting data from multiple access tables from sql

  Hello, I am running a script that I want to first delete all the data in 41 tables in an access db…

  jmillman3

  3 replies

  15 years, 10 months ago

  By: Dan Guzman - Not the MVP

• Problem in retrieving the data

  Hi, I need a query which retrieves the data in this format. Given below is the temp table and data.…

  asashank82

  2 replies

  15 years, 10 months ago

  By: asashank82

• Problem with global temporary tables in EXEC statement

  Hi, when I try to create a procedure like IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id=OBJECT_I…

  info-1153976

  3 replies

  15 years, 10 months ago

  By: Paul White

• convert nvarchar to int

  dear friends how can i convert a field with nvarchar type to int? thanks

  dr_csharp

  25 replies

  15 years, 10 months ago

  By: Paul White

• How to write a query for birthdays in the next two weeks?

  Hello, I am having trouble getting my head around querying for birthdays in the next two weeks. Tab…

  WebTechie

  8 replies

  15 years, 10 months ago

  By: WebTechie

• LEFT JOIN Predicates ON vs WHERE

  I am doing left joins where I am trying to find values that are in the left table but not in the ri…

  Ray Dai

  6 replies

  15 years, 10 months ago

  By: Ray Dai

• Indexed Views on Sql 2005

  Hi, I want to create an Indexed view on my database. But the problem is the result set my query ret…

  mrinal.jaiswal

  11 replies

  15 years, 10 months ago

  By: Paul White