Topics
Started by
Posts
Last post
I have a stored procedure that runs fine by it self. EXEC dbo.populateAging This pro…
35 replies
I have a query that does a SUM as follows: DECLARE @AP TABLE (ID int, Descrip varchar(50), Suggeste…
1 replies
create table a (ids int startdate smalldatetime) insert into a values(1, '12/2/2006') insert into a…
2 replies
HI. I'm trying to pull out just the time from a datetime field. I'm using this:CONVERT(varchar(20),…
5 replies
I can't imagine this is a new concept, but a search here didn't seem to turn up anything relevant. …
14 replies
Hi guys, I'm newbie in SQL Server and I have a simple question. I instaled MSDE on my machine and t…
2 replies
Hi, I need to create a script that will produce a list of results from a database, and save those r…
3 replies
Hi Everyone I hope you guys can help me. I'm writing software for an off-site document storag…
7 replies
Hi, I am fetching DOS file list into a temp table togethere with some dates: select finfo from #t …
1 replies
namaste ji how can i use ntext data persisted in a table to feed sp_executesql within a stored proc…
2 replies
Hey guys.. I have a view that we use here that takes about 4-6 minutes to return all rows in three …
4 replies
This query executes (instantly) in SQL Server 2000 without SP4. With SP 4, it hangs - goes over 5 m…
5 replies
I have a query(below) that contains a LEFT OUTER JOIN. This JOIN is needed to get all the data I ne…
15 replies
Can't seem to be able to figure out how to find values in a column of type money that have cents an…
19 replies
well no elgance here what so ever which is a shame. I've resolved this by using 'UPDATE' as s…
2 replies
Viewing 15 topics - 5,146 through 5,160 (of 17,082 total)
You must be logged in to create new topics.