Topics
Started by
Posts
Last post
I'm not sure that using the PIVOT function is applicable here (i've tried to get it to work!) but i…
2 replies
I'm having an issue with trying to have a query run for todays date. I'm not sure how to have it co…
27 replies
Hello All, I have a people table with email column, for each company i need to get the generic emai…
11 replies
I have a stored procedure that is causing exceptions to be thrown regularly in my ASP.NET app. The …
2 replies
Hi, I need some help with a query... I have an orders table DROP TABLE #orders CREATE TABLE #orders…
5 replies
Hello all, I try to create a Backup Database on a linked Server using dynamic SQL. But I fail when …
2 replies
Hi I would like to flatten a relational representation of a transaction to 1 row. However because t…
32 replies
Some of the columns in our database has datatypes of text and varbinary(max), as we cannot do onli…
2 replies
Hi Friends, I need to export the data using the pre created excel template from the Stored procedur…
2 replies
I have inventory parts in a system that are the same family of parts and I want to compare them for…
5 replies
Hello Everyone a colleague & I are having a discussion about CASE Statement and an IF Statemen…
5 replies
All, I have a requirement. create table #temp (name varchar(50) ) insert into #temp values ('karthi…
8 replies
Is there a better way to write the following query in terms of performance without adding any index…
2 replies
Dear all, i need to generate the locations id depends up on the state as well as track number is …
8 replies
Below is my stored procedure that creates a temp table then based on a different table it creates n…
9 replies
Viewing 15 topics - 3,856 through 3,870 (of 12,230 total)
You must be logged in to create new topics.