Topics
Started by
Posts
Last post
I have been trying to delete the duplicate rows from a table. I want to keep only the rows that hav…
8 replies
I have the following XML text file that needs to be flattened or shredded into a SQL Server table: …
10 replies
I have a table that contains records which has a primary key consisting of a memberID, enrollmentID…
3 replies
When connected to the Management Studio on a SQL Server 2008 R2 server, I modified an existing tabl…
2 replies
Hi i have below query. SELECT * FROM( SELECT YEAR(calldate) [Year], --COUNT(REQUESTS.reqid), CASE M…
1 replies
Hi All, create table temp (a int, b int, c int, d int, e int, f int) insert temp values…
11 replies
hey. i've been dabbling with xml for the past few days and from the vast searches i have made i alm…
3 replies
Hi – I am using a Stored Procedure from where our SSRS report runs but now our report takes really …
29 replies
Hello I'm trying to insert html like the below into a table. Simple. But I am lazy and cannot be bo…
15 replies
I'm working on a new view and could use some guidance. The task is to create a view which produces …
6 replies
I need a query to parse and split the string into columns. Declare @ string varchar(8000) Set @Stri…
1 replies
Hello All, I am assigned to create a data dictionary for the database. Does anyone has the template…
1 replies
Hello All, I have a requirement like this. I have 15 columns. I need to get my result set like this…
12 replies
I just altered my table as follows: ALTER TABLE dbo.EpisodePackage ADD WebTagBroadViewId va…
11 replies
I want to execute a bunch of commands (built from values in a table) using xp_cmdshell. However, it…
1 replies
Viewing 15 topics - 6,991 through 7,005 (of 10,647 total)
You must be logged in to create new topics.