Topics
Started by
Posts
Last post
Ok, someone tell me there's a faster way to do this. I have a table with 37k string fields (open en…
3 replies
Hi, I have ClientID, Client rank. 42A 42B 42A 43A 44A 44B 44A 44B 45A 45B 45B 45A 45B …
7 replies
I think this is a pretty common problem, but I haven't found any solutions yet. I think part of the…
22 replies
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
Viewing 15 topics - 8,236 through 8,250 (of 10,635 total)
You must be logged in to create new topics.