T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Generate Scripts for SQL Agent Jobs

  Hi everyone, I want to automatically generate scripts for SQL Agent jobs using a stored procedure, …

  Kabelo.

  7 replies

  14 years, 5 months ago

  By: Kabelo.

• TRY CATCH and GO

  I have some TSQL that uses TRY / CATCH. Inside the TRY there are lots of security assignments. If …

  hindle.steve

  3 replies

  14 years, 5 months ago

  By: hindle.steve

• Remove Alpha char's but leave in the decimal point

  Morning all I have wrote this function to strip out any alpha characters but I need it to leave in …

  Ant-Green

  2 replies

  14 years, 5 months ago

  By: Cadavre

• Query: Want to see "most active users" over the last year in minute incriments

  I want to see when we had the most people online doing "stuff". We have a table that shows the user…

  Maxer

  2 replies

  14 years, 5 months ago

  By: Maxer

• sql puzzle.

  I have a table enployee and a column gender. The possible values in the table are 'm' or 'f' In thi…

  ekant_alone

  4 replies

  14 years, 5 months ago

  By: Jared

• GO vs ;

  This is probably one of those basic questions that I tend to forgot. What is the difference between…

  smallmoney

  10 replies

  14 years, 5 months ago

  By: nwerner

• Inserting with a view

  I am running into a problem with an updatable view. When I try to insert against the view, it is gi…

  SpectralGhost

  5 replies

  14 years, 5 months ago

  By: SpectralGhost

• set condition via flag column

  Hi, I have a source table below: organization interco account curr amount organization interco acc…

  yingchai

  1 replies

  14 years, 5 months ago

  By: okbangas

• Multiple values not showing in SSRS Report

  Hi In the report i am creating i need help to achieve the following 1. Allowing the user to select…

  Jnrstevej

  25 replies

  14 years, 5 months ago

  By: Jnrstevej

• switch tables based pm prefixes

  If anyone is familiar with Dynamics NAV and the database structure, or even if this is something fa…

  battery_acid_h

  12 replies

  14 years, 5 months ago

  By: Jeff Moden

• simple one table query

  Hello; I have table; These values are F1F2 621apple 621orange 622banana 622grape 622strawberr…

  erhanduman

  19 replies

  14 years, 5 months ago

  By: Jeff Moden

• Inserting into large table in SQL SERVER 2008

  We have a large table(60 million rows),which receives lots of inserts per second.I notices that for…

  Aspet Golestanian Namagerdi

  14 replies

  14 years, 5 months ago

  By: Gail Shaw

• Max(Count()) ?

  hi! a little help here please. i have here 3 tables, the cluster table, field table and a variety …

  Nadi

  7 replies

  14 years, 5 months ago

  By: NotoriousDBA

• t sql query

  select c.customerid,c.firstname,c.lastname,o.totalprice from Test_Customer1 c inner join (select cu…

  pavithrareddyc

  1 replies

  14 years, 5 months ago

  By: NotoriousDBA

• T-SQL Literature

  Hi Guys I am looking to sharpen my T-SQL skills I've been eyeing the T-SQL Fundamentals book by Itz…

  SQLSACT

  4 replies

  14 years, 5 months ago

  By: SQLSACT