Topics
Started by
Posts
Last post
I have two views that I have created. The first view is used by the second view as criteria. What…
3 replies
Hi all, It's a long time since I had to do anything like this, and I really can't remember how. I n…
12 replies
SQL 2008 R2 In a database I can successfully run: select count(*) from dbo.Check_Transaction_B…
7 replies
I tried searching the site without any luck. I figure there must already be several articles/posts…
5 replies
Hi All Let me explain the scenario. Table1 Having information Customer 1st Name and Table2 having…
1 replies
Hi I have two tables tTimetable and tStaffTimeTableInfo. tTimeTable has the following fields DayID …
15 replies
What is the syntax for a table level constraint ? Can any one post an example please? Thanks in adv…
1 replies
SORs$A13:M select * from [SORs$A13:M] I want to import more than 100,000 rows but openrowset stop…
1 replies
I'm extracting numbers from a text field and I keep getting this: Conversion failed when converting…
4 replies
I've run into a scenario where I need to set ANSI_NULLS to OFF - meaning that I need for NULL = NUL…
4 replies
Dear All, My query is related to handling null values in calculating the average at…
17 replies
Hi.. I have a select statement like this: Select distinct(convert(varchar(6), date, 112)) as month …
2 replies
Hi Is there a way to findout whether a particular sql server/database is used as linked server in …
2 replies
Source table is something like: Order Amount -------------- order1 $2,000 order2 $1,000 order3 $3,…
21 replies
I'm receiving the below errors when running the following script. I have been looking at this for a…
2 replies
Viewing 15 topics - 8,251 through 8,265 (of 10,647 total)
You must be logged in to create new topics.