T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• problem using left join - not showing all possible results

  hello all, i am trying to cross the results of two tables and its driving me nuts for some time. ED…

  a20213

  13 replies

  14 years, 4 months ago

  By: jcb

• Calendar table, Equinox/Solstice & Astronomy calculations

  I am building a calendar table, and would like to be able to add astronomy calculations to it (or t…

  Steve_o

  6 replies

  14 years, 4 months ago

  By: SQLRNNR

• insert multiple rows with a trigger that invoke a function

  Hello, I need some help with the following problem Multiple rows to insert: --------------------- i…

  all023

  14 replies

  14 years, 4 months ago

  By: TheSQLGuru

• Calculating Year to Date total

  I have the following two table definitions. The query I have here is sort of what I need to display…

  chrisvolny

  5 replies

  14 years, 4 months ago

  By: Jeff Moden

• alternative to table variable and temp tables

  Thank you in advance I need to reserve memory and keep performance the best I am using declare @myt…

  Sarsoura

  3 replies

  14 years, 4 months ago

  By: Ron McCullough

• Using Case to assign value to different columsn

  Hi guys, I am struggling with a query. I have a date field, if the date falls under the currnent mo…

  Ian C0ckcroft

  3 replies

  14 years, 4 months ago

  By: johnitech.itech

• Concat resultset

  Hi Mates, I have a query which produces result set containing 2 or more rows as follows: Query: SE…

  revozex

  2 replies

  14 years, 4 months ago

  By: revozex

• Is WITH NOLOGGING is there in SQL server .?

  Is WITH NOLOGGING is there in SQL server .? Can i use WITH NOLOGGING option for UPDATE, INSERT, DEL…

  karthikaug18

  3 replies

  14 years, 4 months ago

  By: johnitech.itech

• Extended Latin Character - Need help on storing in my DB

  Hi, I need to save the below characters in my DB . My Insert stmt is not working peoperly . I used …

  raghavendraselvan.sk

  3 replies

  14 years, 4 months ago

  By: johnitech.itech

• How to get total count when using Row_Number() as subquerry

  I need to get the total row count for a specific subquery; however, I cannot get access to the subq…

  BuilderBits

  3 replies

  14 years, 4 months ago

  By: johnitech.itech

• Sum fields from multiple tables

  I have individual Monthly tables (eg: AMOLTST_01_2012), so Jan is 01 and so on... I have a SP that …

  Darryl Wilson

  1 replies

  14 years, 4 months ago

  By: sivaj2k

• subquery vs declare @mytable table

  Hi All, I would like to do the following using sub queries I want to merge studentid's of all stude…

  Sarsoura

  4 replies

  14 years, 4 months ago

  By: Grant Fritchey

• Key Lookup(Clustered)

  Hi everyone! Help me plz with a problem In my query I join one table with another large table (abou…

  liushka87

  3 replies

  14 years, 4 months ago

  By: Gail Shaw

• query for linked server

  Hello, i want to retrive information( name of database and srvname) of instances from my linked ser…

  tpftpf

  3 replies

  14 years, 4 months ago

  By: johnitech.itech

• aditing

  Hi Team, Using below script we are doing some purge data. The job was running successfully but the …

  shiv-356842

  2 replies

  14 years, 4 months ago

  By: johnitech.itech