Topics
Started by
Posts
Last post
I am a C# program (.net 2.0) using Sql Server 2005. I would love nothing more then to do all of m…
4 replies
I have a table that I want to count the number of distinct rows in but I need base it off of two co…
3 replies
I currently have a select where for one of the fields I need to change the output if it is null or …
5 replies
Hi Frenz I am trying to import a large csv file to my SQL server the file is of size 2 gb. I am usi…
2 replies
I have a list of names like this: John Smith Bob Johnson Earl Time I need convert these to this: Sm…
6 replies
When constructing WHERE clauses, I know that non-sargable clauses should be avoided. Is this the ca…
5 replies
Hi! I'd like to perform the following query Select Name, ( SELECT ali.ItemValue FROM Attribu…
8 replies
I have a table which has structure something like ID ColA ColB ColC 1 1 1 0 2…
2 replies
Now I am not a big fan of using IN statements. I prefer to use a join whenever possible. However,…
2 replies
I log activity to one table in my database. In the case of nested stored procedures, when an error…
5 replies
I have an Arithmetic overflow error converting nvarchar to data type numeric. My query looks like …
5 replies
Here's what I'm trying to accomplish: Identify rows from table1 where table1.reg_id = table2.reg_id…
8 replies
Hello All, I am trying to setup a SP where by I would pass in an integer value and based on that va…
3 replies
Im trying to write a query that will take 2 dates, a start and an end date, from those it will retu…
2 replies
Hi I am trying to insert data from table A to table B. I need a trigger on table B to check the no…
6 replies
Viewing 15 topics - 8,146 through 8,160 (of 12,234 total)
You must be logged in to create new topics.