Topics
Started by
Posts
Last post
Hi! Can anybody helps me how to optimises a SP by using SQL Server profiler? What are the parameter…
4 replies
I am querying tables in some reports that may or may not exist at the time the report is run. I wan…
6 replies
Is it possible to specify TableNames, ColumnNames as stored procedure parameters for be used in a S…
1 replies
for example: USE pubs GO /* Now is there a T-SQL statement to return which databasename I am c…
2 replies
I am looking to "match" addresses in two separate table from different vendors. Matching addresses …
2 replies
Hi everybody! I have 5 columns in a table that contains the same type of values (the last 5 in the …
2 replies
I need to do a SELECT statement that will return results of different value in order by datetime st…
1 replies
Me again... I was in need of having an "Account" point to another "DebitThisAccount" for billing pu…
1 replies
Say I have a table Job with columns Start and End (both datetime). For the job that is still going …
4 replies
First, thanks for reading ... As to my needs, I obtain a flat text file each month that includes bo…
1 replies
I have two tables tbl_tracks TrackID (identity) TitleID (int) ArtistID (int) tbl_disc_tracks …
6 replies
I have two tables in my database. The first table has rows and the second table is empty. I want to…
5 replies
Hi everybody: I have this dynamic select statement: declare @comp_failed as int SET @strSQL = 'SELE…
10 replies
Hello, This is my first time working with the 'INSTEAD OF DELETE' trigger, and I am going to try my…
1 replies
I have on SP. If I run SP thru QA it takes 1 min 50 sec. But If I copy all statements from SP to QA…
10 replies
Viewing 15 topics - 16,171 through 16,185 (of 17,082 total)
You must be logged in to create new topics.