Topics
Started by
Posts
Last post
I have two tables user and user_role. Userid is primary filed into user table and foreign key in us…
5 replies
Hi, We have to retreive the Binary Images from SQL Server 2005 database with out affecting the da…
1 replies
Hi All, I am using Pivot in my query.My problem is that i want to add Average column of Pivoted co…
1 replies
I am trying to get avg duration for each minute. I am not able to group by minute. Startdate is dat…
4 replies
Hi there, I am writing a simple report using SSRS 2005 where user selects the start date and end da…
14 replies
Hi, At my place of employment we have a SQL 2005 installation thats running on Windows Server 2003.…
3 replies
In my table i have following result sets sno 101 102 103 105 106 107 i want following structures 10…
3 replies
Hi All, I want to find Hierarchy of managers for specific employee. For example if I run query for …
1 replies
Hi All, Please suggest me an idea on the below scenario. I am having table which contain studentid,…
2 replies
i am using CTE in following ways with CTE1 ( select * from xx ), CTE2 ( select * from test inne…
2 replies
Hi , One of SP is having below code and it is running more than 2 hrs. This job is daily schedule. …
3 replies
I am trying to read data from the following sample XML file. I have tried SSIS XML task to remove n…
3 replies
In the query below: select right(convert(varchar, CCD.startDateTime , 106), 8) as startmonth, su…
16 replies
I have query as follows: select right(convert(varchar, CCD.startDateTime , 106), 8) as startmonth,C…
4 replies
I have the following challenge. I would like to parse XML data into a relational table. <NSTRoot…
1 replies
Viewing 15 topics - 181 through 195 (of 4,155 total)
You must be logged in to create new topics.