Topics
Started by
Posts
Last post
I have a point that I am buffering by 1 mile to create a circle. I want to divide this circle (pol…
1 replies
I have the following tables: Products (Product_id,Product_Name,Product_Type,Cost_Price) Sales (Sale…
10 replies
I'm trying to do the following in SQL 2008 ..... where if @openorder>1 then o.openorder=1 or o.o…
13 replies
I have an XML file that I need to import and insert data in to a table. The XML looks like below: …
6 replies
Hi everyone, I have a simple trigger that updates another table when a new value is inserted. Basic…
19 replies
I have column in my table with type varchar. My application having a search crieria and its looking…
5 replies
hi folks this is proboably a really simple problem, but i just can't see the wood for the trees he…
2 replies
Our company has used Linked server to get the other db server data . Now we are trying to replace t…
5 replies
I have a user report that runs in > 1 minute in one environment and takes over 22 minutes??? The…
3 replies
Hi Friends, I have created a SP - Dynamic Merge for SCD type 1 and Type 2. When I execute the SP …
1 replies
How do you something like this? :hehe: CREATE TABLE [dbo].[Tbl]( [field1] [smallint] NULL, [field…
11 replies
I've got this far to generate financial years. From an arbitrary start date it counts each financia…
4 replies
How do you create a connection to an Excel file (either Excel 2010 or 97-2003), from a SQL database…
10 replies
Can you briefly explain the working of below query select DATEDIFF(MONTH,0,getdate()) In my machine…
7 replies
Hi, I do not understand why I get different results when running the two SQL statements below: SELE…
3 replies
Viewing 15 topics - 6,016 through 6,030 (of 10,635 total)
You must be logged in to create new topics.