Topics
Started by
Posts
Last post
Ok, I'm sure someone has a better way of separating this data than using CHARINDEX.... 10.1.1.% 10…
4 replies
I have a client who wants a database created for each job they undertake. It works like this: In t…
4 replies
I have a table with 800,000 records that we need to test if the generated name that the records sho…
13 replies
I am trying to pull a field where if the data value has 8 characters, strip off the first and last …
3 replies
IN SQL 2000 I am calling a stored procedure from within another SP using exec(). In the calling SP…
4 replies
Hi, I'm trying to convert some denormalized COBOL data into a SQL Server 2005 table. I'm hoping fo…
5 replies
Hi Every body, Unfortunatuly i had delete some row in my table in Quary Analysier How can i retirve…
1 replies
Is there anyway to "short-circuit" a query? The following query generates the same "actual executio…
13 replies
One of our applications allows dynamic filtering based on user inputs. For example, a user can sele…
3 replies
hi guys, i have this query in an ssis package but i don't seem to understand the operators > ? A…
1 replies
I have the following Table UDF: CREATE FUNCTION dbo.udf_GetBankAccountsExpected(@AgentIDInput Int, …
5 replies
Hi I need to know how gud it is to use subqueries in a sql query in place of field selection. I hav…
1 replies
Hello I have this stored procedure writen like this: USE [db] GO /****** Object: StoredProcedure […
3 replies
I have a sproc with a datetime parameter default, as: @Startdate datetime = getdate I'm expec…
3 replies
I have several stored procedures in my database that are used to load data from a datamart that is …
10 replies
Viewing 15 topics - 8,716 through 8,730 (of 12,234 total)
You must be logged in to create new topics.