Topics
Started by
Posts
Last post
have table that holds dates when some accommodation is occupied I have problem to check if th…
24 replies
Dear All, This is probably a daft question but why does execution of a select using sp_cursorexecut…
1 replies
Hi there I need to calculate a rolling total, if the table is: col1 col2 1…
1 replies
I need a code or store procedure (T-SQL) to find all tables in a database with identity... Any sugg…
1 replies
I have a table where I cannot get a reliable answer for how many rows have a NULL value f…
25 replies
My book under batches seems to contradict itself. It says: "If a syntax error occurs anywhere in t…
3 replies
I've got the following query and everything runs fine until I add in the BY clause after COMPUTE.&n…
4 replies
I remember reading DATEDIFF is slow and wherever possible use DATADD. I have to retrive data for pr…
7 replies
I have a data base that has a VARCHAR Street Address field that contains the House Number or Street…
3 replies
Comparing between tables, I have found out that some of them result in an error like: The text, nte…
5 replies
i want to create a function to find the maximum of a integer column by sending the table name and t…
6 replies
can anyone tell me how to convert varchar to float? i have 2 sql statements joined by a union…
11 replies
hi Is there a way to get the where claus of a view . For example if there is a view with following …
31 replies
I am having some problems trying to figure this one out. I am trying to write a query to show only …
4 replies
Can oneone please let me know the way to find out owner of a sql job . I tried joining sysusers and…
2 replies
Viewing 15 topics - 10,021 through 10,035 (of 17,082 total)
You must be logged in to create new topics.