T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• 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

  17 years, 5 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

  17 years, 5 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

  17 years, 5 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

  17 years, 5 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

  17 years, 5 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

  17 years, 5 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

  17 years, 5 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

  17 years, 5 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

  17 years, 5 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

  17 years, 5 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

  17 years, 5 months ago

  By: Jacobus-785651

• count without using count function

  Hi all is there a way to retrieve records limiting based on some number but without using count fun…

  Tarun Yadav

  2 replies

  17 years, 5 months ago

  By: Fraggle-805517

• OLE DB provider 'MSDASQL' returned an unexpected data length for the fixed-length column

  Hi, When I tried executing the following query, I got the error as follows. Please tell me, how I c…

  Ezhilan

  2 replies

  17 years, 5 months ago

  By: Chad Carter

• Audit Trail - Handle image fields

  I am using the below trigger to updated an audti tabel in my database. The code works great, excep…

  vareck.walla

  4 replies

  17 years, 5 months ago

  By: Garadin

• how to pull specific report or all report at one time

  TABLE BO DDS BOCLEARED BOCLEAREDDATE BO 1 1/1/2009 BO 2 …

  josephptran2002

  1 replies

  17 years, 5 months ago

  By: The Dixie Flatline