T-SQL (SS2K5)
-
Topics
-
Update and Except question.
Setting: 2 tables, tblOld and tblNew. Neither table contains a primary key. I want to obsolete thos…
-
Export SQL Server 2005 Table to Excel 2007 using T-SQL
Hi guys, I ve got a situation where one of my colleagues wanted to export data in his table (He use…
-
How-to-return-next-values-and-concatenate-with_string (SQL Server 2012)
Hi there
I have a source table called Table A (see image) and i want to read all the data into… -
Character matching into patterns plus counts
In my case I am trying to see if there has been anyone who has devised a way to obtain an output th…
-
convert an INT field into a datetime field
Good Day to all, I'm in the processes of creating a SSRS report but have a couple of stumbling bloc…
-
State County City Problem
Im dealing with address data, and based on the schema I have, I can't query to answer the following…
-
LEFT JOIN with OR - performance
Hi, When I add an OR into a LEFT JOIN condition, it becomes horrendously slow. It's not just twice …
-
Converting Text to XML
I'm pulling data out of a DB where they decided to store XML data with a text data-type. I'm tryin…
-
unicode data/UTF-8 characters
I updated my question for better understanding: how to search ,update, and delete utf-8 data from s…
-
unicode data
how to search ,update, and delete utf-8 data from sql server 2008 express (especially amharic data)
-
Using T-SQL or SQL script can we create a data dictionary
Hello: Is it possible to create a data dictionary for all the tables in a SQL database using …
-
Sql query to convert varbinary to datetime
Hello guys, I would like to get the sql query to convert varbinary to datetime. Here is the value i…
-
CONVERT nvarchar to numeric
I need to sum up numeric data from an analysis cube however #miss is shown on the fields with zero …
-
SQL 2005: Error calling a sproc from my new sproc
I'm going through our existing sprocs (which we don't own rights to modify) and writing sprocs to c…
-
Pass param to Stored proc
exec sp_executesql N'xp_cmdshell ''ping @id''' How can I make the above code run ? I want to pass …
Viewing 15 topics - 211 through 225 (of 12,234 total)
You must be logged in to create new topics.