Topics
Started by
Posts
Last post
Hi, This is my problem, i'm pulling in rows from a text file that get loaded in to a single column …
7 replies
By: bond007
Hello All, DECLARE @query VARCHAR(8000) DECLARE @db VARCHAR(20) DECLARE @file&nbs…
3 replies
By: barsuk
Hi, I have 2 sprocs. They both contain the same logic, differing only in a boolean flag at the end.…
2 replies
By: yogiberr
E.g.: select * from Table1 join udf_SomeUDF2 on Table1.KeyID = udf_SomeUDF2.KeyID
1 replies
I have a stored procedure where I would like to input ONLY 1 parameter, but when I execute the SP, …
2 replies
By: eb24
Ok, I've been using functions a lot in SQL Server, I know how they work, what they can and cannot d…
2 replies
Hi all, a simple one I hope: I'd like a query that checks for the inclusion of a value: SELECT * FR…
2 replies
I have a stored proc that creates a temp table then is supposed to return the table with a select s…
10 replies
I have a stored procedure that I would like to export this query to a .txt file. select x fr…
5 replies
Dear Experts, As xp_cmdshell is run within sysadmin privileges, is not possible to execute by non-s…
1 replies
Hi all, I am trying to write code that will give detail about the Server's drives. The code below …
2 replies
By: Errol
I need your help. I am using this from inside my SP to output to a data file EXEC master..xp_cmdshe…
1 replies
I have a table with the following structure: Membernbr varchar(11) Service varchar (6) SubService v…
3 replies
When running the following statement: Truncate table linkedserver..owner.tableA Note: 'linkedserver…
1 replies
By: no name
I have a simple table structure that has customers in one table and addresses in another. The…
2 replies
By: no name
Viewing 15 topics - 13,201 through 13,215 (of 17,082 total)
You must be logged in to create new topics.