T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Grouping delima...I think

  I have a select statement that looks something like this - sorry it's so long: /*ALTER VIEW [dbo].[…

  David Justice

  1 replies

  13 years, 4 months ago

  By: GSquared

• how to convert datetime into '25th January' format

  How to convert date '1978-01-25 00:00:00.000' into '25th January' format? The 'th' or 'rd' can be s…

  Ganeshkumar005

  5 replies

  13 years, 4 months ago

  By: Ganeshkumar005

• Trying to Add Job Schedule Using T-SQL

  We have several jobs that we run once per month for month end finance closing. At this time we are …

  ducksql@gmail.com

  2 replies

  13 years, 4 months ago

  By: ducksql@gmail.com

• CASE statement

  Hi, I'm working with INFORMATION_SCHEMA.COLUMNS. I want to select the DATA_TYPE and CHARACTER_MAXI…

  adb2303

  4 replies

  13 years, 4 months ago

  By: adb2303

• how to group my results

  here is the structure of my table CREATE TABLE [dbo].[duplicate2]( [id] [int] IDENTITY(1,1) NOT NU…

  klineandking

  23 replies

  13 years, 4 months ago

  By: drew.allen

• dynamic column list building is giving problem

  Hi, Iam facing an issue with dynamic column list building. It is working fine in my DEV server but …

  pvsrpk

  6 replies

  13 years, 4 months ago

  By: pvsrpk

• Cannot remove blank espace

  Hello comunity I have a table where my field CCT is varchar(20), but on my desktop application some…

  luissantos

  5 replies

  13 years, 4 months ago

  By: Jeff Moden

• Wrapper to run stored procedure many times

  I need some guidance on what is a good construct/method of running a stored procedure many times by…

  TeraByteMe

  20 replies

  13 years, 4 months ago

  By: GSquared

• For my edification - please

  I had a contractor pass me a query to run in our production environment and though that it would ne…

  Stuart Davies

  3 replies

  13 years, 4 months ago

  By: Stuart Davies

• Is there a more efficient alternative to WHILE LOOPS and CURSORS

  Hi members, I have a statement that loops through the records of a table to get two date values fro…

  s.njenga

  17 replies

  13 years, 4 months ago

  By: Evil Kraig F

• How to query a one-to-many and only return 1 row on many side

  I went through the available posts I could find on this topic and couldn't find a situation quite l…

  Steve Hoyer

  9 replies

  13 years, 4 months ago

  By: xenophilia

• Canadian Postal Code Format

  Hello, all: I'm fairly new to T-SQL, so I'm sure there's a relatively simple way of doing this, but…

  lk-681111

  7 replies

  13 years, 4 months ago

  By: wmccarty

• Does Table Value function caches execution plan?

  hi, Does Table Value function caches execution plan? one of my query is performing slow for the fir…

  Anamika

  10 replies

  13 years, 4 months ago

  By: TheSQLGuru

• accumulated values

  hi, i have a table with every minute data, if i want to select data for every 15 minute how can i d…

  Anamika

  7 replies

  13 years, 4 months ago

  By: ChrisM@home

• SELECT Statement with MIN

  I have a select statement that JOINs two tables, one for Product and one for the Product Colors. …

  DB Dude

  3 replies

  13 years, 4 months ago

  By: DB Dude