Topics
Started by
Posts
Last post
Hi, I am using SQL Server 2008 R2 I hav this code DECLARE @Document INT INSERT INTO C_Documents…
12 replies
Hello, I wanted to know how to use scalar valued function in select statement. Right now I have a s…
8 replies
I am trying to build a script for dynamic rebuilding of indexes. Hefereo I am planning to use a cur…
4 replies
Hi I am trying to find a logic to do this. I have to create package in SSIS,for source I want use S…
3 replies
I thought COALESCE had 2 parameters. http://www.sqlservercentral.com/Forums/Post.aspx?SessionID=zfj…
12 replies
Experts, interested in cleaning interesting (bad) data ;-). I want to compare the text between 1st…
10 replies
hi simple question, what does the ^ do in t-sql? it's eluding me on google thanks EDIT: aha, bitwis…
2 replies
I have a sproc that accepts a tvp. The tvp is defined as a one column user defined table type. The …
7 replies
Hello I am using select into a temporary table as part of an etl package. There are multiple packag…
16 replies
Can I create a table since a store procedure in Sql 2008? I need to send the name of the table and …
1 replies
I want to include the schema as one of the columns since the tables are duplicated in two different…
10 replies
I am replacing my "end date" to getdate () when it is null.Something like below isnull(temp.end_tim…
3 replies
Hi, I have the following table: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING …
21 replies
Hi everyone, I have table named ENCOUNTER_PARTY CREATE TABLE ENCOUNTER_PARTY( ENCOUNTER_KEY INT, PA…
12 replies
The INDEX(1) query hint forces the query to use an INDEX scan or seek. Are there exactly two ways …
1 replies
Viewing 15 topics - 5,686 through 5,700 (of 10,647 total)
You must be logged in to create new topics.