Topics
Started by
Posts
Last post
Hi How to verify whether a decimal point exist in the column data. eg:I have a Column called primar…
5 replies
I want to query data from (01.09.2011 - 31.10.2011), please do not use PERIOD column to retrieve …
5 replies
I want to know what is wrong with the stored procedure. It works fine with all cases except when I …
5 replies
hi, I want to join 2 tables with date. I want to compare only the dates. That is excluding hours, m…
3 replies
Hello When I select table1.colA + table2.colA it return null value when colA is 0 At table1.colA an…
4 replies
I was wondering how can I check who has created the table in sql server 2005? Right Click -Properti…
6 replies
The below query is giving me 4 rows instead of 1 row i.e I am getting the same answer 4 times in my…
3 replies
Using TSQL, is there a way to determine whether a .txt file is in use by another process ?
1 replies
Hi Trying to get the below query to work and having a little trouble, Basically if you run it as is…
8 replies
Hi Everyone, This one has be puzzzled. I have a sp that runs fine on its own like so: exec dbo.dsbn…
3 replies
Hi I run the following statements as part of a stored procedure. The output is approx 300,000 rows …
5 replies
I am trying to build a report for errors that i encounter when reconciling a customer report. The f…
2 replies
I have created a stored procedure that accepts a date as parameter and then goes on to produce an o…
2 replies
I have recently seen a few T-SQL queries starting with “WITH” I understanding what’s happening I am…
55 replies
Hi all, I've got a code that simply loops through rows in a table using cursors. I've noticed for e…
4 replies
Viewing 15 topics - 7,111 through 7,125 (of 10,635 total)
You must be logged in to create new topics.