T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Unzip files from Stored Procedure using 7zip

  Here is sample code that will unzip files from a given directory, into a destination directory usin…

  Jeffery Williams

  4 replies

  14 years, 5 months ago

  By: caspersql

• Adding either a "1" or "2" in a column (using Select, Union All, and three tables)

  Thanks for reading the post... I just registered today because my search of the site is not giving…

  TDSapp

  8 replies

  14 years, 5 months ago

  By: drew.allen

• Query to combine two fields into one output

  Hello, I have to combine two fields into one output field with next rules: - ID1 ID2 12…

  branovuk

  13 replies

  14 years, 5 months ago

  By: Performance Guard (Shehap)

• trigger

  hi, I want to create a trigger for.. if i insert any rows into my table..my primary key column …

  sql Anand

  14 replies

  14 years, 5 months ago

  By: sql Anand

• guyz help me

  A B A+B == == === 123 13NULL 14NULL 15NULL 16NULL 17NULL 123 13NULL…

  faruk.arshad

  12 replies

  14 years, 5 months ago

  By: GSquared

• Query Performance

  Hi, I have a problematic query and need your guidance. Let's that I have 3 tables A, B and C and al…

  chandan_jha18

  17 replies

  14 years, 5 months ago

  By: Grant Fritchey

• Update field based on another table field value

  Hello, I have: - table1 (table1.id1, table1.code1, table1.connection_field) - table2 (table2.id2, t…

  branovuk

  19 replies

  14 years, 5 months ago

  By: toddasd

• Upadating current tables from holding tables

  Hi guys and gals, i'm new here so please be gentle. I'm not a novice but aint an expert in T-SQL ei…

  Domestos

  8 replies

  14 years, 5 months ago

  By: Domestos

• construct interco elim query

  Hi, I have an interco details table shown below where AR means account receivables and AP means acc…

  yingchai

  4 replies

  14 years, 5 months ago

  By: R.P.Rozema

• SQL Logging

  hi folks, can anybody tell me about sql logging and how can i retrieved the deleted data from that.…

  ghanshyam.kundu

  3 replies

  14 years, 5 months ago

  By: cindyaz

• Selecting Max Date

  Hello All, I have a table that consist of data like this: Table Name:Servers Server_nameServer_st…

  Ronnie Jones

  3 replies

  14 years, 5 months ago

  By: Ronnie Jones

• query question

  i dont know about how to write the following query can anyone help me please ???? sql query to Disp…

  adirajusarada

  2 replies

  14 years, 5 months ago

  By: drew.allen

• excute stored procedure with output parameters

  I tried to excute a stored procedure which has output parameters, but I keep get errors: Here is th…

  sqlfriend

  5 replies

  14 years, 5 months ago

  By: mimran18

• Return only IDs from table with most recent dates, but don't return the date

  I have this script (which can be run as is in SSMS) that returns all the IDs, but only the most rec…

  duanecwilson

  3 replies

  14 years, 5 months ago

  By: Ninja's_RGR'us

• sp_OACreate

  Hi, I have just backed up and restored a DB to a diffrent server (both SQL 2008 R2 sp1 x64 dev) and…

  Edward-445599

  1 replies

  14 years, 5 months ago

  By: Edward-445599