Topics
Started by
Posts
Last post
Hi, I'm new here. Nice website and forum. I have a question to ask...hopefully nobody will mi…
6 replies
I am trying to execute a proc with the statement below: EXEC dbo.spRyanSearchPropTestWithLand @Stat…
8 replies
I am trying to execute the below function and i'm getting a Invalid object name 'dbo.fn_GetClosestZ…
5 replies
I don't have a book handy and just need a quick answer to a question about stored procedure syntax…
8 replies
This is my resolution to a question I posted back on August 30, 2005. What is a quick and eas…
3 replies
Because field is "multiuse" I need to retrieve a value depending on a column CREATE TABLE [dbo].[#t…
1 replies
Can the query at the bottom of the post be written without using a sub-query? Thanks. -------…
5 replies
I'd like to find out at runtime the default value for a stored procedure parameter. I'm trying to u…
5 replies
I need to compare a record with a date to the last two dates (two previous dates) in a Dates Table.…
3 replies
How do I get the names of all the columns in the primary key using TSQL in a form I can loop round …
2 replies
how do i zip up a file in a schedule job, so the file can be open on a unix machine i have done it …
7 replies
I have just written an instead of insert, update trigger. I presumed the trigger would fire for eac…
13 replies
Hope someone can help. I am trying to write a query where I pull back the top 20 rows for an …
3 replies
i have an archive table and current table, both with same columns. for reporting purposes i'd like…
5 replies
Hi, I'm trying to run the following sql using osql from the command line to produce a file of data.…
8 replies
Viewing 15 topics - 9,271 through 9,285 (of 17,082 total)
You must be logged in to create new topics.