T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• data for Min/Max rows

  Hi All, Please can someone tell me how to select min/max rows in a single query similar to the one …

  popq79 34287

  4 replies

  12 years, 5 months ago

  By: Dwain Camps

• find item that does not have a specific entry

  Ok here is a sql I run that tells me all my machines that have java installed. SELECT DISTINCT i.gu…

  lawson2305

  9 replies

  12 years, 5 months ago

  By: lawson2305

• DB connection error issue while running a batch job from the APPLICATION Server.

  Hi All, I have an DB connection error issue while running a batch job from the APPLICATION Server. …

  theunique1011

  1 replies

  12 years, 6 months ago

  By: Bhuvnesh

• The maximum allowable avg_user_impact for any missing index

  Hello everyone, I am required to create some indexes on the table to improve the performance of the…

  veerbharat_jaiswal86

  1 replies

  12 years, 6 months ago

  By: TheSQLGuru

• exec master.dbo.xp_cmdshell

  :ermm: Its been working all this while but for some reason it has stopped working for only 1 of ou…

  LOOKUP_BI-756009

  6 replies

  12 years, 6 months ago

  By: Orlando Colamatteo

• Starting a Job

  Hi, I would like to have a procedure start a job, is that possible to do and to do it without waiti…

  rightfield

  10 replies

  12 years, 6 months ago

  By: Lynn Pettis

• LEFT JOIN vs EXCEPT

  HI All, I have just come across the except tool in SQL 2005 and have been running some performance …

  Christopher Stobbs

  22 replies

  12 years, 6 months ago

  By: Dwain Camps

• Removing a pesky hidden character from a string

  Hello All: I am trying to remove a pesky hidden character from a string. The hidden character looks…

  Simon E Doubt

  3 replies

  12 years, 6 months ago

  By: Simon E Doubt

• Comparing dates from multiple rows of duplicate data

  Hi I have a table in my database where there is a unique identifier of InvoiceNumber (this is not t…

  neal.cook

  2 replies

  12 years, 6 months ago

  By: Cadavre

• Problem querying column containing an asterisk

  Hi I have a table with a column which is defined as a varchar that contains asterisks. If I query …

  gareth.bowen

  5 replies

  12 years, 6 months ago

  By: gareth.bowen

• Need help conveting this from Mysql to SQL server

  Select * from openquery([connection],' -- Forum Messages by User use databasebname; select u.name, …

  Brad Marsh

  6 replies

  12 years, 6 months ago

  By: Phil Parkin

• Delete trigger

  I'm not sure what is going on here - if my brain has gone on Christmas holiday early or what, but I…

  Stuart Davies

  13 replies

  12 years, 6 months ago

  By: GSquared

• Stop joined aggregates from multiplying

  I have three tables. A customer table, an invoice table, and a payment table. I want to pull, in …

  Lisa Liel

  6 replies

  12 years, 6 months ago

  By: Sean Lange

• Getting Error "All queries combined using a UNION..." Why??

  Hello - I have SQL View (which I would like to go on record I did not write it) that has three Uni…

  david.ostrander

  5 replies

  12 years, 6 months ago

  By: david.ostrander

• Convert DateTime to Epoch

  Hello, I'm trying to create a function that will convert a datetime '2009-04-01 00:00:00.000' to ep…

  brickpack

  8 replies

  12 years, 6 months ago

  By: forsqlserver