Kausar Mehmood (4/16/2012)

---

What's your experience say's, will this do the job? Doing something and reading something is altogether different job. I will use CTE, UNION and Paging along with Table...

Depends, what is the purpose of this exercise? Is this for a class project?

Glad to help.

Think of it as a stored procedure that you need to return...

Welsh Corgi (4/16/2012)

---

I tried changing it slightly but I get a NULL When SELECTING on @MMyCount:

SET @SQLQuery = 'SELECT COUNT(*) FROM ' + @SchemaName +'.'+ @SQLTableName

DECLARE @MyCnt INT;

DECLARE @ParmDefinition...

SQLCrazyCertified (4/16/2012)

---

jralston88 (4/13/2012)

---

We have multiple instances of SQL Server 2000, 2005 and 2008.

We want to test our restore process for each database. Since we don't want to test on...

Larry Page(Ehsan.Akbar) (4/16/2012)

---

SQLKnowItAll (4/16/2012)

---

Lynn Pettis (4/16/2012)

---

SQLKnowItAll (4/16/2012)

---

In something like tic-tac-toe, chess, or checkers moves occur asynchronously; i.e. team a, then team b, then team a, etc... This is not...

Here is a quick sample you can run:

CREATE TABLE #TestIt(TabID INT);

INSERT INTO #TestIT

SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3;

DECLARE @MyCnt INT;

DECLARE @SQLCmd NVARCHAR(MAX);

DECLARE @ParmDefinition nvarchar(500);

SET @SQLCmd =...

SQLKnowItAll (4/16/2012)

---

In something like tic-tac-toe, chess, or checkers moves occur asynchronously; i.e. team a, then team b, then team a, etc... This is not the case in football (soccer...

You need to declare the variable in the dynamic sql, set it to count(*) in your select. The output variable used in the sp_executesql proc will then have that...

Sean Lange (4/16/2012)

---

Help us help you by posting details.

Help us help you by posting details.

Help us help you by...

How are we supposed to help? You won't give us anything to work with to help you. ...

And I...

donato1026 (4/16/2012)

---

And this is when I go outside and walk in front of oncoming traffic... If I may, I would like to use the fact...

Missing a comma!

DECLARE Contacts CURSOR LOCAL FAST_FORWARD READ_ONLY FOR

SELECT

distinct(CUST_CD)

,TRK_NUM

,EMAIL_ADDR

,DELIVERY_DATE

...

capn.hector (4/16/2012)

---

when posting code i always put the semi colon infront of...