Topics
Started by
Posts
Last post
Hi, I have this structure of stored procedure : CREATE PROCEDURE sp1 ( @ret varchar(100) output ) A…
13 replies
hi friends, i think people in this group hate cursor and i agree with it. Just looked into our exis…
4 replies
Hi all, I need to create sql script which will go through all records and find smallest unused numb…
38 replies
I want to pass selected Ids to stored procedure to get details from client table. If I dont pass se…
11 replies
is this the best way to concate the date and time field in terms of performance of the query? creat…
7 replies
Hi I have a simple Pivot table query that lists customer services, this is used for to make reporti…
7 replies
DECLARE @MaxPartitionNumberToPurge int DECLARE @MinActivePartitionNumber int DE…
6 replies
Hi All Here i am little bit confuse i have query with join condition and i need to apply an index f…
3 replies
If i have the following table CREATE TABLE [dbo].[Visits]( [Id] [int] IDENTITY(1,1) NOT NULL, [Da…
2 replies
Can anyone provide me an information for creating an index for the below mention query . Thank you …
4 replies
I have a name field that I'm trying to retrieve the suffix (JR, SR) from. I have a table of valid …
4 replies
Hello Everyone I am in need of a way to concatenate values that have matching ID's and SubID's and …
3 replies
Hi, I want a code for how to create a seperate function outside,i have a parameter in my pr…
1 replies
Hello friends, I am in the middle of tuning a query and need your advice on this. The first look at…
6 replies
Hello, I've created one SQL Server profiler template to catch all deadlocks/locks in a specific dat…
2 replies
Viewing 15 topics - 7,126 through 7,140 (of 10,635 total)
You must be logged in to create new topics.