Topics
Started by
Posts
Last post
declare @tbl table(stdate datetime) insert @tbl select '12-31-2011' declare @date datetime set @dat…
5 replies
Hi I am designing a database for travel application, it consist Hotel,Flight,Package,Transfers,Cars…
40 replies
Hi everyone, We are in the process of enabling RCSI on our operational data store databases in SQL …
6 replies
ALTER PROCEDURE [dbo].[spGetDecryptDataTes] ( @caseid varchar(max) ) AS BEGIN DECLARE @hexstr v…
6 replies
I'm trying to write a stored procedure using a pivot table and I can't seem to wrap my head around …
15 replies
After migrating to SQL 2008 from SQL 2005 we are getting random Time out expired errors. "Timeout e…
6 replies
At this point I am not able/ready to upgrade my packages, but I need to run them on a SQL 2008 serv…
3 replies
Hi everybody, thanks in advance for your answers. Hey i'm really just new as a DBA but definitely s…
23 replies
When I run the following: exec master.dbo.xp_fileexist @filePath I always get 0,0,0. The @filePath…
3 replies
I'm trying to create a linked server to a DB2 database on AS400. However, I'm not able to run queri…
31 replies
Need help in pivot and sp_transform . I have a stored proc to calculate the no of people contacted …
12 replies
Dear sir, I want to fetch the employee details with different filter conditions whose schema defin…
16 replies
Hello Friends, Hope all is well and wish everyone happy holidays!! I am trying to create an ssis pa…
2 replies
Hi, id like to know if anyone find some solution that doesnt involves use Cursors or Loops.. My sce…
8 replies
8 replies
Viewing 15 topics - 19,996 through 20,010 (of 30,225 total)
You must be logged in to create new topics.