T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• SQL 2005 Transaction Failure without Exception Thrown

  Hope I got the right forum for this issue .. We have a VB.Net application (visual Studio 2008) that…

  derek.m

  4 replies

  15 years, 5 months ago

  By: derek.m

• Trying to use parameters in INNER JOIN statement

  I'm calling the stored procedure from a web application and passing a parameter (@agenttype varchar…

  jaroberts27

  1 replies

  15 years, 5 months ago

  By: Gail Shaw

• How to pivot this data ?

  Hi All, I have a score table where different parameters and scores are kept. Please see the sample …

  SQL Kidu

  5 replies

  15 years, 5 months ago

  By: ColdCoffee

• How to add column, update data, and alter in if statement?

  I have an existing table with rows. I need to: 1. add a column. 2. set values of that column 3. …

  dirtrider

  9 replies

  15 years, 5 months ago

  By: scott.pletcher

• IF EXISTS statement very slow

  Sorry for the lack of DDL. It complicated... Since I am not providing DDL all speculation welcome. …

  emily-1119612

  16 replies

  15 years, 5 months ago

  By: emily-1119612

• Registering sqlserver instance

  I have management studio installed on my machine and I have registered all the servers on my compan…

  sql_novice_2007

  3 replies

  15 years, 5 months ago

  By: sql_novice_2007

• Swapping Rows to Columns

  I have been studying Pivot, but don't see a way to use that for my goal. Please correct me if I am …

  Stamey

  9 replies

  15 years, 5 months ago

  By: Stamey

• TSQL

  Hi , i need to create a trigger that needs to be fired on a table when that table is idle for two…

  Suresh Babu Palla

  12 replies

  15 years, 5 months ago

  By: scott.pletcher

• Best Practice to Track Changes/New Records

  Hey All, I need to come up with a reporting solution in SSRS to report on specific products that ha…

  latingntlman

  5 replies

  15 years, 5 months ago

  By: Ron McCullough

• Nested CASE query issue

  By using the query below I'm getting 3 kinds of productStatus results: "Upgrade_Year", "NULL" or "U…

  ss_nl

  10 replies

  15 years, 5 months ago

  By: ss_nl

• DateTime Culture Swedish Format???

  Hi, How can I use the format the date time to swedish is there any table and examples for this? I ´…

  mustapha-721538

  1 replies

  15 years, 5 months ago

  By: Pulivarthi Sasidhar

• Function in Pivot CLause

  hi, I m using Pivot in my query to generate the columns as [Code] Select * from Table PIVOT ( SU…

  honey47

  1 replies

  15 years, 5 months ago

  By: ColdCoffee

• Error rate calculation

  Hello everyone, how have you been? I have some problems with the following, I am trying to execute …

  Eduardo Gutiérrez

  2 replies

  15 years, 5 months ago

  By: Eduardo Gutiérrez

• Store Procedure

  Hi, How can i write the store procedure which takes input parameter? SELECT RM.RName, RM.Logo,…

  poratips

  3 replies

  15 years, 5 months ago

  By: poratips

• Custom Count - TSQL Query

  I need a query to find the count of available agents by month. Please see below for the source tabl…

  UnionAll

  2 replies

  15 years, 5 months ago

  By: UnionAll