T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Need to add buffer records into a CSV files to provide filler between gaps in record IDs

  I have a CSV file that contains about 2,000 customer accounts. Unfortunately, the Customer IDs do n…

  fawadafr

  1 replies

  13 years, 7 months ago

  By: Orlando Colamatteo

• Syntax - Open Query - JOIN Linked Server Table with SQL Server Table

  I need to JOIN information from the following Linked Server Table to a Table named Mytable in a SQL…

  Welsh Corgi

  12 replies

  13 years, 7 months ago

  By: Welsh Corgi

• Converting Date for reporting by Year/Month or Year/Q

  This has got to be easy.. I just can not seem to find how to do .. used Google. Looking to take a d…

  dwilliscp

  3 replies

  13 years, 7 months ago

  By: Rob Schripsema

• Job Category

  Does anyone know where MS is storing the Job Category Name? So I could link to the table and conver…

  dwilliscp

  2 replies

  13 years, 7 months ago

  By: Geoff A

• Delete duplication with where clause condition

  Hi, I want to delete those employees who have at least 02 marital status and their first marital st…

  iBar

  39 replies

  13 years, 7 months ago

  By: Lynn Pettis

• Using COALESCE Statement And Char(13)

  Hi, I'm working on a procedure where a list of unpaid members will appear in a single field with v…

  Roger Abram

  7 replies

  13 years, 7 months ago

  By: Roger Abram

• why does sqlserver not like the value: 2 ? ? ?

  OK guys this is the weirdest thing I have ever seen in SQL Server. I have a stored proc 15000 lines…

  BenWard

  8 replies

  13 years, 7 months ago

  By: Robin Sasson

• SQL Server not using connection Login

  One of our SQL servers has started rejecting our SQL statements from SQL Server Management Studio, …

  dwilliscp

  2 replies

  13 years, 7 months ago

  By: dwilliscp

• Quering with "google-style" operators

  Hello everyone, A customer asked for a system change allowing a specific varchar field to be querya…

  marcelo.magri

  10 replies

  13 years, 7 months ago

  By: marcelo.magri

• Insert values from array into a table

  Hi, Is there a way in SQL Server 2005 to achieve this? declare @array varchar(2000) set @array='32…

  Santhoshkumar KB

  8 replies

  13 years, 7 months ago

  By: Sean Lange

• Querying against horizonal partitioning using a variable.

  I'm noticing a problem with optimising my queries vs a horizontal partition and was wondering if an…

  Ben-425648

  13 replies

  13 years, 7 months ago

  By: Ben-425648

• How to update a table

  Hi guy i have a problem when i update a data may one of can help me. since this morning i try to fo…

  inf1154

  3 replies

  13 years, 7 months ago

  By: GSquared

• Row Number

  I want to add a row number at the bottom of my table on SSRS what is the code for it?

  joseph_smithy-1130150

  14 replies

  13 years, 7 months ago

  By: abidaht

• Problem with JDBC Queries ??

  HI All, These queries taking more cpu time and running frequently , can any one have idea on these…

  Lavanyasri

  12 replies

  13 years, 7 months ago

  By: Summer90

• Can you have a non-aggregate field?

  I have a table which I am trying to sum. Simple enough. Field - Project Field - Item Code Field - …

  Ken at work

  9 replies

  13 years, 7 months ago

  By: Ken at work