Topics
Started by
Posts
Last post
Hi, I need some help with a SQL query. I've been trying to find a way to get the desired informatio…
2 replies
I have the below tsql running on a new sql box with 32 gig of ram select a.FacID, a.PatID, PatName,…
7 replies
Current Query: Select person_id, (Select 'Y' From notes where note_date > '06/23/2008' AND note_…
1 replies
I need to remove all rows from a table based on the date value being at lease sixty days old from t…
3 replies
Hi, I have 2 customers; they both have their own database that is identical to the other. What I wa…
12 replies
Does anyone know how to convert Cursor logic into a CTE?
11 replies
hi, Please tell how to transfer sql query output to text file. only using sql query.
2 replies
Hi Friends, Given an employee table( with columns Emp_ID,Emp_Name,Emp_Salary), how would you find o…
41 replies
Hi! Please help I have a table with bi-annual ratings for staff, I want to select only the latest r…
2 replies
i want to make a stored procedure that can import excel, without using DTS, SSIS etc.. Thanks alot …
2 replies
Hi All, Im running a query in 2005,I am getting some error like Msg 104, Level 16, State 1,…
2 replies
What is the difference between these two approaches? The use of @@TRANCOUNT seems legitmate to me b…
1 replies
Hi members, I joined this forum today. I have a table which is in tree model like PID …
16 replies
I need to prevent "dbo"s from accidentally running a certain stored proc. Yet, I want a specific us…
1 replies
I have a database which has a field for record created on. There are records in this table for last…
3 replies
Viewing 15 topics - 9,241 through 9,255 (of 12,234 total)
You must be logged in to create new topics.