T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Help Needed to Convert Numeric Value to CHAR(7)

  I have to store the result of a calculation in a column of type CHAR(7) (and am unable to change th…

  samp.silvercreek

  6 replies

  11 years, 5 months ago

  By: Eirikur Eiriksson

• Openquery running very slow

  I have a MySql Database i need to extract data from based on matching info in a local SQL Server da…

  TryingToLearn

  4 replies

  11 years, 5 months ago

  By: Ed Wagner

• Nested stored procedure

  Dear All, I really need your help on this, i am calling stored procedure called GetCommonItemCount …

  nadersam

  9 replies

  11 years, 5 months ago

  By: nadersam

• having trouble changing varchar to datetime

  Not sure what I'm missing, but I can't get a varchar to datetime conversion to work. The varchar d…

  Denise McMillan

  7 replies

  11 years, 5 months ago

  By: Luis Cazares

• Slow query performance extracting large tables from off-site linked server

  I know that this scenario is going to inherently be slower than anything done locally, but my optio…

  bantrim

  3 replies

  11 years, 5 months ago

  By: ZZartin

• Seems like a simple problem. Need to decrease an Amt by a fixed maximum spread over several rows.

  I have an issue where I have multiple rows of data and I need to reduce a dollar amount by a fixed …

  Mountain Steve

  3 replies

  11 years, 5 months ago

  By: Mountain Steve

• How can I cut certain values in a strig to separate columns

  I have a column containing values for different languages. I want to cut out the values per languat…

  Steve Kinnaman

  14 replies

  11 years, 5 months ago

  By: Steve Kinnaman

• Assign next aviliable column values

  Hi Friends, Please find below object and data: create table #StuDetails(City varchar(25),StuStatus …

  abhas

  2 replies

  11 years, 5 months ago

  By: CKX

• Query Help

  Good Morning, I am trying to figure out a method to check if the values in 3 columns are the same. …

  mbrady5

  2 replies

  11 years, 5 months ago

  By: mbrady5

• Help needed in Date Logic

  Hi I am working in sqlserver 2008 R2 and below is my sample research query i am trying to get prev…

  KGJ-Dev

  6 replies

  11 years, 5 months ago

  By: serg-52

• concatenate with leading zeros

  Hi Everyone I am creating a view which involved concatenation of 2 int columns. The data in the …

  Johnny H

  36 replies

  11 years, 5 months ago

  By: Eugene Elutin

• Calculate 90 days and 3 Years agon from an Effective Date in a table?

  What would be the most straight forword to Calculate 90 days and 3 Years ago from an Effective Date…

  Welsh Corgi

  6 replies

  11 years, 5 months ago

  By: Welsh Corgi

• Linked Server to AS400 Error Null Value

  I have a Stored Procedure that uses an Open Query to load a SQL Server Table. This is the Open Quer…

  Welsh Corgi

  6 replies

  11 years, 5 months ago

  By: Welsh Corgi

• Cannot define primary key constraint on nullable column but column not null

  We have a database where many tables have a field that has to be lengthened. In some cases this is …

  Kev Wisbey-443237

  2 replies

  11 years, 5 months ago

  By: Kev Wisbey-443237

• SubstringIndex

  Hi, Can someone guide me on the best possible way to remove all the characters after a 3rd repetiti…

  SQLMan1

  4 replies

  11 years, 5 months ago

  By: Alan Burstein