Topics
Started by
Posts
Last post
can we use (select * into) with union statement . If so what is the syntax
3 replies
In select query values with space appended takes higher precedence than normal characters . How to …
1 replies
Hi all, In my DB i have a 1:M relationship between contact and incident tables(a contact can have m…
12 replies
I have a column in a table with ntext datatype contains xml, I want to use xquery to shred xml to r…
3 replies
Hi All my function is --drop function priority create function priority ( @nRequestDetailsID…
1 replies
Can anyone give me advice on the simplest way to turn the following separate views into a stored pr…
4 replies
I have a database that has a product table. This database also has a Quote table. For the Quote tab…
7 replies
Hi , I am wondering if case is allowed in pivot. For example, instead of directly doing pivot( sum(…
1 replies
I have an SSIS package in SQL Server 2005 that I would like to execute from within a VB.NET applica…
3 replies
Guys I made the variable @nsql nvarchar(max) to be used for dynamic sql. When I execute using sp_ex…
14 replies
Hello: I am using the except function in SQL Express 2005 to find unique records between two tables…
1 replies
We found the below error while i'm trying to access / delete the table in one database. Error messa…
4 replies
How do I obtain a sum of a field, when I have multiple records for the same item? Specifically, the…
3 replies
Hi everyone I need help with sql select statement.I have table and in that table some columns have …
3 replies
Hi, I have a table from which I need to delete duplicate records. I dont have identity col and i ca…
5 replies
Viewing 15 topics - 1,666 through 1,680 (of 4,155 total)
You must be logged in to create new topics.