T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Convert non-cluster primary key to cluster unique

  Hi, i have following script which i am planning to run to drop all non-clustered primary keys on a…

  Shahzadi

  8 replies

  11 years, 4 months ago

  By: Cadavre

• Need help or sugesstion on Implementing Full Text search or universal search facility in website.

  Hello, I have a question as well as confusion regarding how to implement a universal search in my s…

  nids

  2 replies

  11 years, 4 months ago

  By: nids

• How to show multiple values in my column of my join query ?

  Hi Friends, Hi Friends , in my table i ve the column of item code which contains '1000' ,'2000' …

  raghuldrag

  1 replies

  11 years, 4 months ago

  By: spaghettidba

• How to show ed,cess in my query?

  Detail: ------- create table detail ( grn_no varchar(55), po_no varchar(50), vendor_no numeric(10,2…

  raghuldrag

  4 replies

  11 years, 4 months ago

  By: Eirikur Eiriksson

• Advance script help. Second Saturday following month?

  I need to create two scripts and I'm not sure how to do this. IF CreateDate = Yesterday InvoiceDate…

  stevemr68

  7 replies

  11 years, 4 months ago

  By: Luis Cazares

• Compare two varchar for similarities

  Hi Gurus I am asked to compare the address fields (three columns of nvarchar(100) ) of a customer d…

  meelan

  5 replies

  11 years, 4 months ago

  By: Ed Wagner

• query challenge: add a new column to data set at runtime that tallies whenever a condition arises

  I am trying to find a way to provide three metrics for a table that only provides 2 of them. I need…

  KoldCoffee

  4 replies

  11 years, 4 months ago

  By: Gazareth

• Query Help

  Hi all, please help me in get the desired output: DDL are here: Create table table1 ( ID int, nam…

  kapil_kk

  4 replies

  11 years, 4 months ago

  By: Koen Verbeeck

• Returning stored procedure results into a CTE or temp table?

  Hi all . . . Is it possible to return the results of a stored procedure into either a CTE or temp t…

  Ray K

  13 replies

  11 years, 4 months ago

  By: cmerrell

• Need help with a query that contains Aggregate

  I have two tables. From the first table i need DISTINCT license_number, and last_renewal_date wher…

  apache626

  3 replies

  11 years, 4 months ago

  By: MMartin1

• query to show only top or main team for team member

  I was wondering if anyone can help with a query I need for a larger series of reports I am working …

  Brian Ward

  3 replies

  11 years, 4 months ago

  By: Matt Miller (4)

• Error formatting query?

  Hi Error Messages, Could you help me. how to resolve this error? purpose of script email sending wh…

  SQL Galaxy

  4 replies

  11 years, 4 months ago

  By: Chris Harshman

• Finding total execution time

  I have a SP SPone. i have optimized that and kept it as SPone_Optimized. i would like to test the b…

  SqlStarter

  11 replies

  11 years, 4 months ago

  By: SqlStarter

• Pattern Matching SQL

  Can someone help me to extract values from the following sample data using Pattern Matching? Create…

  rka

  2 replies

  11 years, 4 months ago

  By: Eirikur Eiriksson

• Help needed in resolving the below SQL

  Declare @new table (employee_id int, invoice_date datetime, invoice_id int, invoice_amount money )…

  grkanth81

  5 replies

  11 years, 4 months ago

  By: pietlinden