T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Recommended reading for basic stored proc T-SQL?

  Hey, guys. There are countless books out there on stored procs, etc. but all that I've seen tend to…

  Christopher Duncan

  6 replies

  16 years, 11 months ago

  By: Christopher Duncan

• Multi-Part Identifier Cannot be Found error message

  Newbie sql user. Created query below and ran in MS SQL Studio Manager. Keep getting the following e…

  rons-605185

  2 replies

  16 years, 11 months ago

  By: Ramesh Saive

• multiple insert

  hi everyone, i have the following table DECLARE @users TABLE ( userid int, username VARCHAR(20) )…

  sql_prodigy

  7 replies

  16 years, 11 months ago

  By: Vijaya Kadiyala

• insert rows to other table

  I want to insert 400k rows from main table to archive table. I want to first insert 5000 rows and t…

  rpatil22

  6 replies

  16 years, 11 months ago

  By: Vijaya Kadiyala

• convert varchar to datetime

  im trying to insert a varchar value into a datetime datatype column '1900-00-00 00:00:00.000' this…

  sql_prodigy

  4 replies

  16 years, 11 months ago

  By: Christopher Stobbs

• multiple rows in detail table, connected w AND in WHERE clause?

  Hello ppl, I have a kinda tricky issue here. I have one table with master data, and a table with de…

  Michael Niemand

  13 replies

  16 years, 11 months ago

  By: Michael Niemand

• ntext to nvarchar(max)

  Hi, TableA has follwing columns and data types: col1 int col2 varchar(100) col3 ntext col4 varc…

  Santhoshkumar KB

  14 replies

  16 years, 11 months ago

  By: Santhoshkumar KB

• without using count function

  Hi all is there a way to retrieve records based on count condition but without using count function…

  Tarun Yadav

  6 replies

  16 years, 11 months ago

  By: mayur.parmar

• Convert rows in columns

  Hi All, I am trying to generate a SQL Reporting service for one of the functionality. The data in m…

  Naveen-438995

  7 replies

  16 years, 11 months ago

  By: Mahesh Bote

• JOIN too slow; looking for a better approach

  Sql 2005: I want to compare two records in two tables that share a common "key". I want to update a…

  Barkingdog

  8 replies

  16 years, 11 months ago

  By: Johan Bijnens

• Query needed

  The database scheme consists of four tables: Product(maker, model, type) PC(code, model, speed, ram…

  Nikhil-843675

  8 replies

  16 years, 11 months ago

  By: Nikhil-843675

• dealing with timestamp

  I wud like to record time when a record is inserted by giving default value from table definition. …

  Mike Levan

  12 replies

  16 years, 11 months ago

  By: Bruce W Cassidy

• Struggling with a query between a lookup table and a real table

  Hi All, I have a look up table IDTimeStampClsoe 88825/01/20091 88826/01/20090 90625/01/2009…

  Aparna-1

  3 replies

  16 years, 11 months ago

  By: Jack Corbett

• Intersect against queries with different #'s of arguments

  Setting: sql 2005: ---- CREATE TABLE [dbo].[M]( [c1] [nchar](10) NULL, [c2] [nchar](10) NULL, [c…

  Barkingdog

  1 replies

  16 years, 11 months ago

  By: Gail Shaw

• Xquery against an XML column

  I made a table with an xml datatype column. In this column i put a xml file. There can be more xml …

  Jacobus-785651

  2 replies

  16 years, 11 months ago

  By: Jacobus-785651