T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Specify primary key with varchar.. is it OK? and how??

  hi, i'm new here.. i just want to ask you how to specify primary key?? for example : T code is for …

  alchemy_nator

  1 replies

  11 years, 1 months ago

  By: Ed Wagner

• CROSS APPLY and Invalid Object Name

  Hi all, I am having some trouble with a cross apply and a scalar function. Here is my code: declare…

  petitpere

  7 replies

  11 years, 1 months ago

  By: ChrisM@Work

• Better way of detecting the presence of a criteria but absence of one which meets requirements?

  Subject is probably not the most clear, so I'll try to explain better. Basically, I have a table wh…

  kramaswamy

  6 replies

  11 years, 1 months ago

  By: kramaswamy

• Arithmetic overflow error converting varchar to data type numeric.

  It is very strange I get this error when I run the query but then it goes away after a few minutes?…

  scottgr21

  3 replies

  11 years, 1 months ago

  By: kramaswamy

• Comparing Rows in same table

  I have a table with 4 columns. EmpName PayDate WageType PayRate ABC 10/22/2014 Regula…

  balushanmugham

  5 replies

  11 years, 1 months ago

  By: kramaswamy

• -dynamic- function to convert several rows of a table to a csv list

  Hi all, I'd like to convert several rows of my table to csv list create table my_contracts( custo…

  smerg

  17 replies

  11 years, 2 months ago

  By: suzman

• Chinese chars issue in T-SQL

  Hi All, I have problem with chinese characters in TSQL. If I excute following code block, it displa…

  rajg

  4 replies

  11 years, 2 months ago

  By: Ed Wagner

• parse comma-delimited list into seperate columns

  Not exactly sure how to go about this. I am selecting a few fields from a table. One of the field…

  is250sp

  40 replies

  11 years, 2 months ago

  By: hoa.nguyen 64423

• Using ORDER BY in a query returns more rows than if ORDER BY is not used

  Hi all, I'm encountering a strange situation with SS2K5. I'm running a query joining two tables wit…

  George Camilleri

  7 replies

  11 years, 2 months ago

  By: Jack Corbett

• SELECT lento en una tabla de 9000 filas

  Hola, tengo el sgte inconveniente con una tabla de 9000 filas, la cual en teoria no es una tabla gr…

  sistemas_casinomnes

  5 replies

  11 years, 2 months ago

  By: Luis Cazares

• temporary table in a stored procedure

  I want to use the same temporary table in a stored procedure where I insert different data in funct…

  antonela

  8 replies

  11 years, 2 months ago

  By: Ed Wagner

• Need help on a query in SQL 2005

  I have the following table called "test": CREATE TABLE test ( call_state tinyint, call_type tinyint…

  dcw8888

  3 replies

  11 years, 2 months ago

  By: Luis Cazares

• sp_replmonitorhelpsubscription works in SSMS but not using T-SQL

  I can run the following in SSMS and get data: exec sp_replmonitorhelpsubscription @publisher='p…

  jslusher

  5 replies

  11 years, 2 months ago

  By: SQLRNNR

• SELECT HOST_NAME() in a stored procedure called from C++ program is returning spaces

  I want to use the HOST_NAME() system variable in a stored procedure to get the name of the machine …

  Tom John-342103

  1 replies

  11 years, 2 months ago

  By: Gail Shaw

• Read XML Input into table

  Hi , I am using following code to read xml input to table . I am not sure what I am doing wrong, I …

  thbaig

  3 replies

  11 years, 3 months ago

  By: Eirikur Eiriksson