CREATE PROCEDURE [dbo].[UTIL_Detail_index_Stats]

@table_name sysname

AS

BEGIN

SET NOCOUNT ON

/*

...

dan-572483 (7/17/2013)

---

I want my procedure to include an optional date parameter that defaults to the current date. Why does the following code show a Syntax error?

CREATE PROCEDURE sp_MyProcedure

@Record_ID Varchar(12),

@OtherKey_ID...

IF OBJECT_ID('tempdb..#OvertimeBudget2013') IS NOT NULL

DROP TABLE #OvertimeBudget2013

CREATE TABLE #OvertimeBudget2013

(

[ID] INT IDENTITY(1,1) NOT NULL

...

I'm not sure which direction you are trying to go with this. To return an XML document from a SQL query requires more data than you have provided (sample data...

Minnu (7/16/2013)

---

Hi Team,

Am having two datbases in one instance,

whenever i execute any scripts, i'll use "USE DATABASE" and execute the scripts,

Is there any way to mention instance name, instead...

kaththecoder (7/16/2013)

---

Hi

I am a newbie and need to get the grand total of the new_TotalNoofPlanMembers field

and am having some difficulty as this isn't working for me.

SELECT

new_MembershipNumberAS 'Membership ID',

FullNameAS 'Member...

I don't see how you can force the order without using an ordering column of some kind so it seems the easiest solution is to just add an IDENTITY column...

r_noob (7/15/2013)

---

I've spent a fair bit of time searching, but can't seem to find a succinct answer...is there a more efficient/faster way of performing the following query? I simply...

ASSUMING the order is dependent on the Payment_Code, then:

Sample data:

IF OBJECT_ID('tempdb..#Invoice_t') IS NOT NULL

DROP TABLE #Invoice_t

CREATE TABLE #Invoice_t(

[Cost_Center_code] [int] NOT NULL,

[Payment_code] [int] NOT NULL,

[INV_No] [int] NOT NULL,

CONSTRAINT [PK_Invoice_t] PRIMARY KEY...

Also take a look at this recent thread http://www.sqlservercentral.com/Forums/FindPost1472826.aspx which has some examples which may help.

 

Can you provide some sample data for the 3 tables?

CREATE TABLE TBL_Value_Types

etc

INSERT INTO TBL_Value_Types

etc

Do this for each of the 3 tables so the query can be tested against actual...

Take a look at the procedure in this post:

http://www.sqlservercentral.com/Forums/FindPost1472808.aspx

 

I've heard rumors that the INFORMATION_SCHEMA views are deprecated in later versions, but the information even on MSDN isn't very clear on that. http://msdn.microsoft.com/en-us/library/ms186778.aspx. It seems the INFORMATION_SCHEMA views are...

Perhaps an even simpler solution:

--Sample data

IF OBJECT_ID('tempdb..#empp') IS NOT NULL

DROP TABLE #empp

CREATE TABLE #empp

(

eno INT

,ename VARCHAR(25)

...

Here's a stored...