T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Simple conversion to 2 decimal places

  Hi, I have a pretty simple conversion that I can't quite get to work properly. I have two columns …

  Isabelle2378

  1 replies

  14 years, 9 months ago

  By: Isabelle2378

• is UNION ALL inherantly slow?

  Hi, We're trying to import data from CSV files into a SQL Server database. I REALLY REALLY want to …

  BenWard

  7 replies

  14 years, 9 months ago

  By: TheSQLGuru

• how grab text before a "-" character in a join

  I am doing a select query, and trying to join in another table where the common field in one table …

  spikenology-616218

  8 replies

  14 years, 9 months ago

  By: drew.allen

• Need some help with query taking forever

  Here is my query ********************************************************************* ;with qtysol…

  Michael T2

  8 replies

  14 years, 10 months ago

  By: Jeff Moden

• Row transpose

  Need help on t-sql query which turns rows into columns. DML and DDL as follows: Create Table #Test…

  NewBeeSQL

  6 replies

  14 years, 10 months ago

  By: Jeff Moden

• Alternative method to a Trigger needed

  Hi, I have 3 synchronised databases (Live, Pre-Production and Test). The tables are updated periodi…

  DerbyNeal

  5 replies

  14 years, 10 months ago

  By: tyson.price

• Insert a Parent and Child record in one statement

  I have two tables one a parent and one a child. I have a web service that I am receiving data from …

  Lee Hopkins

  2 replies

  14 years, 10 months ago

  By: GSquared

• Julian time conversion problem

  Hi all--I have a problem where I am trying to concatenate two fields: - a date time field called [s…

  Jon V

  8 replies

  14 years, 10 months ago

  By: Jon V

• FIX LENGTH

  I need to create a fix length file for a customer, but I ran into a for you guys a small issue, whe…

  Maique

  4 replies

  14 years, 10 months ago

  By: ChazMan

• Creating 2 Rows from 2 fields currently in the same row.

  Hi All, Hope you can help me over a brick wall I've come up against! I currently have 1 row per acc…

  WardyWonderland

  2 replies

  14 years, 10 months ago

  By: WardyWonderland

• Kindly explain the case query.

  Hi, Actually i got this query from net. Below one is query. select sum(convert(bigint,case when s…

  KMPSSS

  5 replies

  14 years, 10 months ago

  By: john.arnott

• I have to export data from sql server 2005 to predefined (columns and rows )excel(.xlsx) format using script using ssis(Script Task) OR ANY SIMPLE Method

  Database :Adventerworks Table 1: HumanResources.Department Table 2: HumanResources.Employee H…

  shashi24365

  2 replies

  14 years, 10 months ago

  By: EdVassie

• Concatenating numeric fields

  Hi I need to concatenate the following (which executes a function to select the financial year from…

  Canazei65

  6 replies

  14 years, 10 months ago

  By: Canazei65

• Location of master..function/sp

  Hi I have to trace a query.There is a function which calls another, which says "EXEC master..xp_epo…

  prady_1988

  4 replies

  14 years, 10 months ago

  By: Paul White

• HOW to Sum The Coloumn

  Hi i have an error while selecting the data for a char i have a table with projectid -datetime,logi…

  catchkkarthi

  5 replies

  14 years, 10 months ago

  By: diamondgm