T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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, 9 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, 9 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, 9 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, 9 months ago

  By: Edward-445599

• Linked Server - SELECT .. INTO

  I am trying to insert data into a database on a remote server using linked server: SELECT * INTO [L…

  hindle.steve

  7 replies

  14 years, 9 months ago

  By: hindle.steve

• can I see the output value after executing sproc in ssms

  I'm using management studio to excute a stored procedure. The stored procedure have both input and …

  sqlfriend

  7 replies

  14 years, 9 months ago

  By: sqlfriend

• Syntax problem: WITH XMLNAMESPACES in subquery

  I need to create dynamically XML including namespace declaration at the top level As a start I have…

  Laurie Burrow

  6 replies

  14 years, 9 months ago

  By: Laurie Burrow

• UPDATE Script with a JOIN

  I struggled with this for a while and I know I am not the only one. So, since I have received help …

  duanecwilson

  4 replies

  14 years, 9 months ago

  By: ahmedmujtaba88

• @@datefirst gives different result between Excel and SSMS

  I've just noticed something here - when I execute print@@datefirst on a particular database on SQL …

  ricko

  3 replies

  14 years, 9 months ago

  By: ricko

• goup by on sub query

  Hi, I have relisted this from a post I placed about 2 weeks ago as I didnt explain myself very wel…

  LoosinMaMind

  10 replies

  14 years, 9 months ago

  By: LoosinMaMind

• Need advice on Logging XML

  I am writing a process to send XML files to a external party on a daily basis that contain all the …

  UnionAll

  9 replies

  14 years, 9 months ago

  By: GSquared

• How to find the nth record based on specific condition

  Hi, I need ur help.. I have a table which contains on and off status of a meter. Feederstatus = 0 m…

  Prasanthi Reddy

  9 replies

  14 years, 9 months ago

  By: Prasanthi Reddy

• Output Of Stored Procedure

  Hi i have two tables 1. Table A ID---Name 1----Abs 2----Cex 3---Dex Here ID in table A is an Identi…

  tripri

  1 replies

  14 years, 9 months ago

  By: Sean Lange

• Index/Stats Maintenance execution

  Hi Guys Please help I have the following code which when executed generates a script to Rebuild In…

  SQLSACT

  7 replies

  14 years, 9 months ago

  By: SQLSACT

• How to change column type on all tables of a certain database

  Hello, I need a script to change the type of a column from char(n) to nvarchar(n) where n is the le…

  evald

  3 replies

  14 years, 9 months ago

  By: Jason-299789