Topics
Started by
Posts
Last post
Good afternoon: I would like to know if there is a limit for the amount of rows into a table variab…
19 replies
Hello, Does anyone have a UDF that takes a string and returns a string which removes repeating cons…
2 replies
select #temp1.*,#temp2.* FROM #temp2 left outer join #temp1 on #temp1.EmployeeID=#temp2.EmpID How c…
5 replies
How can i join a table with the result set of a store proc. or do i need to creayte a temp table in…
17 replies
I am trying to find which domain all my SQL Servers are on (they are currently on different domains…
1 replies
Hi, I have a SQL Server 2000 database [A]. When I select records from a table using DATABASE.OWN…
4 replies
Is it possible to create a UDF Or UDT to include importing a date/time format that includeds up to …
3 replies
I’m trying to run a good sized query on the production database. I’m consistently getting ODBC err…
2 replies
Hi All, Given a string say "Tata Consultancy Limited" how will i get the position of the blank spac…
5 replies
All, I have faced a different problem recently. When i executed a procedure from back end, it works…
5 replies
What is the correct way to use in a case when inside a select query? Select S.SaleID ,S.UnitID …
2 replies
Hi all, I've got to populate a table in a DB in a particular language. This language can be deciphe…
4 replies
Hi, I have a history table where few column are avl. ID loan_num line_amt line_change_date Sample d…
4 replies
Here's a fun one that's perplexed me. I have table, dump_results, which contains osql outputs from …
1 replies
[font="Verdana"]Hi, After creating Temp Table inside SProc, I created Unique Clustered Index on Tem…
1 replies
Viewing 15 topics - 2,746 through 2,760 (of 17,082 total)
You must be logged in to create new topics.