T-SQL

• Topics

  Started by

  Posts

  Last post

• Please help to sort this

  I have a table like Column1 ------- 1-greend=asjnlkj 3-red=jljlkj 2=green<79 2-yellow>90 2-r…

  ss.meghana8

  10 replies

  11 years, 9 months ago

  By: ChrisM@Work

• CASE Statement multiple aurgument

  Hello, I searched online and this forum and I am not convinced that I find the solution. I am tryin…

  Sanjeev Jha-475652

  2 replies

  11 years, 9 months ago

  By: Sanjeev Jha-475652

• Linked server query error

  I had setup linked server and when i query the it gives me below error. QUERY: SELECT top * from […

  psred

  4 replies

  11 years, 9 months ago

  By: psred

• Need help in complex query/subquery

  May be its not complex for many experts, but I don't know how to write it in SQL 2K. Here is my tab…

  mak101

  15 replies

  11 years, 9 months ago

  By: yakantr

• Union query to temp table

  Hi all, I've written a union query to extact data from our ERP solution but want to write this into…

  s.green

  5 replies

  11 years, 9 months ago

  By: samjoseph_p

• Data from Previous Row_2

  I would like an efficient way to "fill missing data". My preference would be a view. I have data li…

  Mike Osborne

  10 replies

  11 years, 10 months ago

  By: Mike Osborne

• insert twice seems to pick up new id

  I have a SP that is creating two new records that are copies of the original (so I get three near i…

  nick 91670

  8 replies

  11 years, 10 months ago

  By: nick 91670

• Query help Pivot and Sum

  Hi, Using SQL Server 2000 : create table test ( group_name varchar(30), name varchar(30), add1 varc…

  gksharmaajmer

  3 replies

  11 years, 10 months ago

  By: gksharmaajmer

• Query help: OUTER JOIN with GROUP BY clause

  I am querying two tables: tblPurhcaseOrders - holds purchase orders with various columns, one of wh…

  yuvalherziger

  2 replies

  11 years, 10 months ago

  By: Mohit Dhiman

• LIKE - finding ']' or '.' in data

  Hi, In the code below I am trying to find all of the values with '.123' or ']123' within them. Obv…

  andrew.manning

  5 replies

  11 years, 10 months ago

  By: Mohit Dhiman

• Limitation of Varchar 8000 in executing a dynamic MDX inside stored Procedure

  I have a Stored Procedure in SQL 2000 which build a Long MDX query .Then i connect to OLAP and &nbs…

  shagarwal

  9 replies

  11 years, 11 months ago

  By: kobust

• Help getting a count by consecutive groups

  I am hoping someone can help me figure out a solution to a TSQL problem I have. I have data that i…

  aadkins 91421

  2 replies

  11 years, 11 months ago

  By: aadkins 91421

• comparing two string

  Any suggestion on below: I need to compare two strings which have comma separated ISO Country code…

  mailtoashokberwal

  1 replies

  11 years, 11 months ago

  By: Lowell

• Maximum Number of "When Then" lines in a CASE statement?

  Does anyone know if there's a maximum number of "When xxx THEN yyy" lines you can have within a sin…

  Roger Abram

  7 replies

  11 years, 11 months ago

  By: Lowell

• Conversion failed when converting the varchar value '98.97%' to data type int.

  Hi guys, I need your help. I am receiving the following error from the set @percent line "Conversi…

  joey6401c

  8 replies

  11 years, 11 months ago

  By: joey6401c