Topics
Started by
Posts
Last post
Hi All, I haven't been able to find anything on google about this, and was just wondering if someon…
4 replies
Hi All, Actually I have a table which stored data in column format . For Eg. table luks something l…
1 replies
i need to write a select statement that will show that there are duplicates. the first 4 are duplic…
1 replies
Hi, I have a query to find the views dependency on other views:, Here I have a table of 3 columns(1…
1 replies
Hello, I have a difficult task to do, I have the output from a network monitoring tool and i must e…
2 replies
Hi, I'm in process of rewriting a function which is returning a table.. below is the sample code of…
1 replies
Hi, i will like write a stored procedure to replace "X" in a string with number 0-9. For example: 1…
5 replies
SELECT * FROM A LEFT OUTER JOIN B ON B.col1 = 1 LEFT OUER JOIN C ON C.col3=A.col3 AND C.col2=B.col…
4 replies
Hi i need to get count (@count ) from below query DECLARE @Count int, @Query nvarchar(300), @ta…
3 replies
Hi all, How to create dynamic or tempary table in sql server 2005 regards pols
3 replies
We will be releasing a site for our client, one of the question I am trying to answer is "How do I …
2 replies
Any resource where I can find various database diagram sample? Also, trying to get some idea on bui…
2 replies
My database has dates in bigint datatype The following query returns the month and year of the data…
2 replies
Hello, I have created a stored procedure in SQL 2005. WHen I run it as a script, it completes. Ch…
5 replies
Can anyone see what is wrong with this statement? I have this same code in other scripts and it do…
9 replies
Viewing 15 topics - 856 through 870 (of 4,155 total)
You must be logged in to create new topics.