Development

• Topics

  Started by

  Posts

  Last post

• How to get storedprocedures parameters with types

  Hello All, I would like to know how to get the stored procedures parameters along with it's type…

  DexterForALL1986

  9 replies

  14 years, 2 months ago

  By: Jayanth_Kurup

• Different results while deleting data in different Environments

  I am deleting records from one table which has Foreign Key dependency on another table. On two envi…

  sqlnaive

  7 replies

  14 years, 3 months ago

  By: RP_DBA

• Need a template to create Medicaid UB92 form from ssrs

  Need to set up Medicaid Billing from SSRS. Need to produce UB92 form. Can anyone help me out on thi…

  BMcCormack

  2 replies

  14 years, 3 months ago

  By: Lowell

• Outer Join

  Hello, We are trying to convert our SQL 2000 queries to SQL 2005 queries. But one of the queries is…

  Yasir Masood

  3 replies

  14 years, 3 months ago

  By: Grant Fritchey

• to insert data from one table to another

  I want to insert the data from 1 table to another table.Delete first table After inserting the data…

  raaz66

  3 replies

  14 years, 3 months ago

  By: Jnrstevej

• search pattern in select statement

  Hello All, I need you help for one search pattern that I want to use in the select statement. The p…

  yatish.patil

  9 replies

  14 years, 3 months ago

  By: Orlando Colamatteo

• Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

  DECLARE @pushMaxCustomerRank int; SET @pushMaxCustomerRank = (select NumericValue from ClientSettin…

  wilsonsfamily

  6 replies

  14 years, 3 months ago

  By: wilsonsfamily

• Help with a SET based solution to multiple bets

  I am trying to come up with a set based solution to the following problem. I have a horse racing BO…

  Rob Reid-246754

  4 replies

  14 years, 3 months ago

  By: GSquared

• Help with nested transactions in stored procedures and triggers causing Msg 266.

  Hi, I'm having hassle with transactions that are nested in both stored procedures and triggers. I'm…

  GuitarGuy

  6 replies

  14 years, 3 months ago

  By: GuitarGuy

• Converting data to wav format

  Hello I have an application. It deals with the following columns. customer Nam…

  hayamal

  4 replies

  14 years, 3 months ago

  By: Sean Lange

• sys.dm_exec_requests showing negative total_elapsed_time

  Hi all, I need help on the below issue. I am executing the below query to see the current sessions …

  mohan.pariveda 18256

  1 replies

  14 years, 3 months ago

  By: calvo

• error while executing dts appExcel.Workbooks.open

  I have several dts on my sql2005 server with activex tasks that open one excel file and then put so…

  irena.bulatovic

  5 replies

  14 years, 3 months ago

  By: Welsh Corgi

• SELECT name, type, type_desc FROM master.sys.server_principals giving invalid object name

  Dear Sir, I run the above statement for getting Connection Authentic mode (SQL Mode), I giving inva…

  deba_20032004

  1 replies

  14 years, 3 months ago

  By: Sean Lange

• SELECT name, type, type_desc FROM master.sys.server_principals

  Dear Sir, I run the above statement for getting Connection Authentic mode (SQL Mode), but I am gett…

  deba_20032004

  1 replies

  14 years, 3 months ago

  By: Ninja's_RGR'us

• how to get current connection properties in sql server 2005

  Dear Sir, I want to get all properties of current connection in sql server 2005 using sql command n…

  deba_20032004

  1 replies

  14 years, 3 months ago

  By: Ron McCullough