Topics
Started by
Posts
Last post
I have a query that runs on 4 different databases and they are virtually identical. All the databa…
3 replies
Does anyone know how the BCP utility functions behind the scenes? I am using it for a query out exe…
6 replies
Hi I want to retrieve date from description. Following is the code I am using it now,But I have to …
1 replies
HI. I need a date table that has all the dates from 2000 till today. the Table should look like as…
11 replies
Hi all I’ve been using this brilliant solution for FIFO calculation that is found here, (Dave’s one…
5 replies
How can I update multiple values in 1 table based on the values from another table, do i need to us…
15 replies
Hi Gurus, Could you please tell me how to prepare a demo database for sales team? I have to write …
9 replies
I am working in an SQL Server 2008 R2 environment and I wish to add a routine to my T-SQL script th…
4 replies
I am urgently in need of some help. My colleague and I have developed a script (that works) but use…
8 replies
I'm wanting to query an XML site, which is really just an RSS feed. I want to be able to put the d…
3 replies
I have a table where it lists all the "ServerName", "DBName", "DBSize", "Date"...but this table has…
6 replies
I have a trigger that will write out an audit trail record with the changed values to an audit file…
5 replies
Hi, I had been working on some code improvements for performance gains every now and then. I was go…
2 replies
I'm trying to do in a script: SET @DYNSQL = 'USE ' + @DBName + ' SELECT name AS [File Name] , phys…
3 replies
Hi all, I am new to sql server, How to write a trigger which stops the DML operation on a table for…
16 replies
Viewing 15 topics - 6,001 through 6,015 (of 10,647 total)
You must be logged in to create new topics.