Topics
Started by
Posts
Last post
I have a parameterised query here I pass one parameter In query parameter name @path. Now I want to…
5 replies
By: Garadin
I have the following code that retrieves tha last characters '200BB' The value is variable so it co…
12 replies
Hi all, I'm trying to rewrite the following function that we use to trim certain catalog numbers in…
36 replies
I am trying to write SQL to write the SQL to alter all columns in a DB from char to varchar. DECLA…
9 replies
I am running a simple update query as follows: UPDATE WTABLE SET CaseSel=0 WHERE TablDKey=5281. The…
2 replies
I have this query and I need it to return distinct lc.email field select top 1000 …
6 replies
declare @t1 table (i int) declare @t2 table (j int) insert @t1 values (1) insert @t1 values (2) ins…
7 replies
OK - I've done this lots of times before with no problem. But now I cannot seem to get a stored pr…
5 replies
Is there a way to suppress the display of result sets? I am performing a loop that does a number o…
2 replies
Hi guys, I want to select records from the database, i need to pass start index and end index, then…
12 replies
Hello ALL, I have 3 tables and each table has 3 columns. For example, table 1: DDS CTCLEARED …
4 replies
This appears to not be allowed. Any suggestions? FWIW, I am trying something like the following...…
3 replies
I am using SQL server 2005. I have a Stored Procedure that dynamically creates a table with a tabl…
7 replies
By: GSquared
I am writing a trigger where i need to execute the db mail on the basis of field condition. That me…
6 replies
Hi, I have a SP, which will return rows of data. I want to run this procedure as a nightly batch us…
1 replies
Viewing 15 topics - 7,651 through 7,665 (of 12,234 total)
You must be logged in to create new topics.