another way to go

DECLARE @t TABLE (price MONEY)

INSERT @t

SELECT 5 UNION ALL

SELECT 3 UNION ALL

SELECT...

insert A

select Employee, Phone, 5 from A where ID1=2

union all select Employee, Phone, 6 from A where ID1=2

delete from A where ID1=2

declare @t table(Customer int, Region varchar(2), Quarter tinyint, Sales money)

declare @t2 table(Customer int, Region varchar(2), Quarter tinyint, Sales money)

insert @t

select 123 , 'ON'...

Another solution:

SELECT a.Course, a.Grade,

COUNT(a.Grade) as 'TotalGrades',

pt= convert(varchar(50),convert(int, COUNT(a.Grade)*100/w.cCount)) + '%'

FROM Grades a

inner join

(

select cCount=count(course), course from Grades group by course

) w on w.Course=a.course

GROUP BY a.Course, a.Grade, w.cCount

order by a.Course,...

Thank you.

Please help. Thank you.

Thank you, everybody.

Trader Sam (3/20/2008)

---

I'm not sure if I follow you, but in Query Analyzer you can also right click the table name to generate the 'create' script for the table.

Is this...

I agree with Sergiy. I think about the physical order data appears in the table.

Vladan (11/22/2007)

---

I'll use the table structure and data from previous post.

If there is a possibility of multiple occurence of the same "sequence" value for one cuslink (shouldn't be, if that...

   Storing a "modified date" of a stored procedure in sysobjects or somewhere else in SQL Server is helpful if SQL Server 2000 did that. And I cannot understand the reason as your word...

I am using EM's diagram GUIs to add tables to my db schema diagram, and when I add an extra table the the diagram, I will see a table list...

Thank all of you for your posts. "8 original bits are split into 2 group of four, then the left most 4 original are put in the left most. The other...

Lowell,

  Thanks for your post. I agree with you about about the normal representation of binaries of 0 and 1. But if you double-read the business requirements, you will see...

Shawn,

  Thanks for your great hint. I add the GO statement after each SP and the batch script works fine.

Johnsql