T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• ORDER BY with one entry out of order

  I have a field I need to order alphabetically, but I want one of the entries to be at the top no ma…

  Noc234234

  5 replies

  13 years, 8 months ago

  By: SQLRNNR

• Else part of If Else statement doesn't work

  I need to bridge versions of SQL Server because I have to support versions from 2000 through 2008. …

  Stamey

  7 replies

  13 years, 8 months ago

  By: kramaswamy

• ANSI_NULLS setting is ignored?

  I'm setting the ANSI_NULLS setting for a query explicitely to "ON". But execution plan properties s…

  e-ghetto

  8 replies

  13 years, 8 months ago

  By: e-ghetto

• I'm stumped on a concatenation problem

  I have the following: create table #tmp1 (IDKEY INT IDENTITY, div nvarchar(3), ID nvarchar(10), Las…

  kdfischer

  9 replies

  13 years, 8 months ago

  By: ACinAZ

• SQL Server Functions

  Hi, i have a scalar valued function 'split_string'. i want to check it either it is working or not?…

  MuhammadShafiq

  2 replies

  13 years, 8 months ago

  By: MuhammadShafiq

• Problem in Distinct Query

  Dear Sir, I am in great trouble, I have a table which contain 100 fields. I want to distinct on fir…

  deba_20032004

  2 replies

  13 years, 8 months ago

  By: Grant Fritchey

• insert DateTime issue

  I have a table with 3 columns: Id (int, identity), start_dtime (datetime) and end_dtime (datetime) …

  rothj

  15 replies

  13 years, 8 months ago

  By: Sean Lange

• subqueries help

  hi. can someone help me figure out why this isn't working? i read the MSDN page on subqueries to …

  justintime

  6 replies

  13 years, 8 months ago

  By: Sean Lange

• Need verification on this matter

  hey guys, need help on this one. I have a .net application, On sql side,Is it much faster to execut…

  Teemo

  12 replies

  13 years, 8 months ago

  By: Andre Guerreiro

• Negative number results

  I am trying to add a column to a simple select list that is derived from arithmetic on two other co…

  Dan Tuma

  4 replies

  13 years, 8 months ago

  By: Sean Lange

• UNION or other way to extract data?

  Hello, I have one table with data: transaction_id type 1 ____________ A 1 ____________ B 2 _______…

  branovuk

  8 replies

  13 years, 8 months ago

  By: branovuk

• Query question

  This should be simple (but maybe not) but I have a complete block! Here is a simple example of what…

  slimchance99

  3 replies

  13 years, 8 months ago

  By: Sean Lange

• Needed help to convert column as row values

  Can someone pls help out. I have a problem that i would need some assistance. i have a table as men…

  veenavidyakaran

  6 replies

  13 years, 8 months ago

  By: spaghettidba

• how to get table name as input parameter in SQL procedure

  Hi I am using follwing query for creating and inserting a table through a procedure.. Alter PROCEDU…

  nikki_d

  2 replies

  13 years, 8 months ago

  By: nikki_d

• How to loop columns of dynamic temporary table which is created inside storedprocedure in sql server 2005

  Hi all, Please can anybody help me to loop columns of dynamic temporary table which is created insi…

  udaybaskar444

  1 replies

  13 years, 8 months ago

  By: LutzM