Topics
Started by
Posts
Last post
Hi Chaps, I need to pull data from a complex DB, and consolidate it into: MONTH, LOCATION, Metric1,…
1 replies
i've table and data as following, declare @t1 table (idx int identity, acctInfo int, menuCollectio…
3 replies
I have seen a few ways to delete duplicate rows, but I can't seem to modify it for my needs. Here i…
2 replies
is it possible with new features in sql to do the following: row1:1,2,3,'a,b,c',4 row2:1,2,3,'e',4 …
2 replies
I've got a relational database structure where "assets" are defined in one table and their latitude…
2 replies
I am using a merge to populate a target table. This table has a new column which takes identity va…
2 replies
I am on project of migrating databases from Sql Server 2005 to 2008. During test I found one incons…
6 replies
Hi All, Would it be a good idea to convert all my insert statements (which loads static data) to m…
3 replies
I have a table with account, period, and balance and I'd like to age these balances out so that I h…
9 replies
Hi all. I need help (again) trying to get the cursors out of my queries. I have the following tabl…
14 replies
Does anyone have script to transfer the users permission from one SQL Server to another SQL Server …
5 replies
hi all, i have some files in folder and each file name contains some text that i want to remove suc…
4 replies
This is an important problem for me, that I have spent a lot of time on. So, I have simulated my p…
17 replies
I see we have an existing stored procedure that does something like this: CREATE PROCEDURE [dbo].[S…
5 replies
I have a difficult task here. Say there's a column in a table called CityState. The column can ha…
9 replies
Viewing 15 topics - 7,756 through 7,770 (of 10,647 total)
You must be logged in to create new topics.