Topics
Started by
Posts
Last post
I have the following query: SELECT result_date, result_by, tasktype, action, Count(*) AS [Completed…
4 replies
By: ehlinger
Friends ,Exists some way to get the server names of the MS OLE DB of each DTS? Thanks ...........
1 replies
How can I remove the "enter" character from the contents of an SQL Server Tables and replace it wit…
2 replies
By: KGC
Hello helpful chaps of ssc! Im trying to use a linked server query as a subquery in an updat…
5 replies
hello I have a database with collation : SQL_latin1_General_CP1_CI_AS I need a TSQL command to dete…
3 replies
By: ron k
I am using SQL server 2000 and have a table , in which one of the fields has multiple commas that n…
5 replies
By: sushila
I'm having a hard time trying to figure out what best area to look for using a google search so fig…
5 replies
By: scking
I need to create a global #TemporaryTable that I use in INNER JOINs. The Dynamic SQL i create is co…
6 replies
By: Ste_P
Hi I want to create a text file through a sproc. Here are some scenarios and pros and cons. Can yo…
5 replies
hi, i am executing the ff statement. cm3rm1 resides in a separate database. but both db…
3 replies
Hi, Before you all tell me that the xp_dirtree stored proc is unsupported and that I can't rely on …
1 replies
By: philcart
Ok, I know this topic has been beaten to death, but I am struggling with some issues around column …
17 replies
By: Ray Metz
Hello I have the following TSQL query : select 'DocGestao'=ft.fno, 'ValorGestao'=round(sum(fi.ecust…
9 replies
I'd be grateful if someone could help me out with this query. I want to do a search on a table base…
6 replies
By: ron k
Hello Want to concat one column over several rows while grouping on another dynamically. Example:…
2 replies
Viewing 15 topics - 10,516 through 10,530 (of 17,082 total)
You must be logged in to create new topics.