Hi,

It says that Returns the maximum number of simultaneous user connections allowed on an instance of SQL Server is 32767.

At a single point of time say @ excatly 12:00:00:123 PM...

Hi ,

Is this you are looking for

declare @Temp...

Hi

Thanks for your replay.I think this what i need now i get confused with my exact req,but this is what i need as the o/p as i...

Yes i...

Hi

I dont think so Cross tab will help here since i dont want data in horizontal or vertical i need just to add one column (Need Column4 value...

LutzM (1/20/2011)

---

There are several issues being unclear:

1) Why are there three rows for 5,C,F in @T but none for 5,C,T?

2) Why is the row for 5,C,F in @T and not...

Hi,

@Temp is actual i need as @Temp1

Thanks

Parthi

Hi,

Have a look at the below forums

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/30218/

http://sql-server-performance.com/Community/forums/p/4438/29362.aspx

Thanks

Parthi

So if there is millions of records are there we can prefer either option ,is it is good???

Now...

Have a look at

http://msdn.microsoft.com/en-us/library/ms177596.aspx

Select Distinct Xtype in sysobjects

Thanks

Parthi

What data has been changed ?

what you need to track ?

Explain in brief your requ is not clear

For better, quicker answers on T-SQL questions, click on the following...

http://www.sqlservercentral.com/articles/Best+Practices/61537/

For...

@LutzM

...

RaviShankar1234 (12/30/2010)

---

--------------------------------------------------------------------------------

This is the Table structure I have I want to write a query to the get the

col 1 Col2

1 A

2 B

3 C

4 D

5 E

6 F

I have a table...

RaviShankar1234 (12/29/2010)

---

This is the Table structure I have I want to write a query to the get the

col 1 Col2

1A

2B

3C

4C

5D

6E

O/p should be like this

col...

Can you elaborate in better

can you have some examples for it like how with scenarios

Thanks

Parthi