Topics
Started by
Posts
Last post
I have a select statement like: SELECT Company, FirstName, LastName, Email FROM Table and get recor…
7 replies
To make things simple I have this in a view View_Fruit Select Customer From Apples Union All Select…
2 replies
Hi, I have stored procedure "SomeProc @arg0 int, @arg1 nvarchar(260)". This procedure return 3 tabl…
5 replies
I need to go to the zip code table and pull the city and state if it's missing from the propertydet…
2 replies
Hi When I raise errors in my SP how can I capture them in a sql table
1 replies
Hi. This is my first time posting. I'm not new to SQL, but I'm not an expert either--I'm still lear…
2 replies
Ideally would like output like this The following live in a house owned by Bob Sam , Sill and Bill…
4 replies
When run following query I'm supposed to see "1" but I simply don't select (3.0/23.0)+(4.0/2…
3 replies
I wrote the following SQL, but I know there has to be a better way to do what I'm trying to accompl…
10 replies
I am trying to update a table that i have with a portion of the procedure below. When ever i update…
2 replies
i have a table, and i need to take only the last 6 months data from it. the problem is that t…
9 replies
Hi I'm looking for an efficient way to substitute parameter values into a varchar containing a form…
4 replies
hi, I have a situation where i need to pass concatenated string ex: '002050053','002050…
4 replies
Is there an easy way to select a random 15,000 from a 100,000 records. the only fields I want is la…
2 replies
Hi, Does anyone know performance wise, which better a view or a subquery? Cheers Reet
1 replies
Viewing 15 topics - 6,661 through 6,675 (of 17,082 total)
You must be logged in to create new topics.