T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Can a select statement be used to parse the results of a stored procedure ?

  Hi all, If I exec an sp, I see my results table in the query analyser. But could I do this (or some…

  greg.bull

  1 replies

  14 years, 3 months ago

  By: LutzM

• How to update a column to the result of a Geocoding function

  I have a table of houses with addresses, which I eventually want to plot in a Report. I managed to…

  pietlinden

  5 replies

  14 years, 3 months ago

  By: pietlinden

• DATETIME data type subtraction

  I have a create_timestamp and modify_timestamp that are datetime data types. I need to find the dif…

  SQL_Enthusiast

  6 replies

  14 years, 3 months ago

  By: SQL_Enthusiast

• Having trouble tuning a large update query...looking for advice...

  I was asked to find out why a update is taking longer on a new (upgraded) server Old server (wind…

  Leeland

  19 replies

  14 years, 3 months ago

  By: Leeland

• To detect dead lock exists?

  Hello Friends, I am facing a challenge to develop an algorithm in T-SQL. Algorithm Logi…

  rockybhai

  13 replies

  14 years, 3 months ago

  By: Gail Shaw

• create a constraint over 30 columns to have a Unique combination

  hello i have a table with over 60 columns, and i have to implement a constraint on this data set wh…

  Nicolas BrainPowered.Net

  5 replies

  14 years, 3 months ago

  By: Nicolas BrainPowered.Net

• Getting two different rows as columns

  Hi, I'm having some trouble in getting some results. Here is my issue. I got two Tables, CREATE TAB…

  tripri

  12 replies

  14 years, 3 months ago

  By: siva 20997

• Incrementing a table name

  I have a sql server table named raw17. Is there a way to create a new table that increments the nu…

  gary.morey

  23 replies

  14 years, 3 months ago

  By: davidandrews13

• how to properly put variable into SQLString

  Hello, could anybody help. I would like to know how to properly put variable(@dat1) into SQLString…

  peter478

  13 replies

  14 years, 3 months ago

  By: R.P.Rozema

• DElete Duplicates

  Hi, I have duplicates in my table A VehicleID Timestamp CardNum CompanyName CANum Link C…

  PSB

  5 replies

  14 years, 3 months ago

  By: Dwain Camps

• Changing the auto-number/incremented value (not setting it back to 1)

  I have a table with 39+ million rows. Earlier today a developer who "plays" around with this table…

  MyDoggieJessie

  4 replies

  14 years, 3 months ago

  By: R.P.Rozema

• how to add the primarey key constraint in existing table

  Hi Friends, create table pkcon (id int,name varchar(20)) -- here i'm trying to add the primary key …

  sandeep4testing

  3 replies

  14 years, 3 months ago

  By: sandeep4testing

• Creating all possible combinations of two numbers of two columns without recursion or repeatation.

  I have got two columns. I need to create a possible combinations out of it without recursion. (Cros…

  rockybhai

  6 replies

  14 years, 3 months ago

  By: Sean Lange

• update multiple rows with subquery that use EXCEPT

  Hi, I'm writing a script that will update selected multiple rows of records I got from my EXCEPT se…

  ladyblue1075

  4 replies

  14 years, 3 months ago

  By: ladyblue1075

• Updating Across a Partitioned View

  This post concerns updating across a partitioned view, and not unlike others about this subject I’m…

  YogaMatt

  3 replies

  14 years, 3 months ago

  By: spaghettidba