Topics
Started by
Posts
Last post
Hi guys, is it possible to create a single function that returns multiple value's? if pos…
8 replies
I have a stored proc where in i have the following line of code SET @dtStopTime = cast(CONVERT(varc…
6 replies
how can I delete a record when that is referenced by some other table. I just delete all records wh…
2 replies
-- Here are the basic columns of the tables involved -- Ommitted extra columns, Contraints, Default…
7 replies
Hello, I'm trying to join three different tables that have a program name and order no in common ho…
4 replies
Here I want to select all rows if userid is 1 or 2 if not I want to select all where OID=@OID...am …
3 replies
in a procedure: when should i use the declare table command and when should i create a temp table…
5 replies
Hi. Line # FY 2004 FY 2005 FY 2006 Custodial services …
1 replies
hi guys, i have two queries where i'm sekecting Max and Min Dates from a table. What i want to do n…
3 replies
From BOL: sysindexes.keys is varbinary(816) List of the column IDs of the columns that make up…
6 replies
Hello, I have a Decimal(6,0) column that contains date data in the following format; ymmdd. So May …
2 replies
I'm expecting one record to be returned during the compare but two are coming back. Here's the tabl…
9 replies
I'm trying to determine how to perform the below without using the Like predicate: SELECT T.col1, T…
7 replies
I have the following problem, some tables have timestamp datatype. I would like to copy data to ano…
13 replies
Any ideas on this? I need to be able to call a web service from with a stored procedure, and it we …
3 replies
Viewing 15 topics - 4,681 through 4,695 (of 17,082 total)
You must be logged in to create new topics.