Here's a few of the new posts today on the forums. To see more, visit the forums.
SQL transaction and lock of the table for SELECT
- Hi to all
I am very new in SQL Server world. I was working with Oracle more of 10 years.
Export table data to UTF-8 text file problem
- Running: Microsoft SQL Server 2005 - 9.00.3152.00 Enterprise Edition SP2 Enterprise Edition (Intel IA-64)
I need to export data from a table...
for each loop files in folder starting with @[User::strFileNameStart] + "*.csv"
- I have an folder with multiple files .
For passing the folder, i have set the Directory expression as
@[User::strFinSourceFolder] + "\\"
Pass SQL Execute task output to target tbl(Data flow).
we need to insert random values to target table.
We are using the query in SQL Execute task with single row...
Using Dense Rank
- CREATE TABLE [REV_BINDERS](
[OFFICE_ID] [int] NOT NULL,
[BINDER_ID] [int] NOT NULL,
[BINDER_NO] [varchar](7) NULL,
INSERT INTO [REV_BINDERS]
select 2105110,10,0101 union all
select 2105110,12,0102 union all
A problem with using full text search with wildcard query
I have a weird case with the full text search in Sql Server 2008 R2 SP1 web edition.
I have a...
sql query implementaion
- hi friend i have a small doubt in sql server plz tell me how to solve
table data contins like...
Running SSIS packages
I have 15 packages in dev server , at first instance we need to execute 7 and next 8 in the...
locking in DML statement
what is the difference between IX and X lock on a table?(Totally I plus s,x,u,etc.)
according to what i have read,'I'...
Alternative to xp_cmdshell
- i need to delete some backup files as per daily operation through SQL ,currently i am using xp_cmdshell ,is there...
Mirroring Endpoint Port Number
I want to configure database mirroring with automatic failover option. That is why I want to make my PC as...
How to Know server is in SRDF
- We have SRDF DR setup in our SQL env and one common question which arise everyday is how can one...
Replace a substring using Powershell
I've got a job, one step of which adds some articles into a publication:
[code="sql"]$DBScriptFile = "C:\Scripts\RO_replication.sql"
Invoke-Sqlcmd -ServerInstance localhost -database master...
TSQL Problem: Week between 2 different months
I have a script problem.
I calculate data per week (group by week)
However, for indicators, I have business rules which apply...
Thousand Seperator Magic
I have recently faced the below scenario.
i.e to add comma as the thousand seperator
I have searched here and found the...
I have a scenario in which i need to create a function which takes 2 parameter (count,startdate).
If I have...
Help On Execution Plan Status
- Hi All,
I am a newbie in SQL Server and like exploring it. Currently i was working with some complex queries...
- I've a table like below:
[code="sql"]CREATE TABLE #Emp
( Emp char(6), UplineEmp char(6), Lvl tinyint) ;
insert #Emp ([Emp], [UplineEmp], Lvl)
Recursion with a Twist
- Hi - can't seem to get my head around this one, so any assistance is welcome.
I am trying to write...
Problem With AdventureWorks
I am new to this forum and would like some help with SQL Server 2008 R2 Express. I downloaded SQL...
SQL server 2008r2 instlation
i tried to install sql server 2008r2 in mixed mode any one help on this.
SCOM on SQL Server 2008 SP1
- Hi All,
How can I know id SCOM is installed on my server or not. If yes, is there a place...
How do I remove Attunity 2.0 from my development machine
- Okay - I'm running a dev instance on Windows 7 - which when I build, I added attunity 1.2, and then attunity...
Numeric Dimension Attribute in SSAS 2008 R2
- Good evening to all.
I use SSAS 2008 R2 and i did some cubes.
I built a dimension PRODUCT that contains 2...
QR Code-Integration of Microsoft Access and Microsoft Word
- What is the easiest way to integrate Microsoft Access and Microsoft Word?
We are converting permit numbers to QR code. 00000...