T-SQL

• Topics

  Started by

  Posts

  Last post

• selecting result of a dynamic sql query into a variable

  im executing this as dynamic sql   Select @SQLCommand ='Select count(*) from '+ ltrim(rtrim(…

  winston Smith

  9 replies

  20 years ago

  By: Andreas AJV

• Returning custome list of values with sequence no

  Hi All (SQL Server 2000) I am trying to return a list of departments under which are the appropriat…

  Charlottecb

  2 replies

  20 years ago

  By: Jeff Moden

• varchar and nvarchar data types

  Hi all I want to know the difference between varchar and nvarchar data types Thanks

  Vijay Soni

  1 replies

  20 years ago

  By: chisholmd

• How to call a web service from T-SQL in SQL Server 2000?

  I have searched this site and done a Google search but without any results. Short of writing my own…

  Mark Harrison-282986

  2 replies

  20 years ago

  By: chisholmd

• replacing all code problem

  Hello group ! Can you help me to resolve this issue? After I ran SQL Server 2005 upgrade advisor&n…

  Mark Gorelik

  3 replies

  20 years ago

  By: Mark Gorelik

• Repeat Header info in first row of a combined Header/Lines view or table

  Hi All, Having difficulty trying to figure this one out. I need to create a view or another table f…

  jake greene

  2 replies

  20 years ago

  By: jake greene

• Qry Help

  I am using sql server 2000 I need some help with the following query CREATE TABLE TBL ( col1 SMALLI…

  rachel haez

  1 replies

  20 years ago

  By: Vladan

• How to Retrieve the columns...

  Hi,        Here is my query ,      I have a table with…

  Bagath

  11 replies

  20 years ago

  By: Bagath

• How to use Sum or Average function with joins (Left Join) in select query stored procedure

  Hi Friends, Please help me in solving this query. I want to use sum function with joins (left join)…

  Swapnil S Palande

  9 replies

  20 years ago

  By: Swapnil S Palande

• Insert missing records

  Hi, Ive messed up some data in a table but luckily I had it backed up. However I need to reinsert t…

  Andy Knight

  2 replies

  20 years ago

  By: Andy Knight

• Finding the size of the file

  Hi ALL ! From within a stored procedure I have to find out the size of a particular file.…

  Rajesh Kumar Singh

  2 replies

  20 years ago

  By: Rajesh Kumar Singh

• update many tables(Give tables'' names as parameters)

  Hi all How r u? i have many tables have same columns and i want write one procedure with parameter…

  najeeb selk

  2 replies

  20 years ago

  By: David le Quesne

• multi table insert statement

  Hi all, I am having trouble inserting data into multiple tables in my application. I have a table J…

  Daniel-253435

  7 replies

  20 years ago

  By: Sergiy

• Help concat strings with a money column

  I need some advice on this one............. I want to concatonate a bunch of fields to be one field…

  Jeff-132889

  8 replies

  20 years ago

  By: Jeff-132889

• Join Dissimilar Tables - Reporting

  Hi All,  I have two dissimilar tables, what I mean by this is there is no data in either table…

  Jim Mraz

  6 replies

  20 years ago

  By: Jim Mraz