T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Problem in procedure

  SELECT COST_CENTER,'1900-01-01' AS VALID_FROM_DATE ,COCODE,CENTER_DESC,COST_CENTER_MGR FROM XYZ WI…

  sk.panda

  13 replies

  15 years, 10 months ago

  By: pink_panther

• SQL Join Help

  I have a query to write for a report and my client made a change that has me confused about how to …

  john.clyma 97764

  3 replies

  15 years, 10 months ago

  By: wschampheleer

• Set Variable based on a SELECT

  I'm still Googling and searching SSC for my answer, but here is my problem. I need to set a VARIABL…

  rew-370421

  11 replies

  15 years, 10 months ago

  By: rew-370421

• Doubt on SQL jobs

  I have a doubt.. is it possible to give permissions to users to execute only a few jobs and not oth…

  Paarthasarathy

  2 replies

  15 years, 10 months ago

  By: Greg Charles

• Doubt regarding sql job

  Is there a way to invoke a SQL job from applications other than Sql Enterprise Manager or SS Manage…

  Paarthasarathy

  3 replies

  15 years, 10 months ago

  By: Paarthasarathy

• Tsql conditional Join

  Hi All, I have a table-- TableA which could be linked to either TableB or TableC. I want to join e…

  4EverandEver

  5 replies

  15 years, 10 months ago

  By: wschampheleer

• Exclude a column from SELECT * within a View

  I'm aware that SELECT * is not best practice and that it's best to alias tables and then use the ta…

  BH-428850

  20 replies

  15 years, 10 months ago

  By: nigel.

• VALIDATING FROM AND TO COLUMNS AGAINST PARAMETER TABLE

  I have a table of data where there are 2 columns which hold from and to values of a code set which …

  Nilssond

  1 replies

  15 years, 10 months ago

  By: wendell.malpas

• Parent and Child in Multi table join SQL command? help me!

  I have 3 table Join. because i can't drawing table in text editor of forum, i attach file bellow Th…

  fotechvnu

  11 replies

  15 years, 10 months ago

  By: fotechvnu

• Cannot Get Average of rowcount: Msg 130, Level 15, State 1, Line 1 Cannot perform an aggregate function on an expression

  I am trying to get an average of a rowcount while I group by the hour. This runs without error. It…

  sgambale

  14 replies

  15 years, 10 months ago

  By: Jeff Moden

• sysdatabases db_id

  Hi All, I have a question i have a index stored procedure that populates user database table on nam…

  glugingboulder

  2 replies

  15 years, 10 months ago

  By: glugingboulder

• Help Processing XML docs in a stored procedure

  I am trying to query an XML: document to produce a particular output string. Here is an example of…

  jeff 96895

  3 replies

  15 years, 10 months ago

  By: LutzM

• A different Distinct Query

  I am having a table looks like tbl_sal st_no year month sal 1 2008 …

  johncyriac

  21 replies

  15 years, 10 months ago

  By: John N Hick

• Table Variable Issue

  The issue I’m seeing is that when I join a table variable to a persistent table, the query plan is …

  amoericke

  21 replies

  15 years, 10 months ago

  By: The Dixie Flatline

• Select names of Excel Worksheets?

  I'm trying to use an Excel workbook to create a table for each worksheet. How do I Select the work…

  andy.gear

  1 replies

  15 years, 10 months ago

  By: andy.gear