T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Resolve Collation Conflict problem in T-SQL (SHUBHAM SAXENA)

  Hello Friends, I want to alter my table column collation to do such task when i run ALTER TABLE Ci…

  shubham.saxena67

  7 replies

  14 years ago

  By: Ant-Green

• Passing Parameter To Stored Procedure To Retrieve Records From a Linked Server

  Hello All! I have a Linked Server that connects to an Oracle database I wanted to create a stored p…

  Ronnie Jones

  3 replies

  14 years ago

  By: Orlando Colamatteo

• Using the @@servicename variable within a SQL Server agent job

  I have been trying to use this line within my job so that the directory name (corresponding to the …

  farmkittie

  10 replies

  14 years ago

  By: farmkittie

• need help to customise my T-SQL

  My tables and data as following, USE [myTest] GO /****** Object: Table [dbo].[selectedApplicant] …

  Qira

  27 replies

  14 years ago

  By: WayneS

• Finding time between 2 dates considering working hours

  Hi All. I have a scenario in which i need to calculate the time consumed by the user to do a task. …

  Jankhana

  6 replies

  14 years ago

  By: mtassin

• Aggregating counts and getting cumulative counts by date

  Hi, I need help in building a query that returns a cumulative count for a specified date range. For…

  josetur12

  7 replies

  14 years ago

  By: Lynn Pettis

• Calculation for severity of stock shortage

  I have the following data and want to score it based on how severe the shortage is. PRODUCT, LEAD_T…

  Kelvin Phayre

  1 replies

  14 years ago

  By: Eugene Elutin

• find different rows in tables

  i've started the search for different rows in two tables but I'm not sure how to complete the remai…

  wmaa

  33 replies

  14 years ago

  By: Sean Lange

• Who has select / execute permissions on objects

  Hi All, Does anyone have a nifty script or a scripted way to see what permissions a login (windows…

  Loundy

  4 replies

  14 years ago

  By: Loundy

• please give me a solution for this request

  sir i have a table values like this 10 null null null name null null null hyd.. then i want to get …

  anil.janu143

  16 replies

  14 years ago

  By: CapnHector

• a ridiculous data problem

  I face a ridiculous data problem. Technically it is not complex but it is so ridiculous and new fo…

  dglane

  7 replies

  14 years ago

  By: Evil Kraig F

• covering indexes

  If I have a table section sectionid, sectionname,parentsection,sectionstatus,deleted sectionid is m…

  Sarsoura

  4 replies

  14 years ago

  By: Lynn Pettis

• add a total column to a pivot table

  Please I need help I have the following tables assessment (assessmentid,sectionid,assessmentitle,ma…

  Sarsoura

  1 replies

  14 years ago

  By: Sean Lange

• subquery vs scalar functions

  performance wise which is better subquery or scalar function

  Sarsoura

  5 replies

  14 years ago

  By: TheSQLGuru

• Pivot table problems

  I have a column called update_source in my table that I want to pivot on. I want to make sure that…

  Matthew Cushing

  5 replies

  14 years ago

  By: Kingston Dhasian