Topics
Started by
Posts
Last post
Recently I got into a discussion w/ a coworker over the primary key of a fact table. He wanted to p…
25 replies
hi I want Compare two Table data and insert changed field to the third table who can help me thanks…
13 replies
Hi there, i would like to reach out in converting rows to cols. Format: NodeName|upsBasicIdentName|…
3 replies
Hi guys, I'm trying to come up with a query for this data: CREATE TABLE #Visits (OpportunityID int,…
3 replies
Hi When I create a table in sql server database name appears in prefix of table. My database name: …
1 replies
Hello All, I am trying to tie together tables that show quantities of a product committed to an ord…
9 replies
I HAVE TO WRITE ONE STORE PROCEDURE THAT EVERY MIN IT HAS TO CHECK MY SQL INSTANCE IS UP AND RUNNIN…
7 replies
Hello, We have a Item table and a Price table. Structure is mentioned below. An Item need to be mat…
2 replies
I have a Function where I want to put a character in a particular position in a Destination string.…
2 replies
Set up a trace with the events RPC:Completed, SQL:BatchCompleted, SQL:BatchStarting, and SQL:StmtCo…
11 replies
If you use the LEFT() function for example it provides intellisense support for some of the require…
4 replies
I have the following scalar function to calculate business hours: CREATE FUNCTION dbo.business_hou…
3 replies
Hi, I would like to force this script to look at the Dev Server only to avoid running it accidental…
9 replies
G'day was reading Distinct function on technet. There is a bit about VALUES FUNCTION. Anyone has i…
4 replies
Hi there, I am trying to join two tables that visibly doesn't have any thing unique as they come f…
5 replies
Viewing 15 topics - 3,856 through 3,870 (of 4,984 total)
You must be logged in to create new topics.