T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Multiple Part Descriptions

  I have a table that contains part numbers with multiple descriptions. Any know of an easy way to id…

  bpowers

  7 replies

  14 years ago

  By: vinu512

• How to Reindex only tables with more than 1000 records

  Hi, I was wondering if there is a way to Re-index only the tables in my database that have more tha…

  Mias12

  4 replies

  14 years ago

  By: Mias12

• Can two user access single table in SQL?

  Hi guys, I know its simple question and i can google it but i would like to know your though about…

  rocky_498

  6 replies

  14 years ago

  By: rocky_498

• How to transfer data from one column to another. Please help.

  Note: The title of this forum is (I can not change the title anymore 🙁 ) How to transfer data (from…

  marksquall

  8 replies

  14 years ago

  By: marksquall

• API Cursors

  Hi - We have a user complaining about a specific action, which I have managed to capture, please se…

  Kwisatz78

  4 replies

  14 years ago

  By: Kwisatz78

• Disk space when varchar to nvarchar change

  How do write a query to figure how much more disk space i will need when i change all my column fro…

  khushbu

  15 replies

  14 years ago

  By: Ed B

• service account logins

  Hi Team, service account logins and corresponding users with roles and permissions on each databas…

  shiv-356842

  3 replies

  14 years ago

  By: chrisfradenburg

• Trace a particular sp

  how to trace a particular sp in sql. tell me step by step

  riya_dave

  6 replies

  14 years ago

  By: Grant Fritchey

• get local variable value

  if(@qtd is null) begin --------------------------------------------------------- ------quaterto…

  riya_dave

  11 replies

  14 years ago

  By: Mark Fitzgerald-331224

• Remove trailing space from a field

  Hi all, I have a function that is supposed to trim a column then remove any trailing space. This fu…

  SceloM

  13 replies

  14 years ago

  By: SceloM

• how to get latest last week dates from the given date

  Hi, Let say we have given some dates in our table. the structure is as below CREATE TABLE [dbo].[da…

  rajn.knit07

  7 replies

  14 years ago

  By: Dwain Camps

• Dynamic sorting; ASC VS DESC

  Hello All, Can I dynamically sort ascending or descending using a parameter. I'd like my users to s…

  Chrissy321

  13 replies

  14 years ago

  By: Evil Kraig F

• Get Geometric Mean for all the records

  Hi, All Need Help input: declare @t table ( val numeric(18,6), rownumber numeric(18,6) ) insert i…

  phani.gudmines

  13 replies

  14 years ago

  By: CapnHector

• Occurrence count

  Hi, I have the following table and data. I want to make a count on each brand such that for each re…

  oolawole

  25 replies

  14 years ago

  By: oolawole

• Select a set of Maximum (or minimum) values with a associated data

  I have 3 fields. ProductCode,Date, and Value so for every product code I have multiple dates with …

  siva 20997

  4 replies

  14 years ago

  By: Andy Hyslop