Topics
Started by
Posts
Last post
Hi, I have used select,insert and delete in open query(from mssql to oracle) , but I don't how can …
6 replies
Hi, Below is the Exception: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'I…
7 replies
Can some one please provide me the script to find who installed the sql server and if it is a group…
7 replies
Got this sample which works: SELECT TOP (5) ROW_NUMBER() OVER(ORDER BY somefield DESC) FROM somet…
8 replies
I have a temporary table that can have anywhere from one to maybe 15 records each day. I am trying…
6 replies
Hi, I need help with the sql to update column values in a table. I have a table of imported data f…
2 replies
Hello All, A quick question to all regarding my query. Below statement adds 7 days to the shipment …
1 replies
I need to insert some rows from a temporary table into a persistent table. The persistent table ha…
2 replies
I have 2 tables - a user table (TB_USERS) and a user customer table (TB_USER_CUST). I want to selec…
2 replies
Hi, I have created a view using the query below which is based on dates within my RMMarketingPrice …
6 replies
G'day. I need some help converting the output from a pivot statement to HTML. I can't seem to get m…
1 replies
Hi all I'm running SQL 2005 with SSMS 2012. I've got a table with the following fields: Visit ID Ab…
6 replies
Hello experts! I need your help. I would like to calculate the date gap between the first terminati…
47 replies
my result set is like this.But i want to pivot the result. I used both the cobination of pivot and …
7 replies
HI all I have a master table with item_no as one of column Ex: table name:Table1 ITem_no 1 2 3 Tabl…
6 replies
Viewing 15 topics - 331 through 345 (of 12,234 total)
You must be logged in to create new topics.
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy