dear plz send me query
thanxs
muhammadrashidmughal
Last Activity: Aug 5 '08, 08:59 PM
Joined: Feb 28 '08
Location:
-
need a query (columns to rows and rows to columns)
columns f1 f2 f2 f4 f5 f6 f7 f8 ......
1
2
3
4
.
.
i have a table in which multiple columns and records more than 1000 ,
i need a query to convert these records in columns and columns in rows.... -
Index On A Columns
DEAR
ANY ONE TELL ME THAT HOW CAN WE CHECK INDEXES ON A COLUMNS IN THIS THIS FORMAT
Table Name: Index Name: Index Column(s)
THROUGH A SINGLE COMMAND
RASHID -
tempdb space issue
hello
what are the situation in which tempdb space boost up, or how can we check tempdb space , is there any other way that we can shrink tempdb log file, -
users connections
hello all
kindly tell me that by default on one database maximum user connection limits how much ?
ras -
sql server installation problem
hello
i m trying to install sql server 2005 on pentium 3 with 256 ram , there is an error while installing that u must intall "windows installer 3.1 or later' , and i am using windows 2003 server. kindly tell what i will do in order to overcome on this problem.
thanx
rashid -
null data
hello dear
i want to apply a query in order to pull out those records where special chararcters like blank , spaces etc are in table but without using like and isnull function .
thanks
ras -
muhammadrashidmughal replied to Retrieving duplicate consecutive records(How to make query for this scenario?)in SQL Serverin order to check doubtful records
select employee_id,max (check_date_tim e) as max_check_time, check_type
from table
where Check_Date_Time >='2008-mon-day 00:00:00.000' and Check_Date_Time <='2008-mon-day 23:59:59.000'
group by Employee_Id,che ck_type
order by 1Leave a comment:
-
-------------------------------------------------------------------------------------------------------
yes i need this
Kindly send me complete code
thanx
please send me complete o...Leave a comment:
-
------------------------------------------------------------------------------------------------------
i want time to time checking of replication on different servers and after 20 min
the system will send mail which show replication status on different servers , that either replication is fail or completed successfully...Leave a comment:
-
--------------------------------------------------------------------------------------------------------------------well
i want to create a stored procedure in which i pass more than one values in one
variable...Leave a comment:
-
Replication in sql SERVER 2005
Hi
How can i check replication through command line in sql server 2005, without
viewing the replication monitor. -
Passing Multiple values in stored procedure
I need to know a way to pipe the output of an sql (select )statement to a stored procedure.
Eg:
The stored procedure is sp_rsch_filters param1,param2,p aram3
Requirement is to pass param1,param2 and param3 from user X.
No activity results to display
Leave a comment: